PHP PDO insert from a loop

pdo_insert_loop.php

<?php
$db = new PDO("mysql:host=127.0.0.1;dbname=test;charset=utf8mb4", 'root', '');

$db->beginTransaction();
$insert = $db->prepare("INSERT IGNORE INTO `objects` (`id`, `color`) VALUES (?, ?);");

$test_array = ['Red', 'Orange', 'Pink', 'Lime', 'Yellow', 'Gold', 'Green', 'Blue', 'Purple', 'Maroon', 'Silver', 'Aqua'];

$id = 0;
foreach ($test_array as $c) {
    $id++;
    $insert->execute([$id, $c]);
}

$db->commit();