1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
| function getByFilter($ingredient, $type, $region) {
$sql="select rec.id_rec, rec.titre, rec.description, rec.photo from recettes rec, rec_ingr_unite, ingredients, formes, types, regions
where rec.id_rec = rec_ingr_unite.id_rec and rec_ingr_unite.id_ingr = ingredients.id_ingr and rec.fkidReg = regions.id_reg
and rec.fkidForme = formes.id_forme and formes.fkidType = types.id_type";
if(!empty($indredient)) {
$sql .= " and ingredients.id_ingr= :id_ingr";
}
if(!empty($type)) {
$sql.= " and types.id_type = :id_type";
}
if(!empty($region)) {
$sql .= " and regions.id_reg =:id_reg";
}
$req=$this->bdd->prepare($sql);
if(!empty($ingredient)){
$req->bindParam(':id_ingr', $ingredient);
}
if(!empty($type)){
$req->bindParam(':id_type', $type);
}
if(!empty($region)){
$req->bindParam(':id_reg', $region);
}
$req->execute();
return $req->fetchAll(PDO::FETCH_ASSOC);
}
} |
Partager