How do you pass multiple sql statements using php [duplicate]

Question

This is what i want to do but with lots of records. When i try this i get this kind of error:the error message i get

this is my currant php and when i submit it no record is added.

$sql = "INSERT INTO `people` (`id`, `firstname`, `lastname`, `email`, `reg_date`) VALUES (NULL, 'firstnameA', 'surnameA', '[email protected]', CURRENT_TIMESTAMP);
    INSERT INTO `people` (`id`, `firstname`, `lastname`, `email`, `reg_date`) VALUES (NULL, 'firstnameB', 'surnameB', '[email protected]', CURRENT_TIMESTAMP);
    " ;

However this code works but i am only adding one record

$sql = "INSERT INTO `people` (`id`, `firstname`, `lastname`, `email`, `reg_date`) VALUES (NULL, 'tom', 'walker', '[email protected]', CURRENT_TIMESTAMP);
"

php.net/manual/en/mysqli.multi-query.php

Funk Forty Niner
– Funk Forty Niner

2016-02-08 20:19:37 +00:00
Commented Feb 8, 2016 at 20:19 — Funk Forty Niner
– Funk Forty Niner, Commented Feb 8, 2016 at 20:19
w3schools.com/php/php_mysql_insert_multiple.asp

jpganz18
– jpganz18

2016-02-08 20:21:31 +00:00
Commented Feb 8, 2016 at 20:21 — jpganz18
– jpganz18, Commented Feb 8, 2016 at 20:21

aynber · Accepted Answer · 2016-02-10 15:18:27Z

1

You just need to duplicate the values portion, like this:

$sql = "INSERT INTO `people` (`id`, `firstname`, `lastname`, `email`, `reg_date`) 
   VALUES (NULL, 'tom', 'walker', '[email protected]', CURRENT_TIMESTAMP), 
   (NULL, 'bob', 'jones', 'bob@jones', CURRENT_TIMESTAMP)";

edited Feb 10, 2016 at 15:18

answered Feb 8, 2016 at 20:20

aynber

23.2k9 gold badges57 silver badges69 bronze badges

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

2 Comments

Some One Over a year ago

remember the semicolon after the closing quote marks

aynber Over a year ago

Good point. Moved it, since it doesn't need to be inside.

WheatBeak · Accepted Answer · 2016-02-08 20:20:14Z

0

Use mysqli_multi_query check out:

http://php.net/manual/en/mysqli.multi-query.php

answered Feb 8, 2016 at 20:20

WheatBeak

1,0216 silver badges12 bronze badges

Collectives™ on Stack Overflow

How do you pass multiple sql statements using php [duplicate]

2 Answers 2

2 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Linked

Related