$db=new mysqli();
$db->connect("localhost","root",12345,"test");
$otime=microtime(true);
$db->query("set names 'utf8'");
$sql="select id,title,content from category where id=1 ORDER BY id ASC ";
$num=0;
for($i=0;$i<5000;$i++){
$result=$db->query($sql);
}
$ontiom=microtime(true);
echo "本次查询了".$i."条数据"."<br/>";
while($rs=$result->fetch_array()){
echo "id:".$rs['id']."|title:".$rs['title']."|content:".$rs['content']."<hr/>";
}
echo "使用mysqli查询".$i."条耗时".$time=$ontiom-$otime."<hr/>";
$result->free();
$db->close();
mysqli
最新推荐文章于 2024-09-24 07:29:36 发布