Mysql批量执行dml语句(PHP)

 

View Code

 1 <?php
 2 
 3     $mysqli=new MySQLi("localhost","root","root","database");
 4     if($mysqli->connect_error){
 5         die($mysqli->connect_error);
 6     }
 7 
 8     //定义多条sql语句
 9     $sqls="sql语句1";
10     $sqls.="sql语句2";
11     $sqls.="sql语句3";
12     
13     //............//
14 
15     //批量执行sql语句
16     $bool=$mysqli->multi_query($sqls);
17     if(!$bool){
18         echo "执行失败".$mysqli->error;
19     }
20     else{
21         echo "ok";
22     }
23 
24     $mysqli->close();
25 
26 ?>

 

转载于:https://www.cnblogs.com/shuyajun/archive/2012/06/07/2540422.html