Binding params for PDO statement inside a loop

The problem is that bindParam requires a reference. It binds the variable to the statement, not the value. Since the variable in a foreach loop is unset at the end of each iteration, you can’t use the code in the question.

You can do the following, using a reference in the foreach:

foreach ($reindex as $key => &$value) {  //pass $value as a reference to the array item
    $stmt->bindParam($key, $value);  // bind the variable to the statement
}

Or you could do this, using bindValue:

foreach ($reindex as $key => $value) {
    $stmt->bindValue($key, $value);  // bind the value to the statement
}

Related Contents:

  1. Can I bind an array to an IN() condition in a PDO query?
  2. PHP – Using PDO with IN clause array
  3. PDO Prepared Inserts multiple rows in single query
  4. PDO prepared statement – what are colons in parameter names used for?
  5. pdo prepared statements with wildcards
  6. Can I use a PDO prepared statement to bind an identifier (a table or field name) or a syntax keyword?
  7. How do I use pdo’s prepared statement for order by and limit clauses?
  8. Insert multiple rows with PDO prepared statements
  9. Replacing mysql_* functions with PDO and prepared statements
  10. PHP PDO::bindParam() data types.. how does it work?
  11. PDOstatement (MySQL): inserting value 0 into a bit(1) field results in 1 written in table
  12. Get last insert id after a prepared insert with PDO
  13. Use of PDO in classes [duplicate]
  14. Error while using PDO prepared statements and LIMIT in query [duplicate]
  15. Retrieve (or simulate) full query from PDO prepared statement
  16. PDO were rows affected during execute statement
  17. Why does this PDO statement silently fail?
  18. Can PHP PDO Statements accept the table or column name as parameter?
  19. How to check if a row exists in MySQL? (i.e. check if username or email exists in MySQL)
  20. Are PDO prepared statements sufficient to prevent SQL injection?
  21. How do I create a PDO parameterized query with a LIKE statement?
  22. How to view query error in PDO PHP
  23. How do I set ORDER BY params using prepared PDO statement?
  24. How to prevent duplicate usernames when people register?
  25. mysqli_stmt::bind_result(): Number of bind variables doesn’t match number of fields in prepared statement
  26. Performance of foreach, array_map with lambda and array_map with static function
  27. Where to put password_verify in login script?
  28. PDO Parameterized Query – Reuse named placeholders?
  29. How to find the foreach index?
  30. Find the last element of an array while using a foreach loop in PHP
  31. PDO with “WHERE… IN” queries [duplicate]
  32. PDO closing connection
  33. PDO bindParam vs. execute
  34. Error logging, in a smooth way
  35. how safe are PDO prepared statements
  36. Set PDO to throw exceptions by default [duplicate]
  37. Call to a member function fetch() on boolean [duplicate]
  38. Strange behavior of foreach when using reference: foreach ($a as &$v) { … }
  39. Use bound parameter multiple times
  40. PHP: Get the key from an array in a foreach loop [duplicate]
  41. Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL)
  42. How to prepare statement for update query? [duplicate]
  43. Trying to access array offset on value of type bool
  44. How do detect that transaction has already been started?
  45. What is PDO & why should I use it?
  46. Parametrized PDO query and `LIMIT` clause – not working [duplicate]
  47. PDO + MySQL and broken UTF-8 encoding [duplicate]
  48. Parsing JSON array with PHP foreach
  49. What is the PDO equivalent of function mysql_real_escape_string?
  50. Alternative for mysql_num_rows using PDO

Leave a Comment