脚本宝典收集整理的这篇文章主要介绍了php – 如何多个查询结果以减少查询数量?,脚本宝典觉得挺不错的,现在分享给大家,也给大家做个参考。
我的数据库中有三种类型的注释,我用三种不同的查询来调用它们.
//01 - Awaiting Comments $query = $handler->PRepare("SELECT * From comments WHERE confirmed = 0"); $query->execute(); $r = $query->fetchAll(PDO::FETCH_ASSOC); echo "<h1>AwaITing Comments</h1>"; foreach($r as $r_) { echo "<li>r_[title]</li>"; } //02 - Comments waiting for confirmation $query = $handler->prepare("SELECT * From comments WHERE confirmed = 2"); $query->execute(); $r = $query->fetchAll(PDO::FETCH_ASSOC); echo "<h1>Comments waiting for confirmation</h1>"; foreach($r as $r_) { echo "<li>r_[title]</li>"; } //03 - Confirmed comments $query = $handler->prepare("SELECT * FROM comments WHERE confirmed = 1"); $query->execute(); $r = $query->fetchAll(PDO::FETCH_ASSOC); echo "<h1>Confirmed Comments</h1>"; foreach($r as $r_) { echo "<li>r_[title]</li>"; }
Awaiting Comments -comment 1 -comment 8 -comment 5 Comments waiting confirmation -comment 9 -comment 4 -comment 2 Confirmed Comments -comment 3 -comment 6 -comment 7
$r = $handler->query("SELECT confirmed,c.* FROM comments c")->fetchAll(PDO::FETCH_GROUP);
是您需要的所有代码.
在这里,您首先选择已确认的字段,然后告诉PDO根据其值对结果进行分组(或“乘以”).
现在,您可以随时随地打印您的评论
// Awaiting Comments foreach($r[0] as $r_) { echo "<li>$r_[title]</li>"; } // Confirmed comments foreach($r[2] as $r_) { echo "<li>$r_[title]</li>"; }
$titles = [ 0 => 'Awaiting Comments',2 => 'Comments waiting confirmation',1 => 'Confirmed Comments',]; foreach ($titles as $code => $title) { echo "<h3>$title</h3>"; foreach($r[$code] as $r_) { echo "<li>$r_[title]</li>"; } }
以上是脚本宝典为你收集整理的php – 如何多个查询结果以减少查询数量?全部内容,希望文章能够帮你解决php – 如何多个查询结果以减少查询数量?所遇到的问题。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。