PDO: INSERT array to table?

Question

PHP

For mysql to insert many, many rows, you need to do something like
INSERT INTO ids VALUES
(0, ' url1.ru '),
(0, ' url2.ru '),
(0, ' url3.ru ');
so here's the problem: there is an array and it must be inserted into the plate. It is one-dimensional and, suppose that the column in the table is also one. Are there any PDO functions to implement this. Google did not give an answer .. (

Answer 1

I do like this:

$stmt = $db->prepare('INSERT INTO ids VALUES (0, :url)');

try {
   $db->beginTransaction();
   foreach ($ursl as $url) {
      $stmt->bindValue(':url', $url);
      $stmt->execute();
   }
   $db->commit();
} catch (PDOException $e) {
   $db->rollBack();
}