php增加多行数据的方法：1、创建一个php示例文件；2、连接数据库；3、通过mysqli_multi_query()函数执行多条sql语句并使用insert语句向数据表中增加多行数据即可。
本文操作环境：windows7系统、php7.1版、dell g3电脑
php怎么增加多行数据？
mysqli_multi_query() 函数可用来执行多条sql语句。
以下实例向 myguests 表添加了三条新的记录:
实例 (mysqli - 面向对象)
<?php$servername = "localhost";$username = "username";$password = "password";$dbname = "mydb"; // 创建链接$conn = new mysqli($servername, $username, $password, $dbname);// 检查链接if ($conn->connect_error) { die("连接失败: " . $conn->connect_error);} $sql = "insert into myguests (firstname, lastname, email)values ('john', 'doe', 'john@example.com');";$sql .= "insert into myguests (firstname, lastname, email)values ('mary', 'moe', 'mary@example.com');";$sql .= "insert into myguests (firstname, lastname, email)values ('julie', 'dooley', 'julie@example.com')"; if ($conn->multi_query($sql) === true) { echo "新记录插入成功";} else { echo "error: " . $sql . "<br>" . $conn->error;} $conn->close();?>
note 请注意，每个sql语句必须用分号隔开。
实例 (mysqli - 面向过程)
<?php$servername = "localhost";$username = "username";$password = "password";$dbname = "mydb"; // 创建链接$conn = mysqli_connect($servername, $username, $password, $dbname);// 检查链接if (!$conn) { die("连接失败: " . mysqli_connect_error());} $sql = "insert into myguests (firstname, lastname, email)values ('john', 'doe', 'john@example.com');";$sql .= "insert into myguests (firstname, lastname, email)values ('mary', 'moe', 'mary@example.com');";$sql .= "insert into myguests (firstname, lastname, email)values ('julie', 'dooley', 'julie@example.com')"; if (mysqli_multi_query($conn, $sql)) { echo "新记录插入成功";} else { echo "error: " . $sql . "<br>" . mysqli_error($conn);} mysqli_close($conn);?>
推荐学习：《php视频教程》
以上就是php怎么增加多行数据的详细内容。