How to insert multiple rows by mysqli_multi_query()?

Question

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

Community · Accepted Answer · 2023-11-17 20:38:18Z

3

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

edited Nov 17, 2023 at 20:38

CommunityBot

11 silver badge

answered Nov 22, 2013 at 11:19

Hanky Panky

46.9k9 gold badges76 silver badges95 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Deniz Zoeteman Over a year ago

Please select this answer as the approved answer if this is the answer you needed. It's the little checkmark under the vote number.

user2304394 Over a year ago

@DenizZoeteman I would have selected it earlier but due to 8 mins constraint i could not

Viacheslav Kondratiuk · Accepted Answer · 2013-11-22 11:20:26Z

1

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

answered Nov 22, 2013 at 11:20

Viacheslav Kondratiuk

8,9609 gold badges53 silver badges81 bronze badges

Collectives™ on Stack Overflow

How to insert multiple rows by mysqli_multi_query()?

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related