Mysql query based on unknown number of parameters

Question

Users select some parameters with checkboxes from an HTML form:

Example: they choose eggs, carrots and beans from 100 possible ingredients.

These selected parameters are stored in an array such as $ingredients['eggs','carrots','beans'];

A mysql query has to input name results where eggs=1, carrots=1, and beans=1

    $db->query("SELECT name, FROM ingredients WHERE eggs=1, carrots=1, beans=1")->fetchall();

But how if I have $ingredients has a different size?

Thanks for your help.

generate string for where condition through foreach loop and concat with query. — Akshay
– Akshay, Commented Sep 24, 2015 at 9:44
You haven't given us much to go on. What is your database structure? — Kuya
– Kuya, Commented Sep 24, 2015 at 9:48
he just want a where part of the query like he asked?? why do you need database stucture???? @Kuya — Akshay
– Akshay, Commented Sep 24, 2015 at 10:44

Ko Cour · Accepted Answer · 2015-09-24 09:51:34Z

3

$where = "WHERE 1 ";
foreach($ingredients as $key=>$value){
    $where.=" AND {$value}=1";
}

Ko Cour

9432 gold badges18 silver badges29 bronze badges

answered Sep 24, 2015 at 9:47

Akshay

2091 silver badge14 bronze badges

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

1 Answer 1