lundi 16 mai 2016

Echo data when all checkboxes values are selected, how?

Image database

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