查询一个表中 3个ID,的5条数据
测试 查询一个表中 3个ID,的5条数据;等待高手提供好的代码中:
自己写了一个由于循环太多,还不如thinkphp提供的单条查询组合快.
<?php
$t1=microtime();
//starttime
$dsn = "mysql:host=localhost;dbname=magazine";
$db = new PDO($dsn, 'root', '', array(PDO::ATTR_PERSISTENT => true));
$db->setAttribute(PDO::ATTR_CASE, PDO::CASE_UPPER);
$rs = $db->query("SELECT * FROM content order by titleid");
$array = array(40,44,45);
$Ay = array(0,0,0);
$arr =array();
while ($row = $rs->fetch(PDO::FETCH_ASSOC)) {
foreach($array as $key=>$num){
if($row['TITLEID']==$num){
$arr[]=$row;
$Ay[$key]+=1;
if ($Ay[$key]==5){
unset($array[$key]);
}
break;
}
}
}
$t2=microtime();
//endtime
echo $t2-$t1.'<br>';
//时间0.003067
$t11=microtime();
$arr = array();
$arr[] = $news->where('titleid=40')->limit(5)->select();
$arr[] = $news->where('titleid=44')->limit(5)->select();
$arr[] = $news->where('titleid=45')->limit(5)->select();
$t22=microtime();
echo $t22-$t11;
//时间0.00081301
?>