lundi 16 mai 2016

How to select info out the database with checkboxes?

Image:

enter image description here

Look above for the 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']))
{
    foreach($_POST['ingredienten'] as $ingredienten)
    {

    }
    // eg. "apple, grapefruit"
    echo $fruitList = implode(' ', $_POST['ingredienten']);
    // -- insert into database call (for fruitList) might go here.
}

$sql = "SELECT * FROM keuzes, keuzes2, keuzes3, keuzes4, register, gerechten WHERE gerechten.IDpersoon = $test AND gerechten.ingredienten1 = $fruitList 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();

If you look at the picture you see values. Every number is an item of the checkboxes! My question is: if I select all these numbers, I want to drop this out the database, but I get only information when I select the first number of the database.

Why do I get only data if I choose the first number and not all of them?

Please help me!




Aucun commentaire:

Enregistrer un commentaire