使用PHP implode函数使用一个INSERT语句将多行插入MySql(Inserting multiple rows into MySql with one INSERT statement using PHP implode function)

 我正在尝试使用implode函数将多行插入到MySql中，只有一个INSERT INTO语句。 它是从这里发现的。 
 
 我的示例代码如下。 
 
$sql[]=array();
$len=count($colour_id);
for($i=0;$i<$len;$i++)
{
     $sql[]='('.$colour_id[$i].', '.$_POST['prod_id'].')';
}

$l=count($sql);
foreach($sql as $temp)
{
     echo $temp;
}

echo 'insert into product_colour (colour_id, prod_id)values '.implode(',', $sql);
 
 
 上面的代码只是初始化$sql数组， foreach循环遍历数组并显示数组的内容，如下所示。 
 
Array(1, 1)(2, 1)(3, 1)
 
 但是在回显最后一个语句（insert语句）时，它显示以下错误。 
 
Notice: Array to string conversion in C:\wamp\www\wagafashion\ProductColour.php on line 70
insert into product_colour (colour_id, prod_id)values Array,(1, 1),(2, 1),(3, 1) 
 
 （第70行代表上面代码片段中的最后一行）。 应该进行哪些更改，以便可以将存储在数组中的值插入到MySql数据库中？ 

I'm trying to insert multiple rows into MySql with only one INSERT INTO statement using the implode function. It was found from here.
 
My sample code goes below.
 
$sql[]=array();
$len=count($colour_id);
for($i=0;$i<$len;$i++)
{
     $sql[]='('.$colour_id[$i].', '.$_POST['prod_id'].')';
}

$l=count($sql);
foreach($sql as $temp)
{
     echo $temp;
}

echo 'insert into product_colour (colour_id, prod_id)values '.implode(',', $sql);
 
 
The above code simply initializes the $sql array and the foreach loop iterates over the array and displays the content of the array as follows.
 
Array(1, 1)(2, 1)(3, 1)
 
but while echoing the last statement (insert statement), it shows the following error.
 
Notice: Array to string conversion in C:\wamp\www\wagafashion\ProductColour.php on line 70
insert into product_colour (colour_id, prod_id)values Array,(1, 1),(2, 1),(3, 1) 
 
(line no 70 means the last line in the above code snippet). What changes should be made so that I can insert the values stored in the array into MySql database?

原文：https://stackoverflow.com/questions/9796084