CODEWITHSUNDEEP
phpmysqli
user2304394
user2304394

Reputation: 323

How to insert multiple rows by mysqli_multi_query()?

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

Upvotes: 1

Views: 5146

Answers (2)

Viacheslav Kondratiuk
Viacheslav Kondratiuk

Reputation: 8879

$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.

Upvotes: 1

Hanky Panky
Hanky Panky

Reputation: 46900

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

Upvotes: 3

Related Questions