mysqli 返回一条结果_【PHP】Mysqli扩展处理多条语句（查询返回结果集的语句）...

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

$mysqli=@new mysqli("localhost","root","liuyang","firedb");

if(mysqli_connect_error()){

echo "ERROR ".mysqli_connect_errno()."|".mysqli_connect_error();

exit;

}

/*

$sqls="insert into shop values('136','lamp','100','200','very good');";

$sqls.="update shop set name=lamp where id<40";

*/

$sqls="select current_user();";

$sqls.="desc shop;";

$sqls.="select * from shop";

echo $sqls."
";

$result=$mysqli->multi_query($sqls);

var_dump($result);

if($result){

/*

echo "Exectue success!!
";

echo "Affect rows:".$mysqli->affected_rows;

*/

do{

$result=$mysqli->store_result();

echo '

echo '

';

while($field=$result->fetch_field()){

echo '

'.$field->name.'';

}

echo '

';

while($rows=$result->fetch_assoc()){

echo '

';

foreach($rows as $row){

echo '

'.$row.'';

}

echo '

';

}

echo '

';

if($mysqli->more_results()){

echo '

-----

----

';

}

}while($mysqli->next_result());

}else{

echo "ERROR ".$mysqli->errno."|".$mysqli->error;

}

$mysqli->close();