php一次性执行多条sql语句,使用mysqli一次执行多条SQL语句 | 学步园

/*==========================没有结果集:insert update delete==========================*/

$sqls="insert into shops(name,price,num,desn) values('book1','12.16','5','good');";

$sqls.="updated shops set name='testname' where id>50;";

$sqls.="delete from shops where id < 20";

if($mysqli->multi_query($sqls))

{

echo "多条语句执行成功!
";

echo "最后插入的ID:".$mysqli->insert_id."
";

echo "影响的行数:".$mysqli->affected_rows; //不准确!

}

else

{

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

}

/*==========================有结果集:select==========================*/

$sqls="select current_user();";

$sqls.="desc shops;";

$sqls.="select * fron shops";

if($mysqli->multi_query($sqls))

{

echo "多条语句执行成功!
";

do

{

$result=$mysqli->store_result(); //获取结果集

echo '

echo '

';

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

echo '

'.$field->name.'';

} echo '

';

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

echo '

';

foreach($row as $col)

{

echo '

'.$col.' ';

}

echo '

';

}

echo '

';

if($mysqli->more_results()){ //判断还有没有结果集

echo "
";

}

}

while($mysqli->next_result()); //取得下一个结果集

}

else{ echo "ERROR".$mysqli->errno."---".$mysqli->error;

}

$mysqli->close();

?>