create_journal.php 642 Bytes
Newer Older
Raulin's avatar
Raulin committed
1 2 3
<?php
require_once("template.php");

Raulin's avatar
Raulin committed
4 5 6 7 8 9 10 11 12 13 14 15 16
$a='SELECT `id_aliment` FROM `aliments` WHERE `aliment` ="'.$_POST["select_aliment"].'"';
$b = $mysqli->query($a);
$c=$b->fetch_all();

$idaliment= $c[0][0];
$id=$_SESSION['id'];

if(isset($_POST["date"]) && isset($_POST["quantite"]) && isset($_POST["select_aliment"])){ 
    $requete="INSERT INTO `journal` (`date`,`id`, `id_aliment`,`quantite`) VALUES ( '" .$_POST['date'] . "', '" .$id . "', '" .$idaliment . "', '" . $_POST['quantite'] . "')";
    $mysqli->query($requete);
    $msg="L'élément a bien été ajouté au journal";
} else{
    $msg="Il manque des informations";
Raulin's avatar
Raulin committed
17 18 19 20 21 22 23 24
    }

echo $msg;