doutangliang7769 2010-09-30 21:07
浏览 26
已采纳

什么应该在PHP中使用PDO语句返回print_r?

$dbh = new PDO ("sqlite:/Library/WebServer/Documents/nwind2009.db3");
$sql = "SELECT * FROM Customers";     
print_r($dbh->query($sql));

This returns:

PDOStatement Object ( [queryString] => SELECT * FROM Customers )

but if I do:

 foreach ($dbh->query($sql) as $row) {
    echo $row['CompanyName'];
 }

I get the data.

Why doesn't print_r show the database results? What special thing is happening in the foreach? I thought print_r showed me the array and that that was what I was doing in my foreach.

Thanks.

  • 写回答

3条回答 默认 最新

  • dongzhan8001 2010-09-30 21:21
    关注

    If you iterate over the query, it will automatically fetch the data. This is a good thing, because the adapter will lazy load the data the moment it is actually needed.

    If you want to force the PDO adapter to fetch the data in advance, you can run the fetchAll method like so:

    $dbh = new PDO ("sqlite:/Library/WebServer/Documents/nwind2009.db3");
    $sql = "SELECT * FROM Customers";       
    print_r($dbh->query($sql)->fetchAll());
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?

悬赏问题

  • ¥15 爬取1-112页所有帖子的标题但是12页后要登录后才能 我使用selenium模拟登录 账号密码输入后 会报错 不知道怎么弄了
  • ¥30 关于用python写支付宝扫码付异步通知收不到的问题
  • ¥50 vue组件中无法正确接收并处理axios请求
  • ¥15 隐藏系统界面pdf的打印、下载按钮
  • ¥15 MATLAB联合adams仿真卡死如何解决(代码模型无问题)
  • ¥15 基于pso参数优化的LightGBM分类模型
  • ¥15 安装Paddleocr时报错无法解决
  • ¥15 python中transformers可以正常下载,但是没有办法使用pipeline
  • ¥50 分布式追踪trace异常问题
  • ¥15 人在外地出差,速帮一点点