How to add data from different array variables to a sql table in php

Question

I have been trying to insert data into a table(mySql) from 3 arrays using php. Each time i run the script i get a long list on unsuccesful entries. I am new to php and sql, what am i doing wrong here ? how do i get the query string to recognize these variables ? i have tried searching around but could not make sense of much.

$id=array();
$comp=array();
$mobname=array();

for($x=0;$x<$arrlength;$x++)
{

  if(mysqli_query($con,"INSERT INTO Umobile VALUES ($id[$x],$comp[$x],$mobname[$x])"))
     echo "added",$id[$x]," ",$comp[$x]," ",$mobname[$x];
  else
     echo " unsuccessful ";

    //echo $id[$x]," ",$comp[$x]," ",$mobname[$x];
   echo "<br/>";  
 }

By looking above code i assume that you are trying to put an empty array of id,com,mobname variables thats why its giving error. Do you have values in id,comp,mobname arrays ?? or they are just empty like above?? — Seeker
– Seeker, Commented May 6, 2013 at 13:17
or another thing is try changing your query function call to this one: mysqli_query($con,"INSERT INTO Umobile VALUES ({$id[$x]},{$comp[$x]},{$mobname[$x]})") — Seeker
– Seeker, Commented May 6, 2013 at 13:22
and if any field in above query you have is string type in DB then try putting single quote ' arround that variable as well. — Seeker
– Seeker, Commented May 6, 2013 at 13:23
Yes, They all have values, infact they have quite a few values in them. I tried using the curly braces but that didn't help and one of them is type integer and the other two are varchars. so single quote won't work — Aman Mehrotra
– Aman Mehrotra, Commented May 6, 2013 at 14:06

antoox · Accepted Answer · 2013-05-06 13:34:18Z

2

By using this kind of arrays, you assume that your three arrays have the same lengths: $arrlength.

If this statement is true, you could have special characters into your arrays and the query may fail.

You must see at mysqli prepare to escape your values before the insert.

edited May 6, 2013 at 13:34

answered May 6, 2013 at 13:28

antoox

1,31911 silver badges9 bronze badges

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

2 Comments

Aman Mehrotra Over a year ago

yes, they are all the same length as each array takes values from the same number of rows. I'm not aware of the mysqli prepare method.

antoox Over a year ago

You can also use mysqli_real_escape_string like that: $idInsert = mysqli_real_escape_string($id[x]); $compInsert = mysqli_real_escape_string($comp[x]); $mobnameInsert = mysqli_real_escape_string($mobname[x]); mysqli_query($con,"INSERT INTO Umobile VALUES ($idInsert,$compInsert,$mobnameInsert)"

Collectives™ on Stack Overflow

How to add data from different array variables to a sql table in php

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related