How to get results from database with parameters from array? [duplicate]

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
– Petah, Commented Mar 1, 2013 at 8:59
There is an example of this using PDO here: stackoverflow.com/questions/2373562/pdo-with-where-in-queries — Ken
– Ken, Commented Mar 1, 2013 at 9:33

GBD · Accepted Answer · 2013-03-01 09:00:35Z

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 1, 2013 at 9:00

GBD

16k2 gold badges49 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Petah Over a year ago

mysql_query is deprecated.

GBD Over a year ago

@Petah thanks for reminding about deprecation

gries · Accepted Answer · 2013-03-01 08:59:44Z

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 1, 2013 at 8:59

gries

1,1426 silver badges30 bronze badges

3 Comments

Petah Over a year ago

mysql_query is deprecated.

gries Over a year ago

he asked how to do it in his case I gave him the answer what the problem?

Petah Over a year ago

Your answer will only lead to more problems

Community · Accepted Answer · 2017-05-23 11:49:19Z

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, 2017 at 11:49

CommunityBot

11 silver badge

answered Mar 1, 2013 at 8:59

Pedro del Sol

2,8419 gold badges43 silver badges52 bronze badges

2 Comments

Petah Over a year ago

mysql_query is deprecated.

Pedro del Sol Over a year ago

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.

Collectives™ on Stack Overflow

How to get results from database with parameters from array? [duplicate]

3 Answers 3

2 Comments

3 Comments

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

3 Comments

2 Comments

Linked

Related