dousuohe5882 2014-04-01 10:14
浏览 31
已采纳

如何使用mysqli查询获取行?

I am trying to fetch a row from my mysql DB using mysqli query.

PHP

$_SESSION['orderID'] = "632";
$orID = $_SESSION['orderID'];
$sql = $db->prepare('SELECT * FROM order_list WHERE order_id = ? ');
$sql->bind_param('s',$orID);
$sql->execute();
while($row = $sql->fetch()) 
{
   $productid = $row[0];
   $name = $row[1];
   echo $price = $row[2];

}

give no error in console and no result,

I have been trying to check the answers on stack overflow, I also googled it but all the suggestions gives me the same error.

I am pretty new with mysqli, your help will be highly appreciated

  • 写回答

1条回答 默认 最新

  • donglanche9257 2014-04-01 10:17
    关注

    mysqli_fetch_array is a mysqli_result method not a mysqli_stmt one

    You could use ->fetch() upon a mysqli_stmt

    So basically your code could change that way

    while($sql->fetch()) {
     //do something
    }
    

    but you need to call bind_result() before looping (otherwise you can't access returned values)

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

报告相同问题?

悬赏问题

  • ¥100 关于使用MATLAB中copularnd函数的问题
  • ¥20 在虚拟机的pycharm上
  • ¥15 jupyterthemes 设置完毕后没有效果
  • ¥15 matlab图像高斯低通滤波
  • ¥15 针对曲面部件的制孔路径规划,大家有什么思路吗
  • ¥15 钢筋实图交点识别,机器视觉代码
  • ¥15 如何在Linux系统中,但是在window系统上idea里面可以正常运行?(相关搜索:jar包)
  • ¥50 400g qsfp 光模块iphy方案
  • ¥15 两块ADC0804用proteus仿真时,出现异常
  • ¥15 关于风控系统,如何去选择