How to get results from database with parameters from array?

Question

I have table like this:

ID | title       | category
-----------------------------
1  | product1    | 0
2  | product2    | 0
3  | product3    | 1
4  | product4    | 1
5  | product5    | 3

I have array with ID's, how do I select products with those ID?

I mean something like this but category can be any value from array not only one value like in example.

$result = mysql_query("SELECT * FROM product where category = '$var'");

Not like that. Use PDO or `mysqli_*`, and escape your variables. — Petah, Mar 01 '13 at 08:59
There is an example of this using PDO here: http://stackoverflow.com/questions/2373562/pdo-with-where-in-queries — Ken, Mar 01 '13 at 09:33

score 3 · Answer 1 · answered Mar 01 '13 at 09:00

3

Try this way

$arr = array(1,2);
$str = implode(',',$arr);

$result = mysql_query("SELECT * FROM product where category IN (".$str.") ");

Note that: Try to avoid the MySQL extenstions, try to use PDO or prepared statements instead.

answered Mar 01 '13 at 09:00

GBD

15,847
2
46
50

`mysql_query` is deprecated. – Petah Mar 01 '13 at 09:01
@Petah thanks for reminding about deprecation – GBD Mar 01 '13 at 09:03

score 1 · Accepted Answer · answered Mar 01 '13 at 08:59

1

$ids = implode(',', $ids); // array(1,2,3,4) =>  '1,2,3,4'
$result = mysql_query("SELECT * FROM product WHERE category IN ('$ids')");

answered Mar 01 '13 at 08:59

gries

1,135
6
29

`mysql_query` is deprecated. – Petah Mar 01 '13 at 09:00
3

he asked how to do it in his case I gave him the answer what the problem? – gries Mar 01 '13 at 09:01
Your answer will only lead to more problems – Petah Mar 01 '13 at 09:02

score 1 · Answer 3 · edited May 23 '17 at 11:49

1

aside from out of date mysql_* functions and sql injection...

$result = mysql_query("SELECT * FROM product where category in ('$list_of_ids')");

edited May 23 '17 at 11:49

Community

1
1

answered Mar 01 '13 at 08:59

Pedro del Sol

2,840
9
39
52

`mysql_query` is deprecated. – Petah Mar 01 '13 at 09:00
2

i'm well aware of that and did link the op some other questions to make them aware too. the sql itself is the answer. – Pedro del Sol Mar 01 '13 at 09:02

How to get results from database with parameters from array?

3 Answers3