执行多条SQL语句由刀豆文库小编整理，希望给你工作、学习、生活带来方便，猜你可能喜欢“sql语句执行顺序”。
执行多条SQL语句
使用mysqli一次执行多条SQL语句
$mysqli=new MySQLi(“localhost”,“root”,“”,“xiaoqiangdb”);
/*==========================没有结果集: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
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_aoc()){
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();
?>
