1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48
| <?php
$link = mysqli_connect("localhost", "root", "password", "db");
// Check connection
if($link === false){
die("ERROR: Could not connect. " . mysqli_connect_error());
}
// Escape user inputs for security
$courriel = mysqli_real_escape_string($link, $_REQUEST['courriel']);
$nombres = mysqli_real_escape_string($link, $_REQUEST['nombres']);
$date = mysqli_real_escape_string($link, $_REQUEST['date']);
$heures = mysqli_real_escape_string($link, $_REQUEST['heures']);
// attempt insert inscription
$sql = "INSERT INTO reservation (courriel, nombres, date, heures) VALUES ('$courriel', '$nombres', '$date', '$heures' )";
if(mysqli_query($link, $sql)){
header("Location: reservation.php");
} else{
echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}
$sql = mysql_query("SELECT SUM(CAST(nombre as AS UNSIGNED) AS total) FROM reservation WHERE date=$date");
$row = mysql_fetch_array($sql);
$total = $row['total'];
if ($total > 46) {
echo ' <i>Le restaurant est complet, veuillez choisir une autre heure ou journée</i><br>';
}
else
{
echo "Votre réservation à bien été complété avec succès!";
}
// close connection
mysqli_close($link);
?> |
Partager