有的时候你可能会用到查一次查询返回若干个结果,在php里现在不是什么难题了。
view plaincopy to clipboardprint?
$rows = array ();
$db = new mysqli('127.0.0.1','root','123456','user');
if (mysqli_connect_errno()){
$this->message('Can not connect to MySQL server');
}
$db->query("SET NAMES UTF8");
$query = "select * from `user`.`user` limit 0, 50;";
$query .= "select count(0) as `count` from `user`.`user`";
if($db->multi_query($query)){
do{
if($result = $db->store_result()){
while ($row = $result->fetch_assoc()){
array_push($rows, $row);
}
$result->close();
}
}while($db->next_result());
}
$db->close();
本文来自CSDN博客,转载请标明出处:http://blog.csdn.net/jxncwzb/archive/2009/11/13/4808421.aspx