Make a SQL query with the WHERE clause accepting array [duplicate]

Question

I have an array of six elements ($categories = array('dinner','casual','wedding')) and I would like to make a SQL query that would look like this:

SELECT * FROM produts WHERE id = /* values of array $categories... eg. (dinner || casual || wedding) */

Are you trying to get the results for all items in the array in the same query or were you looking for separate queries for each item? — The 42nd Doctor
– The 42nd Doctor, Commented May 9, 2016 at 17:01

Indrasis Datta · Accepted Answer · 2016-05-09 17:04:29Z

1

Try this:

$conditions = '';

foreach($categories as $cat) {
    $conditions[] = " id = '".$cat."'";
}

$sql = 'SELECT * FROM produts WHERE '.implode(" OR ", $conditions);

answered May 9, 2016 at 17:04

Indrasis Datta

8,6182 gold badges18 silver badges32 bronze badges

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

Comments

vdelval · Accepted Answer · 2016-05-09 17:02:00Z

-1

You must to use IN instead WHERE.

answered May 9, 2016 at 17:02

vdelval

1

2 Comments

Funk Forty Niner Over a year ago

"You must to use IN instead WHERE." - You still need to use WHERE with IN() dev.mysql.com/doc/refman/5.7/en/… as to what the OP wants to do here.

Jose Manuel Abarca Rodríguez Over a year ago

How would you apply your idea to the question example?

Collectives™ on Stack Overflow

Make a SQL query with the WHERE clause accepting array [duplicate]

2 Answers 2

Comments

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Linked

Related