-
Notifications
You must be signed in to change notification settings - Fork 0
/
profil.php
124 lines (115 loc) · 5.83 KB
/
profil.php
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
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
<?php
session_start();
$bdd = new PDO('mysql:host=localhost;dbname=hotel;charset=utf8','root','');
if(isset($_SESSION['id'])){
$getid = $_SESSION['id'];
$requser = $bdd->prepare('SELECT * FROM client WHERE id = ?');
$requser->execute(array($getid));
$userinfo = $requser->fetch();
;?>
<!DOCTYPE html>
<html lang="FR">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Connexion</title>
<link rel="stylesheet" href="style.css">
</head>
<header>
<?php include('Navigation.php') ?>
</header>
<body>
<h1>Profil de <?php echo $userinfo['nom'];?></h1>
<br><br>
prenom = <?php echo $userinfo['prenom'];?>
<br>
Mail = <?php echo $userinfo['email'];?>
<br>
telephone= <?php echo $userinfo['telephone'];?>
<br>
adresse = <?php echo $userinfo['adresse'];?>
<br>
date et heure d'inscription = <?php echo $userinfo['date_inscription'];?>
<br>
<a href="deconnexion.php">Se deconnecter</a>
<br>
<br>
<br>
<h1>vos reservations</h1>
<br><br>
<?php
// connexion à la bdd (base de donnée)
try
{
$bdd = new PDO('mysql:host=localhost;dbname=hotel;charset=utf8', 'root', '');
}
catch(Exception $e)
{
die('Erreur : '.$e->getMessage());
}
// fonctions
function supprimer($id_reservation, $bdd) {
$req = $bdd->prepare('DELETE FROM reservation WHERE id= ?');
$req->execute(array($id_reservation));
}
function tri($bdd){
$tri =htmlspecialchars($_POST['tri']);
if($tri =='id'){
return $req = $bdd->query('SELECT chambre.Numero, CONCAT(client.nom,\' \', client.prenom) AS personne, reservation.* FROM chambre, client, reservation WHERE chambre.id = reservation.id_chambre AND client.id = reservation.id_client ORDER BY reservation.id');
}
elseif($tri =='dateD'){
return $req = $bdd->query('SELECT chambre.Numero, CONCAT(client.nom,\' \', client.prenom) AS personne, reservation.* FROM chambre, client, reservation WHERE chambre.id = reservation.id_chambre AND client.id = reservation.id_client ORDER BY reservation.dateD_reservation');
}
elseif($tri =='dateF'){
return $req = $bdd->query('SELECT chambre.Numero, CONCAT(client.nom,\' \', client.prenom) AS personne, reservation.* FROM chambre, client, reservation WHERE chambre.id = reservation.id_chambre AND client.id = reservation.id_client ORDER BY reservation.dateF_reservation');
}
elseif($tri =='num'){
return $req = $bdd->query('SELECT chambre.Numero, CONCAT(client.nom,\' \', client.prenom) AS personne, reservation.* FROM chambre, client, reservation WHERE chambre.id = reservation.id_chambre AND client.id = reservation.id_client ORDER BY chambre.numero');
}
elseif($tri =='nom'){
return $req = $bdd->query('SELECT chambre.Numero, CONCAT(client.nom,\' \', client.prenom) AS personne, reservation.* FROM chambre, client, reservation WHERE chambre.id = reservation.id_chambre AND client.id = reservation.id_client ORDER BY personne');
}
}
// affichage des reservation
?>
<form action="profil.php" method="post">
<label for="tri">Trier par : </label>
<select name="tri">
<option value="id">Identifiant</option>
<option value="dateD">Date de début de reservation</option>
<option value="dateF">Date de fin de reservation</option>
<option value="num">Numéro de chambre</option>
<option value="nom">Nom du client</option>
</select>
<input type="submit" name="trie" value="Trier"/>
</form> <br /><br /><?php
if(isset($_POST['trie'])){
$req = tri($bdd);
} else {
$req = $bdd->query('SELECT chambre.Numero, CONCAT(client.nom,\' \', client.prenom) AS personne, reservation.* FROM chambre, client, reservation WHERE chambre.id = reservation.id_chambre AND client.id = reservation.id_client');
}
while ($donnees = $req->fetch()) { ?>
<div style="display: flex; align-items: baseline;">
<form action="profil.php?id=<?php echo $donnees['id']; ?>" method="post" style="margin-right: 10px;">
<input type="submit" name="Supprimer" value="Supprimer"/>
</form>
<p>
Reservation de la chambre N°<?php echo htmlspecialchars($donnees['Numero']); ?>|
<!-- Par :<?php echo htmlspecialchars($donnees['personne']); ?>| -->
A partir du :<?php echo htmlspecialchars($donnees['dateD_reservation']); ?>|
Jusqu'au :<?php echo $donnees['dateF_reservation'];?>|
Id de la reservation : <?php echo htmlspecialchars($donnees['id']); ?>
<br />
</p>
</div>
<?php }
//appel des fonctions
if(isset($_POST['Supprimer']) && isset($_GET['id'])){
supprimer($_GET['id'],$bdd);
header('Location: profil.php');
}?>
</body>
</html>
<?php
} ?>