Binding parameters for WHERE IN clause with PDO [duplicate]

by

You can’t bind a parameter for the IN clause like that. The $myArray string will only count as one value, like if you did this:

SELECT foo FROM bar WHERE ids IN ('1,2,3')

Even though there are three comma delimited values, the database reads them as only one string value.

You need to manually insert the IN list into the query, the old-school way.

'SELECT foo FROM bar WHERE ids IN (' . $myArray .')'

There is unfortunately no other way. At least for now.

More Related Contents:

  1. PHP / PDO echo data from database into a table
  2. Can I mix MySQL APIs in PHP?
  3. How to apply bindValue method in LIMIT clause?
  4. PDOException “could not find driver”
  5. Row count with PDO
  6. PDO get the last ID inserted
  7. How do I use password hashing with PDO to make my code more secure? [closed]
  8. Error when preparing a multiple insert query
  9. How to view query error in PDO PHP
  10. PDO::__construct(): Server sent charset (255) unknown to the client. Please, report to the developers
  11. Insert/update helper function using PDO
  12. Resetting array pointer in PDO results
  13. PDO multiple queries
  14. How to bind parameters to a raw DB query in Laravel that’s used on a model?
  15. Insert multiple rows with PDO prepared statements
  16. PDO::PARAM for type decimal?
  17. Update query with PDO and MySQL
  18. Is “SET CHARACTER SET utf8” necessary?
  19. Alternative for mysql_num_rows using PDO
  20. Unknown database error in PHP but it exists in PHPMyAdmin
  21. Set PDO to throw exceptions by default [duplicate]
  22. PDO: MySQL server has gone away
  23. How do detect that transaction has already been started?
  24. return one value from database with mysql php pdo
  25. Trying to access array offset on value of type bool
  26. return multiple response data in one response
  27. How to get a query error from prepare() in PDO PHP?
  28. How can I pass an array of PDO parameters yet still specify their types?
  29. PHP PDO how to run a multiple query request?
  30. Using PDO Prepared Statement and Incrementing a column value

Leave a Comment