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](https://www.youtube.com/watch?v=nLinqtCfhKY). — tereško, May 14 '17 at 09: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, May 14 '17 at 09: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, May 14 '17 at 09:28
Any field with unique, primary index? Because I see you're using the same variable to insert only differ by the `kdwil`. And I'm not sure, perhaps remove remove the semicolon? — frz3993, May 14 '17 at 09:38

score 1 · Accepted Answer · answered May 14 '17 at 09:20

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 '17 at 09:20

Nusrat Kader

36
5

1

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 May 14 '17 at 09:28
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. – Nusrat Kader May 14 '17 at 09:31

score 0 · Answer 2 · answered May 14 '17 at 09:27

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

Nick · Answer 3 · 2017-05-14T09:55:15.460

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

PHP SQL : Problems with insert multiple rows

3 Answers3