How do you use IN clauses with mysqli prepared statements [duplicate]

by

It’s not possible to bind a list of variable length to a single bound variable.

Similarly, if you were to bind the string $ids you’ll actually end up with:

SELECT foo,blar FROM table WHERE id IN ('123,535,345,567,878')

(Note the quotes around the list of IDs).

Creating your own query with the right number of question marks and bound parameters should have actually worked – you may need to try that again and report on the actual error.

Alternatively, this may be one of those occasions where it’s unfortunately necessary to hand-craft your own SQL and not use bound parameters.

More Related Contents:

  1. PHP create new array by value
  2. PHP Mysqli query update not working with variable
  3. Turning a SQL row into an array
  4. How to insert database rows if there are no answers
  5. two person chat room
  6. Pagination data
  7. Fatal error: Call to a member function bind_param() on boolean [duplicate]
  8. Example of how to use bind_result vs get_result
  9. mysqli::query(): Couldn’t fetch mysqli
  10. get array of rows with mysqli result
  11. How to start and end transaction in mysqli?
  12. How to install MySQLi on MacOS
  13. How do I iterate over the results in a MySQLi result set?
  14. PHP MySQLI Prevent SQL Injection [duplicate]
  15. The mysqli extension is missing. Please check your PHP configuration
  16. How to test if a MySQL query was successful in modifying database table data?
  17. mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in [duplicate]
  18. PHP Commands Out of Sync error
  19. MYSQLi error: User already has more than ‘max_user_connections’ active connections [duplicate]
  20. $stmt->execute() : How to know if db insert was successful?
  21. store_result() and get_result() in mysql returns false
  22. Checking if mysqli_query returned any values?
  23. Warning: mysqli_query() expects parameter 1 to be mysqli, string given in
  24. Mysqli Prepare Statement – Returning False, but Why? [duplicate]
  25. Fatal error: Call to undefined method mysqli_result::fetch_all()
  26. How to run the bind_param() statement in PHP?
  27. mysqli – fetch_Array error call to a member function fetch_array() on a non-object mysqli [duplicate]
  28. Set character set using MySQLi
  29. Cannot figure out how to run a mysqli_multi_query and use the results from the last query
  30. How to get a list of databases?

Leave a Comment