dousiyou1058 2013-06-12 22:16
浏览 60
已采纳

没有错误,但查询没有返回任何结果

Nothing is showing, and no error is output. I have defined $id. Any ideas?

<tr>
<td width="160">Price:</td>
<?php
    dbconnect(); 
    $stmt2 = $conn->prepare("SELECT Length, price FROM Product WHERE ProdID=:id LIMIT 1");
    $stmt2->bindParam('id',$id);
    $stmt2->execute();
    $i = 0;
    foreach ($stmt2->fetchAll(PDO::FETCH_ASSOC) as $row2) {
        if ($i == 0) {  
            echo '<td>'.$row2['Price'].'</td>';
        }
    }
?>
</tr>
  • 写回答

1条回答 默认 最新

  • dongwenghe2416 2013-06-12 22:21
    关注

    In you're SQL you try to select "price" (lower "p"), but you try to echo $row2['Price'] (upper "P"). Try this or change the p in "Price" to lowercase!

    <tr>
        <td width="160">Price:</td>
        <?php
            dbconnect(); 
            $stmt2 = $conn->prepare("SELECT Length, Price FROM Product WHERE ProdID=:id LIMIT 1");
            $stmt2->bindParam('id',$id);
            $stmt2->execute();
            $i = 0;
            foreach ($stmt2->fetchAll(PDO::FETCH_ASSOC) as $row2) {
                if ($i == 0) {  
                    echo '<td>'.$row2['Price'].'</td>';
                }
            }
        ?>
    </tr>
    

    If this is not working, try your SQL-code in PHPMyAdmin. If the data will be displayed, your SQL would be right.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 求差集那个函数有问题,有无佬可以解决
  • ¥15 【提问】基于Invest的水源涵养
  • ¥20 微信网友居然可以通过vx号找到我绑的手机号
  • ¥15 寻一个支付宝扫码远程授权登录的软件助手app
  • ¥15 解riccati方程组
  • ¥15 display:none;样式在嵌套结构中的已设置了display样式的元素上不起作用?
  • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥65 汇编语言除法溢出问题