PDO with “WHERE… IN” queries [duplicate]

by

Since you can’t mix Values (the Numbers) with control flow logic (the commas) with prepared statements you need one placeholder per Value.

$idlist = array('260','201','221','216','217','169','210','212','213');

$questionmarks = str_repeat("?,", count($idlist)-1) . "?";

$stmt = $dbh->prepare("DELETE FROM `foo` WHERE `id` IN ($questionmarks)");

and loop to bind the parameters.

More Related Contents:

  1. Insert form in MySQL with PDO [duplicate]
  2. Undefined index $_POST
  3. Are PDO prepared statements sufficient to prevent SQL injection?
  4. Reference — frequently asked questions about PDO
  5. Getting raw SQL query string from PDO prepared statements
  6. How do I set ORDER BY params using prepared PDO statement?
  7. “Invalid parameter number: parameter was not defined” Inserting data
  8. Having issue with matching rows in the database using PDO
  9. How can I properly use a PDO object for a parameterized SELECT query
  10. How do I return integer and numeric columns from MySQL as integers and numerics in PHP?
  11. pdo – Call to a member function prepare() on a non-object [duplicate]
  12. How to replace MySQL functions with PDO?
  13. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  14. Real escape string and PDO [duplicate]
  15. How to check if a row exist in the database using PDO?
  16. PHP PDO vs normal mysql_connect
  17. Can I create a database using PDO in PHP?
  18. PHP PDO::bindParam() data types.. how does it work?
  19. PHP PDO and MySQLi [duplicate]
  20. PDO fetch one column from table into 1-dimensional array
  21. Using value of a column as index in results using PDO
  22. Getting a PHP PDO connection from a mysql_connect()?
  23. PHP Laravel: No connection could be made because the target machine actively refused it
  24. PDO bindParam into one statement?
  25. PDO Unbuffered queries
  26. escaping column name with PDO
  27. prepared parameterized query with PDO
  28. What is the PDO equivalent of function mysql_real_escape_string?
  29. Installing PDO driver on MySQL Linux server
  30. PDO Exception Questions – How to Catch Them

Leave a Comment