Look above for the database picture!!!
<div style="padding: 2px; margin-left: 25px">
<input type="checkbox" name="ingredienten[]" value="<?php echo $data['ID'] ?>"><?php echo $data['ingredienten'] ?>
<br>
</div>
<?
if (isset($_POST['ingredienten']) && !empty($_POST['ingredienten'])) {
$where = '';
$count = 1;
foreach ($_POST['ingredienten'] as $ingredienten) {
if($count == 1){
$where .= ' gerechten.ingredienten1='.$ingredienten;
}
else{
$where .= ' OR gerechten.ingredienten1='.$ingredienten;
}
$count += 1;
}
}
$sql = "SELECT * FROM keuzes, keuzes2, keuzes3, keuzes4, register, gerechten WHERE gerechten.IDpersoon = $test AND (".$where.") AND gerechten.ingredienten1 = keuzes.ID AND gerechten.ratings = keuzes3.ID AND gerechten.tijdsduren = keuzes2.ID AND gerechten.maaltijden1 = keuzes4.ID AND gerechten.IDpersoon = register.ID";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
}
} else {
}
$conn->close();
Example column 2: when I choose value: 2 or value: 2 and 4, I get the info out the database, but I don't want the info when I only choose value: 2.
In summary: I need to get info out the database when all values are selected.
Please help me!
Aucun commentaire:
Enregistrer un commentaire