且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何通过mysqli_multi_query()插入多行?

更新时间:2023-12-04 12:34:52

mysqli_multi_query

mysqli_multi_query

执行一个或多个由分号连接的查询.

Executes one or multiple queries which are concatenated by a semicolon.

您之间必须有一个;.喜欢

You need to have a ; between them. Like

$query = "INSERT INTO crap_table (name, number, class)VALUES ('Peter', 35,'BS');";
                                                                               ^
$query .= "INSERT INTO crap_table (name, number, class)VALUES ('Sahil', 35,'MS')";

提供您已经连接到数据库了吗?喜欢

Provided that you are connected to the database already? Like

$con= mysqli_connect("localhost", "my_user", "my_password", "world");