Insert php nested array into mysql table

Question

what is the optimal way for me to insert and array of 1000 lines and 10 columns each into a mysql table below is how i display it so it would be a similar construct but i need some directions

foreach ($stack as $val) {
    print "<tr>\n";
    foreach ($val as $no) {
       print " <td>$no</td>\n";}
 print "</tr>\n"; 
}

Manse · Accepted Answer · 2011-10-11 11:56:24Z

1

You can insert multiple rows with a single insert as follows :

INSERT INTO tbl_name (a,b,c) VALUES(1,2,3),(4,5,6),(7,8,9);

look at implode() to create the values string from your array

answered Oct 11, 2011 at 11:56

Manse

38.1k11 gold badges88 silver badges112 bronze badges

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

Comments

Arasu · Accepted Answer · 2011-10-11 11:57:18Z

1

Better way to insert thousands of data into DB is to use implode function implode

answered Oct 11, 2011 at 11:57

Arasu

2,1486 gold badges40 silver badges67 bronze badges

Comments

Obi Ik · Accepted Answer · 2011-10-12 10:29:16Z

0

i'm guessing u got something like this

$stack = array("man1" => array("name"=>"ik", "class"=>"highskl", "age"=> "12"),"man1" => array("name"=>"ijk", "class"=>"higkl", "age"=> "13"));

and you want to insert them into a table, try and use the table fields as index for the inner arrays then adjust the code to look like this

    foreach ($stack as $entry => $value) {
$query = "INSERT INTO table set ";
foreach ($value as $key => $val) {
   $query .= $key ."= ".$val.",";}
 //use a string function to remove the last comma
 $result = mysql_query($query) or die("Error in Query ".$entry." ",mysql_error());
//this helps to track error..
}

edited Oct 12, 2011 at 10:29

answered Oct 12, 2011 at 9:05

Obi Ik

1592 silver badges9 bronze badges

1 Comment

Obi Ik Over a year ago

sorry this came late...power failure!

Collectives™ on Stack Overflow

Insert php nested array into mysql table

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related