PHP SQL : Problems with insert multiple rows

Question

Based on Inserting multiple rows in a single SQL query? page, i have followed the answer on this page to adding multiple rows in sql, but not success.

UPDATE :

I forget to inform the problem : Only first row added success to db. ==> (idkeg, nama, desk, tgl, 71)

How to fix this?

mysqli_query($koneksi, "INSERT INTO keg(idkeg, nama, desk, tgl, kdwil)
                                                        VALUES
                                                        ('$idkeg','$nama', '$desk', '$tgl',71),
                                                        ('$idkeg','$nama', '$desk', '$tgl',72);
                                                        ") or die(mysqli_error());

i am using PMA 3.2.4 & Sql Client 5.1.4.1

How to solve this? Thanks

Your code is vulnerable to SQL injections. Please learn to use prepared statements. — tereško
– tereško, Commented May 14, 2017 at 9:16
So, any error? Did you check the connection $koneksi is successful or not? And mysqli is for mysql, supposedly won't work with mssql. — frz3993
– frz3993, Commented May 14, 2017 at 9:20
@frz3993 sory for my missed, i forget to inform the problem : Only first row added success to db. ==> (idkeg, nama, desk, tgl, 71) How to fix this? — Herlambang Permadi
– Herlambang Permadi, Commented May 14, 2017 at 9:28

Nusrat Kader · Accepted Answer · 2017-05-14 09:20:42Z

1

Use space between 'keg' and '(' as you using keg( . Rest seems OK accept if you forget to use " for ending. As I'm not seeing it here.

answered May 14, 2017 at 9:20

Nusrat Kader

365 bronze badges

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

2 Comments

Herlambang Permadi Over a year ago

sory for my missed, i forget to inform the problem : Only first row added success to db. ==> (idkeg, nama, desk, tgl, 71) How to fix this?

Nusrat Kader Over a year ago

Are you using same key value in your idkeg value or any of your unique column. If so then it will only take your first entry.

Maz341 · Accepted Answer · 2017-05-14 09:27:55Z

0

I Hope this helps!

$query = "INSERT INTO keg (idkeg, nama, desk, tgl, kdwil) VALUES('$idkeg','$nama', '$desk', '$tgl',71), ('$idkeg','$nama', '$desk', '$tgl',72)";

$result = mysqli_query($koneksi, $query);
if($result){
   echo "Your data has been inserted";
}
else{
 echo "Data insert Error";
}

answered May 14, 2017 at 9:27

Maz341

2,52219 silver badges22 bronze badges

Comments

Nick · Accepted Answer · 2017-05-14 09:55:15Z

0

Try with this:

if($koneksi->query("INSERT INTO keg (idkeg, nama, desk, tgl, kdwil) 
               VALUES 
                      ('$idkeg','$nama', '$desk', '$tgl',71), 
                      ('$idkeg','$nama', '$desk', '$tgl',72)"
              )                                                             
   ){                                                        
   echo "Multi-INSERT failed: (".$koneksi->errno.")".$koneksi->error;)
}

edited May 14, 2017 at 9:55

answered May 14, 2017 at 9:44

Nick

1029 bronze badges

Collectives™ on Stack Overflow

PHP SQL : Problems with insert multiple rows

3 Answers 3

2 Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Linked

Related