gistfile1.php

try {
  $pdo->beginTransaction();
  foreach($data as $index => $line):
    $sth = $pdo->prepare("INSERT INTO sample (id, date) VALUES (:id, :date)");
    $sth->execute(array(
        ':id'   => $line['id'],
        ':date' => $line['date']
      ));
    $sth->closeCursor();
  endforeach;
  $pdo->commit();
} catch (Exception $e) {
  $pdo->rollBack();
  vae_dump($e->getMessage());
}