How do you pass multiple sql statements using php

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', 'example1@email.com', CURRENT_TIMESTAMP);
    INSERT INTO `people` (`id`, `firstname`, `lastname`, `email`, `reg_date`) VALUES (NULL, 'firstnameB', 'surnameB', 'example@email.com', 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', 'tom@walker.com', CURRENT_TIMESTAMP);
"

http://php.net/manual/en/mysqli.multi-query.php – Funk Forty Niner Feb 08 '16 at 20:19 — Funk Forty Niner, Feb 08 '16 at 20:19
http://www.w3schools.com/php/php_mysql_insert_multiple.asp – jpganz18 Feb 08 '16 at 20:21 — jpganz18, Feb 08 '16 at 20:21

aynber · Accepted Answer · 2016-02-10T15:18:27.360

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', 'tom@walker.com', CURRENT_TIMESTAMP), 
   (NULL, 'bob', 'jones', 'bob@jones', CURRENT_TIMESTAMP)";

edited Feb 10 '16 at 15:18

answered Feb 08 '16 at 20:20

aynber

22,380
8
50
63

remember the semicolon after the closing quote marks – Some One Feb 09 '16 at 22:31
Good point. Moved it, since it doesn't need to be inside. – aynber Feb 10 '16 at 15:18

score 0 · Answer 2 · answered Feb 08 '16 at 20:20

0

Use mysqli_multi_query check out:

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

answered Feb 08 '16 at 20:20

WheatBeak

1,036
6
12

How do you pass multiple sql statements using php

2 Answers2