ajoutReservation.php
2.39 KB
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
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8"/>
<title>Page principale</title>
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.1/dist/css/bootstrap.min.css"
rel="stylesheet"
integrity="sha384-+0n0xVW2eSR5OomGNYDnhzAbDsOXxcvSN1TPprVMTNDbiYZCxYbOOl7+AMvyTG2x"
crossorigin="anonymous">
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.1/dist/js/bootstrap.bundle.min.js"
integrity="sha384-gtEjrD/SeCtmISkJkNUaaKMoLD0//E1J19smozuHV6z3Iehds+3Ulb9Bn9Plx0x4"
crossorigin="anonymous">
</script>
</head>
<body>
<?php
session_start();
if(isset($_SESSION['identifiant'])){
$login = $_SESSION['identifiant'];
echo "Vous etes : $login <br>";
}
include("connexion.php");
if(isset($_POST['txtDate']) && isset($_POST['banc']) && isset($_POST['heure'])){
$date = $_POST['txtDate'];
$banc = $_POST['banc'];
$heure = $_POST['heure'];
echo "date = ".$date." // banc = ".$banc." // heure = ".$heure."<br>" ;
$explosion = explode('-',$date);
$annee = $explosion[0];
$mois = $explosion[1];
$jour = $explosion[2];
$date = $jour."/".$mois."/".$annee;
echo "New date = ".$date."<br>";
$heurefin = (int)$heure + 1;
if($heurefin==24){
$heurefin = 0;
}
if(strlen($heurefin)==1){
$heurefin = "0".$heurefin;
}
if(strlen($heure)==1){
$heure = "0".$heure;
}
$heure = $heure.":00";
$heurefin = $heurefin.":00";
echo "Heure = ".$heure."<br>";
echo "Heure de fin = ".$heurefin."<br>";
$requete = "INSERT INTO reservation VALUES($banc,'$date','$login','$heure','$heurefin')";
$exec_requete = mysqli_query($db,$requete);
echo "<meta http-equiv=\"refresh\" content=\"0;url=mesReservations.php\">";
}elseif(isset($_GET['txtDate']) && isset($_GET['banc']) && isset($_GET['heure'])){
$date = $_GET['txtDate'];
$banc = $_GET['banc'];
$heure = $_GET['heure'];
$requete = "INSERT INTO reservation VALUES($banc,'$date','$login','$heure','$heurefin')";
$exec_requete = mysqli_query($db,$requete);
$requete = "INSERT INTO creneau VALUES('$date')";
$exec_requete = mysqli_query($db,$requete);
echo "<meta http-equiv=\"refresh\" content=\"0;url=gestionReservation.php\">";
}else{
//echo "L'ajout n'a pas fonctionné";
echo "<meta http-equiv=\"refresh\" content=\"0;url=reservation.php?erreur=1\">";
}
mysqli_close($db);
?>
</body>
</html>