phpMyqli向数据表插入多条数据

phpMyqli向数据表插入多条数据

mysqli批量执行sql语句

在用PHP操作数据库时，有时候我们需要一次性执行多条sql语句，比如批量增加用户，这时如果单条单条的向mysql数据库发送sql指令，效率不高，这时可以考虑使用批量执行sql语句的方式。

mysqli批量执行sql语句的语法：

=========今天学习mysqli面向对象的语句=========

向数据表stu_info一次性插入多条数据

<?php

//使用面向对象进行数据库的连接，在创建对象的时候就自动的连接数据

$mySQLi = new MySQLi('localhost','root','root','yhd_data');

//判断数据库是否连接

if($mySQLi -> connect_errno){

die('连接错误' . $mySQLi -> connect_error);

}

//设置字符集

// $mySQLi -> set_charset('utf8');

$sql ="insert into stu_info values(null,'孙婆婆',146,138);";

$sql .="insert into stu_info values(null,'李莫愁',84,72);";

$sql .="insert into stu_info values(null,'林玉',110,97);";

$sql .="insert into stu_info values(null,'公孙止',77,84);";

$sql .="insert into stu_info values(null,'裘千尺',105,127);";

$sql .="insert into stu_info values(null,'公孙绿萼',149,63);";

$sql .="insert into stu_info values(null,'武三娘',65,70);";

$sql .="insert into stu_info values(null,'武敦儒',147,133);";

$sql .="insert into stu_info values(null,'武修文',118,72);";

$sql .="insert into stu_info values(null,'郭芙',129,78);";

$sql .="insert into stu_info values(null,'郭襄',66,85);";

$sql .="insert into stu_info values(null,'郭破虏',139,123);";

$sql .="insert into stu_info values(null,'耶律齐',60,141);";

$sql .="insert into stu_info values(null,'耶律燕',138,112);";

$sql .="insert into stu_info values(null,'完颜萍',62,102);";

$sql .="insert into stu_info values(null,'何师我',100,141);";

$sql .="insert into stu_info values(null,'陆展元',108,100);";

$sql .="insert into stu_info values(null,'何沅君',129,138);";

$sql .="insert into stu_info values(null,'陆无双',128,139);";

$sql .="insert into stu_info values(null,'陆立鼎',75,123);";

$sql .="insert into stu_info values(null,'陆二娘',143,76);";

$sql .="insert into stu_info values(null,'程英',61,121);";

$sql .="insert into stu_info values(null,'忽必烈',96,76);";

$sql .="insert into stu_info values(null,'金轮法王',119,107);";

$sql .="insert into stu_info values(null,'霍都',115,126);";

$sql .="insert into stu_info values(null,'达尔巴',143,103);";

$sql .="insert into stu_info values(null,'藏边五丑',87,148)";

//进行批量的sql语句执行。

res = mySQLi -> multi_query(

if($res){

echo '添加成功';

}else{

echo '添加失败' . $mySQLi -> error;

}

$mySQLi -> close();

?>

。

.

=======今天学习到此========