Make a SQL query with the WHERE clause accepting array

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, May 09 '16 at 17:01

score 1 · Answer 1 · answered May 09 '16 at 17:04

1

Try this:

$conditions = '';

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

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

answered May 09 '16 at 17:04

Indrasis Datta

8,692
2
14
32

score -1 · Answer 2 · answered May 09 '16 at 17:02

-1

You must to use IN instead WHERE.

answered May 09 '16 at 17:02

vdelval

1

1

*"You must to use IN instead WHERE."* - You still need to use WHERE with IN() http://dev.mysql.com/doc/refman/5.7/en/comparison-operators.html#function_in as to what the OP wants to do here. – Funk Forty Niner May 09 '16 at 17:02
1

How would you apply your idea to the question example? – Jose Manuel Abarca Rodríguez May 09 '16 at 17:03

Make a SQL query with the WHERE clause accepting array

2 Answers2