How to insert an array into a single MySQL Prepared statement w/ PHP and PDO

by

You could build the query programatically…:

$sql="INSERT INTO table (memberID, programID) VALUES ";
$insertQuery = array();
$insertData = array();
foreach ($data as $row) {
    $insertQuery[] = '(?, ?)';
    $insertData[] = $memberid;
    $insertData[] = $row;
}

if (!empty($insertQuery)) {
    $sql .= implode(', ', $insertQuery);
    $stmt = $db->prepare($sql);
    $stmt->execute($insertData);
}

More Related Contents:

  1. PHP PDO and Mysql [closed]
  2. PDO Fetch statement only retrieves first column
  3. PHP – Using PDO with IN clause array
  4. How to properly set up a PDO connection
  5. PHP PDO prepared statements
  6. PDO MySQL: Use PDO::ATTR_EMULATE_PREPARES or not?
  7. How do I set ORDER BY params using prepared PDO statement?
  8. PDO binding values for MySQL IN statement [duplicate]
  9. Why I am getting Cannot pass parameter 2 by reference error when I am using bindParam with a constant value?
  10. PDO mysql: How to know if insert was successful
  11. mysql PDO how to bind LIKE
  12. implement LIKE query in PDO
  13. PHP PDO prepared statement — MySQL LIKE query
  14. Fetching single row, single column with PDO
  15. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  16. PDO Connection Test
  17. How to install pdo driver in php docker image?
  18. How do I loop through a MySQL query via PDO in PHP?
  19. MySQL retrieve variable from Stored Procedure in PHP PDO
  20. Understanding pdo mysql transactions
  21. PDO error: SQLSTATE[HY000]: General error: 2031
  22. Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL)
  23. Using LIKE in bindParam for a MySQL PDO Query [duplicate]
  24. Use of PDO in classes [duplicate]
  25. How to handle PDO exceptions [duplicate]
  26. Check if row exists in the database before inserting
  27. php artisan migrate throwing [PDO Exception] Could not find driver – Using Laravel
  28. PDO and MySQL Fulltext searches
  29. PHP/PDO/MySQL: inserting into MEDIUMBLOB stores bad data
  30. Using PDO Prepared Statement and Incrementing a column value

Leave a Comment