Page Text: How to pass an array to a query using a WHERE clause with PHP?
Sometimes, we want to pass an array to a query using a WHERE clause with PHP.
In this article, we’ll look at how to pass an array to a query using a WHERE clause with PHP.
How to pass an array to a query using a WHERE clause with PHP?
To pass an array to a query using a WHERE clause with PHP, we create a string with the values in between the parentheses and interpolate them into the SQL string.
For instance, we write
$in = join(',', array_fill(0, count($ids), '?')); $select = <<prepare($select); $statement->bind_param(str_repeat('i', count($ids)), ...$ids); $statement->execute(); $result = $statement->get_result();
to create an array with the values with array_fill(0, count($ids), '?').
Then we join them with ', ' and assign the combined string to $in.
Then we add the placeholders into the $seelct string.
Then we call bind_params with 'i' repeated for the number of times equal to the count of $ids and the values in $ids.
Then we call execute to run the statement and call get_result to get the returned results.
Conclusion
To pass an array to a query using a WHERE clause with PHP, we create a string with the values in between the parentheses and interpolate them into the SQL string.
Posted on