multiple row insertion in mysql table through php

Question

I just installed xampp on my system and created connection and table in mysql using php and i even inserted one row in my table but when i tried to insert multiple rows then the flow directly gone to else part to my customize error message.

My small code is as follows:

<?php

include('connection_practice.php');
$insert_query="INSERT INTO student (NAME,ID,ADDRESS,SUBJECT,REMARKS)
               VALUES('AJAY',11,'SILK BOARD','IRO','AVERAGE'),
               VALUES('RITESH',12,'KARTHIK NAGAR','IRO','GOOD'),
               VALUES('SUNNY',13,'HEBBAL','HR MODULE','GOOD'),
               VALUES('HEMAVATHI',14,'HEBBAL','TME','GOOD'),
               VALUES('GURU',15,'HEBBAL','IRO','GOOD'),
               VALUES('SARITHA',16,'HEBBAL','IRO','GOOD'),
               VALUES('NIHAAR',17,'MULTIPLEX','COMPUTERS','AVERAGE')";

if(mysql_query($insert_query,$conn))
{
    echo "8 records added ";
} 
else
{
    echo "record not added ";
}

?>

Whatever happened to error reporting? Don't use mysql methods...EVER. http://nl1.php.net/mysql_query Look at the big red box...pretty hard to miss — Kevin Op den Kamp, Jun 02 '14 at 14:38

score 0 · Accepted Answer · answered Jun 02 '14 at 14:38

I think it should be:

$insert_query = "INSERT INTO student (NAME, ID, ADDRESS, SUBJECT, REMARKS)
VALUES ('AJAY', 11, 'SILK BOARD', 'IRO', 'AVERAGE'),
('RITESH', 12, 'KARTHIK NAGAR', 'IRO', 'GOOD'), 
('SUNNY', 13, 'HEBBAL', 'HR MODULE', 'GOOD'), 
('HEMAVATHI', 14, 'HEBBAL', 'TME', 'GOOD'),
('GURU', 15, 'HEBBAL', 'IRO', 'GOOD'), 
('SARITHA', 16, 'HEBBAL', 'IRO', 'GOOD'),
('NIHAAR', 17, 'MULTIPLEX', 'COMPUTERS', 'AVERAGE')";

score 0 · Answer 2 · answered Jun 02 '14 at 14:39

Have a look at the MySQL Documentation!

Long story short - your code should look as follows:

<?php

include('connection_practice.php');
$insert_query="INSERT INTO student (NAME,ID,ADDRESS,SUBJECT,REMARKS)
VALUES('AJAY',11,'SILK BOARD','IRO','AVERAGE'),
('RITESH',12,'KARTHIK NAGAR','IRO','GOOD'),
('SUNNY',13,'HEBBAL','HR MODULE','GOOD'),
('HEMAVATHI',14,'HEBBAL','TME','GOOD'),
('GURU',15,'HEBBAL','IRO','GOOD'),
('SARITHA',16,'HEBBAL','IRO','GOOD'),
('NIHAAR',17,'MULTIPLEX','COMPUTERS','AVERAGE')";

if(mysql_query($insert_query,$conn))
{
echo "8 records added ";
}

else
{
echo "record not added ";
}

?>

score 0 · Answer 3 · answered Jun 02 '14 at 14:40

The right sintax is with only one "VALUE" string. something like:

INSERT INTO student (NAME,ID,ADDRESS,SUBJECT,REMARKS) VALUES ('AJAY',11,'SILK BOARD','IRO','AVERAGE'), ('RITESH',12,'KARTHIK NAGAR','IRO','GOOD'), ('SUNNY',13,'HEBBAL','HR MODULE','GOOD'), ('HEMAVATHI',14,'HEBBAL','TME','GOOD'),

multiple row insertion in mysql table through php

3 Answers3

Linked