php数组如何插入,php – 如何将数组插入数据库

参见英文答案 >

How do I insert an array of values into different columns of a mysql table?                                    3个

$rate=[10,20,40,50,70];

如何在下面的查询中插入值？

$sql="INSERT INTO rental(day_1,day_3,day_7,day_15,day_30)

VALUES('{$rate[0]}','{$rate[1]}', '{$rate[2]}','{$rate[3]}','{$rate[4]}')";

$stmt =connection::$pdo->prepare($sql);

$stmt->execute();

我在下面尝试过,但它在记录的所有列中插入相同的值,并为每个新值创建新记录：

foreach($rate as $key->$value)

{

$sql="INSERT INTO rental(day_1,day_3,day_7,day_15,day_30)

VALUES('{$value}','{$value}', '{$value}','{$value}','{$value}')";

$stmt =connection::$pdo->prepare($sql);

$stmt->execute();

根据给出的答案编辑

public function rentalRate()

{

$rate = implode("','",$this->rate);

$sql = "INSERT INTO rental(day_1,day_3,day_7,day_15,day_30)VALUES('$rate')";

$stmt =connection::$pdo->prepare($sql);

$stmt->execute();

unset($rate);

}