Insert PHP array into MySQL table

from the Artful MySQL Tips List

It requires a PHP array and a MySQL table, each with the same number of columns, each array column compatible with the respective table column with respect to whether its values need to be quoted in SQL statements.

For example if table tbl has two columns, the first INT and the second CHAR, and you have a PHP array a of values for it, you'd write this in PHP...

$a as $row $qry .= sprintf"(%s,'%s'),"$row[0], $row[1] ); // each row
$qry substr$qry0, -);                                            // remove last comma
$res mysql_query$qry );

Last updated 13 Sep 2010

Return to the Artful MySQL Tips page