Can I bind an array to an IN() condition in a PDO query?

by

You’ll have to construct the query-string.

<?php
$ids     = array(1, 2, 3, 7, 8, 9);
$inQuery = implode(',', array_fill(0, count($ids), '?'));

$db = new PDO(...);
$stmt = $db->prepare(
    'SELECT *
     FROM table
     WHERE id IN(' . $inQuery . ')'
);

// bindvalue is 1-indexed, so $k+1
foreach ($ids as $k => $id)
    $stmt->bindValue(($k+1), $id);

$stmt->execute();
?>

Both chris (comments) and somebodyisintrouble suggested that the foreach-loop …

(...)
// bindvalue is 1-indexed, so $k+1
foreach ($ids as $k => $id)
    $stmt->bindValue(($k+1), $id);

$stmt->execute();

… might be redundant, so the foreach loop and the $stmt->execute could be replaced by just …

<?php 
  (...)
  $stmt->execute($ids);

More Related Contents:

  1. PHP – Using PDO with IN clause array
  2. How to bind mysqli bind_param arguments dynamically in PHP?
  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. Get last insert id after a prepared insert with PDO
  8. How do I use pdo’s prepared statement for order by and limit clauses?
  9. Insert multiple rows with PDO prepared statements
  10. Replacing mysql_* functions with PDO and prepared statements
  11. Is there a way to fetch associative array grouped by the values of a specified column with PDO?
  12. PHP PDO::bindParam() data types.. how does it work?
  13. Binding params for PDO statement inside a loop
  14. PDOstatement (MySQL): inserting value 0 into a bit(1) field results in 1 written in table
  15. PDO fetch one column from table into 1-dimensional array
  16. Calling stored procedure with Out parameter using PDO
  17. When *not* to use prepared statements?
  18. PDO fetchAll array to one dimensional
  19. Which tokens can be parameterized in PDO prepared statements?
  20. Using value of a column as index in results using PDO
  21. Retrieve (or simulate) full query from PDO prepared statement
  22. PDO error: SQLSTATE[HY000]: General error: 2031
  23. Use of PDO in classes [duplicate]
  24. Error while using PDO prepared statements and LIMIT in query [duplicate]
  25. PHP/SQL Insert Error when using Named Placeholders
  26. How to squeeze error message out of PDO? [duplicate]
  27. List of Big-O for PHP functions
  28. How do I enable php to work with postgresql?
  29. PHP curly braces in array notation
  30. Recreate original PHP array from print_r output [duplicate]

Leave a Comment