Executing multiple prepared statements

bettermysql-advanced-multipleStatements.php

<?php
  // Assuming that database connection is already open
  // Receive user input that is separated by a new line for each row
  $favouriteFoods = array('Apple', 'Poutine', 'Cheesestrings', 'Pickle chips', 'Peanut butter and raisins');
  $user = 'johndoe';
  
  // Prepare statement
  $stmt = $db->prepare("INSERT INTO users (user, foodItem) VALUES(:username, :favouriteFood)");
  
  $db->beginTransaction();
  
  // Insert a new row for each food item
  foreach($favouriteFoods as $food) {
    $db->execute(array(':username'=>$user, ':favouriteFood'=>$food));
  }
  
  $db->commit();
?>