Insert Array Values into MySQL DB Using PHP

Question

I have problem on Inserting array values into db table...pls help me to solve this problem...thanks in advance...

$array1=([0]=>val1,[1]=>val2,[2]=>val3);
$array2=([0]=>val1,[1]=>val2,[2]=>val3);
$array3=([0]=>val1,[1]=>val2,[2]=>val3);

INSERT INTO table1 (id,date,col1,col2,col3,col4) VALUES (1,now(),'$array1','$array2','$array3',50);

Do you want the field to store a whole array or just one row per element? — Limiter
– Limiter, Commented May 21, 2014 at 10:25
if you want to store array you can implode elements in string, and when you need to read them later use explode. — Bojan Kovacevic
– Bojan Kovacevic, Commented May 21, 2014 at 10:27
you cannot insert an array directly into a table. You need to use a foreach to iterate through all the elements of the array — Professor
– Professor, Commented May 21, 2014 at 10:37

SagarPPanchal · Accepted Answer · 2014-05-21 10:33:50Z

1

You may try like this, (this is just an example)

foreach($array as $row){
  $query="INSERT INTO 
  table1 (id,date,col1,col2,col3,col4)
  VALUE
  (1,now(),".$row['yourfieldname'].",".$row['yourfieldname'].",".$row['yourfieldname'].",50)";
}

answered May 21, 2014 at 10:33

SagarPPanchal

10.2k6 gold badges36 silver badges66 bronze badges

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

Comments

1915 · Accepted Answer · 2014-05-21 10:26:46Z

0

INSERT INTO table1 (id,date,col1,col2,col3,col4) VALUES (1,now(),'$array1[0]','$array1[1]','$array1[2]',50);

Where the brackets ([]) indicate which array position you want to insert.

answered May 21, 2014 at 10:26

1915

806 bronze badges

1 Comment

Siva Over a year ago

i used this format using for loop it's not working...it adds 'A,r' in db table

Rakesh Sharma · Accepted Answer · 2014-05-21 10:41:24Z

0

if you want to insert in one row use implode() like

$arr1 = implode(',', $array1)
$arr2 = implode(',', $array2)
$arr3 = implode(',', $array3)

$sql = "INSERT INTO table1 (id,date,col1,col2,col3,col4) VALUES (1,now(),'$arr1','$arr2','$arr3',50)";

else you need to use for() or foreach()

for($i =0; $i <=count($array1); $i++){
  $query="INSERT INTO 
  table1 (id,date,col1,col2,col3,col4)
  VALUE
  (1,now(),".$row[$i].",".$row[$i].",".$row[$i].",50)";
}

For forech you can use @sagar's answer

edited May 21, 2014 at 10:41

answered May 21, 2014 at 10:28

Rakesh Sharma

13.7k5 gold badges41 silver badges44 bronze badges

Collectives™ on Stack Overflow

Insert Array Values into MySQL DB Using PHP

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related