Bind a 2D array to a PDO SQL statement

Question

How do I bind an array WITHOUT a key (non associative array) to a PDO SQL statement?

Say I want to insert all 3 entries from $fruits to the database:

$fruits = array(
 array('apple','red','sweet'),
 array('lemon','yellow','bitter'),
 array('bannana','yellow','sweet')
);

$stmt = $pdo->prepare("INSERT INTO `fruits` (`name`, `color`, `taste`) VALUES ( ???? )");

$stmt->bindValue(??);

$stmt->execute();

I know it can be done with associative array (Binding multiple values in pdo) but in this scenario The array have no key.

By the way your array synatx is wrong, it is 2d array, right? — monirz, Jan 18 '16 at 18:49
It's the same principle, just change the placeholder. http://php.net/manual/en/pdostatement.execute.php#103287 — vsmoraes, Jan 18 '16 at 18:57
@vsmoraes . ok so I'll have to use `foreach`. I though there were another way of doing it. Post as an answer, please. — Azevedo, Jan 18 '16 at 18:59

score 0 · Accepted Answer · answered Jan 18 '16 at 19:00

Just put it inside a loop...

$fruits = array(
  array('apple','red','sweet'),
  array('lemon','yellow','bitter'),
  array('bannana','yellow','sweet')
);

$stmt = $pdo->prepare("INSERT INTO `fruits` (`name`, `color`, `taste`) VALUES (?, ?, ?, ?)");

foreach ($fruits as $row) {
  $stmt->bindValue($row);
}

$stmt->execute();

Bind a 2D array to a PDO SQL statement

1 Answers1