Untitled

<!Doctype html>


   <html>
    <head>
        <meta charset="UTF-8" />
        <title>Trouve ta recette</title>
    </head>
 <form method="POST" action="composition.php">
            <input type="checkbox" name="lardon" value="1" />lardon
            <input type="checkbox" name="jambon" value="1" />jambon
            <input type="checkbox" name="tomate" value="1" />tomate
            <input type="checkbox" name="pate" value="1" />pate
            <input type="checkbox" name="riz" value="1" />riz
            <input type="checkbox" name="creme" value="1" />creme
            <input type="checkbox" name="pomme_de_terre" value="1" />pomme de terre
            <input type="checkbox" name="viande_hachee" value="1" />viande hachée
            <input type="checkbox" name="poisson" value="1" /> poisson
            <input type="checkbox" name="eau" value="1" />eau
            <input type="checkbox" name="fromage" value="1" />fromage
            <input type="submit" value="Envoyer"/>

    </form>


<?php
try
{
    $bdd=new PDO('mysql:host=localhost;dbname=phpisn2;charset=utf8','root','', array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES \'UTF8\'', PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION));

}
catch(PDOException $e)
{
    die('Erreur:'.$e->getMessage());
}

if(isset($_POST['lardon'])){$lardon=1;} else {$lardon=0;}
if(isset($_POST['jambon'])) {$jambon=1;} else {$jambon=0;}
if(isset($_POST['tomate'])) {$tomate=1;} else {$tomate=0;}
if(isset($_POST['pate'])) {$pate=1;} else {$pate=0;}
if(isset($_POST['riz'])) {$riz=1;} else {$riz=0;}
if(isset($_POST['creme'])) {$creme=1;} else {$creme=0;}
if(isset($_POST['pomme_de_terre'])) {$pomme_de_terre=1;} else {$pomme_de_terre=0;}
if(isset($_POST['viande_hachee'])) {$viande_hachee=1;} else {$viande_hachee=0;}
if(isset($_POST['poisson'])) {$poisson=1;} else {$poisson=0;}
if(isset($_POST['eau'])) {$eau=1;} else {$eau=0;}
if(isset($_POST['fromage'])) {$fromage=1;} else {$fromage=0;}


$req = $bdd->query("SELECT recette FROM composition WHERE lardon=$lardon AND jambon=$jambon AND tomate=$tomate AND pate=$pate  AND riz=$riz AND creme=$creme AND pomme_de_terre=$pomme_de_terre AND viande_hachee=$viande_hachee AND poisson=$poisson AND eau=$eau AND fromage=$fromage");

while ($recette=$req->fetch())
{
    echo($recette['recette']).'<br />';
    /*echo("<a href=".$recette['recette'].".html");*/
}


?>
</html>