mysqli_query "where = $some_array" need just one match

Question

Possible Duplicate:
I have an array of integers, how do I use each one in a mysql query (in php)?

I am trying to create some filtering function and I would like to know if it is possible, within a mysqli query, to check if the table row has a value equal to just one of those in the array. I hope the code will make it clearer:

$age=array(37,35);
$query = mysqli_query($link, "SELECT * FROM users WHERE age = $age");

So I want the query to return all the rows of users whose age is either 37 or 35, but the above code doesn't work.

Using

...WHERE age = 35 OR age = 37"

Won't do, because I want it to be dynamic so to speak.

Thanks

Jason McCreary · Accepted Answer · 2012-06-28T19:15:10.800

4

Use SQL's IN() clause.

SQL Example:

SELECT * FROM users WHERE age IN (35, 37)

PHP Example:

$query = "SELECT * FROM users WHERE age IN (" . implode(',', array_map('intval', $age)) . ")";

Note: Be mindful of SQL Injection.

edited Jun 28 '12 at 19:15

answered Jun 28 '12 at 16:32

Jason McCreary

71,546
23
135
174

You're my hero. Thanks a whole lot! – Patrick Jun 28 '12 at 16:37
If an answer was helpful, please click the check mark to the left of the answer (It will turn green) so the person helping gets the proper credit. – JoeTomato Jun 28 '12 at 16:43
The timer didn't allow me to 5 minutes ago, but I came back to do it right now. Thanks though – Patrick Jun 28 '12 at 16:49

score 2 · Answer 2 · answered Jun 28 '12 at 16:34

2

$age=array(37,35); 
$age_str=implode(',',$age);
$query = mysqli_query($link, "SELECT * FROM users WHERE age in ($age_str)");

answered Jun 28 '12 at 16:34

amaksr

7,555
2
16
17

score 1 · Answer 3 · answered Jun 28 '12 at 16:34

1

Use the php join method together with an IN clause in the SQL

$age=array(37,35);
$query = mysqli_query($link, "SELECT * FROM users WHERE age IN (".join(",", $age).")");

answered Jun 28 '12 at 16:34

Richard Harrison

19,247
4
40
67

Note that `join()` is an alias for `implode()`. I recommend using the root function. – Jason McCreary Jun 28 '12 at 16:35
it's an alias of implode - I tend to use it for readability as implode isn't obvious to me. maybe that's just me though... – Richard Harrison Jun 28 '12 at 16:36

score 1 · Answer 4 · answered Jun 28 '12 at 16:34

1

Use it like this:

$query = mysqli_query($link, "SELECT * FROM users WHERE age IN (" . implode(",",$age) . ")");

answered Jun 28 '12 at 16:34

hjpotter92

78,589
36
144
183

score 1 · Answer 5 · answered Jun 28 '12 at 16:38

1

Use in clause.

$ageArr = implode(',',$age);
SELECT * FROM users WHERE age IN ($ageArr);

answered Jun 28 '12 at 16:38

Nishu Tayal

20,106
8
49
101

mysqli_query "where = $some_array" need just one match

5 Answers5