i have a not difficult question, but I couldn't find an answer.
I have a multidimensional array for insert data with one query. The result is this:
INSERT INTO table (field1, field2, field3, field4) values ('1', '2', '3'),('1', '2', '3'),('1', '2', '3'),('1', '2', '3')
and I want to add one value in each tuple like this:
INSERT INTO table (field1, field2, field3, field4) values ('1', '2', '3','10'),('1', '2', '3','10'),('1', '2', '3','10'),('1', '2', '3','10')
This is the code (I also tried with array_push inside foreach):
$DataArr = array();
for($i=1;$i<5;$i++){
$fieldVal1 = 1;
$fieldVal2 = 2;
$fieldVal3 = 3;
$DataArr[] = "('$fieldVal1', '$fieldVal2', '$fieldVal3')";
}
$id=10;
$new=array();
foreach ($DataArr as $value) {
$value[4]="'$id'";
}
$sql = "INSERT INTO table (field1, field2, field3) values ";
$sql .= implode(',', $DataArr);
print_r($sql);
I tested this code but it doesn't work, can anyone help me?
question from:
https://stackoverflow.com/questions/65858941/add-one-element-into-multidimensional-array