Binding parameters or values to placeholders within the for loop

bettermysql-bindParam-forLoop.php

<?php
  // Assuming that database connection is already open
  // You have an array of userdata
  $userData = array([1] => 'johndoe', [2] => '[email protected]', [3] => 'USA');
  
  // Prepare statement
  $stmt = $db->prepare("INSERT INTO users (user, email, country) VALUES (?, ?, ?)");
  
  // For loop
  // Bind param binds the REFERENCE, remember to modify array (&$value)
  foreach($userData as $key=>&$value) {
    $stmt->bindParam($key, $value); 
  }
  
  $stmt->execute();
?>

bettermysql-bindValue-forLoop.php

<?php
  // Assuming that database connection is already open
  // You have an array of userdata
  $userData = array([1] => 'johndoe', [2] => '[email protected]', [3] => 'USA');
  
  // Prepare statement
  $stmt = $db->prepare("INSERT INTO users (user, email, country) VALUES (?, ?, ?)");
  
  // For loop
  // Bind param binds the VALUE, array modification not required ($value)
  foreach($userData as $key=>$value) {
    $stmt->bindValue($key, $value); 
  }
  
  $stmt->execute();
?>