abstract：<?php//1、創(chuàng)建數(shù)據(jù)庫連接對象$mysqli = new MySQLi("localhost","root","123456","liuyan");if($mysqli->connect_error){ die($mysqli->connect_error);}$mysqli->

<?php
//1、創(chuàng)建數(shù)據(jù)庫連接對象
$mysqli = new MySQLi("localhost","root","123456","liuyan");
if($mysqli->connect_error){
 die($mysqli->connect_error);
}
$mysqli->query("set names 'GBK'");
//2、查詢多個數(shù)據(jù)庫表
$sqls = "select * from news limit 10,4;";
$sqls .= "select * from user;";
//3、執(zhí)行并處理結(jié)果
if($res = $mysqli->multi_query($sqls)){
//注意：與$mysqli->query()不同，這里返回的是布爾值
 do{
  $result = $mysqli->store_result();//這里才真正返回結(jié)果集的資源對象，失敗則返回false;
  while($row = $result->fetch_assoc()){
   foreach($row as $key=>$value){
    echo "--$value--";
   }
   echo "<hr>";
  }
  $result->free();
  if($mysqli->more_results()){//判斷是否還存在有結(jié)果集
   echo "----------查詢下一張表的數(shù)據(jù)---------------<br>";
  }
 }while($mysqli->next_result());//next_result() 返回 true 或false;
}
//4、關(guān)閉數(shù)據(jù)庫連接
$mysqli->close();
?>

Correcting teacher：天蓬老師Correction time：2019-03-22 13:34:49
Teacher's summary：你這是多結(jié)果集查詢吧, 當(dāng)然pdo好用了, mysqli了解即可