How to insert multiple rows by mysqli_multi_query(

2019-04-16 13:12发布

问题:

I am trying to do multiple insertions using mysqli_multi_query() and following is my code. The issue is its not executing the result . Kindly let me know what i did wrong?

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

回答1:

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");


回答2:

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

You forgot ; between your queries.

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



标签: php mysqli