Passing an array to a query using a WHERE clause

php mysql arrays
Quinn picture Quinn · May 25, 2009 · Viewed 578.8k times · Source

Given an array of ids $galleries = array(1,2,5) I want to have a SQL query that uses the values of the array in its WHERE clause like:

SELECT *
FROM galleries
WHERE id = /* values of array $galleries... eg. (1 || 2 || 5) */

How can I generate this query string to use with MySQL?

Answer

Flavius Stef picture Flavius Stef · May 25, 2009

BEWARE! This answer contains a severe SQL injection vulnerability. Do NOT use the code samples as presented here, without making sure that any external input is sanitized.

$ids = join("','",$galleries);   
$sql = "SELECT * FROM galleries WHERE id IN ('$ids')";

Related questions

Save PHP array to MySQL?

What is a good way to save an array of data to a single mysql field? Also once I query for that array in the mysql table, what is a good way to get it back into array form? Is …

Read More
Mysql where id is in array

I have a string of ids like 1,2,3,4,5 and I want to be able to list all rows in mysql where the ID is contained in that list. I assumed the easiest way would be to turn the string into an …

Read More
Populate PHP Array from While Loop

If I am fetching data from a MySQL database and using a while loop to iterate through the data how would I add each one to array? $result = mysql_query("SELECT * FROM `Departments`"); while($row = mysql_fetch_assoc($result)) { }

Read More