-
Notifications
You must be signed in to change notification settings - Fork 0
/
reservations.php
66 lines (59 loc) · 1.99 KB
/
reservations.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
<?php
session_start();
$host="remotemysql.com";
$dbusername="M2M1cnixjh";
$dbpassword="RMelnhl7c8";
$db="M2M1cnixjh";
$cn=mysqli_connect($host, $dbusername, $dbpassword, $db);
$e=$_SESSION['username'];
?>
<html>
<head>
<title>reservations</title>
<h1><strong>YOUR RESERVATIONS</strong></h1>
<hr>
<link rel="stylesheet" type="text/css" href="bootstrap.css">
<link rel="stylesheet" type="text/css" href="restaurants.css">
</head>
<body>
<div class="sidenav">
<br>
<a href="profile.php">Profile</a><br>
<a href="home.html">Home</a><br>
<a href="reviews.html">Review</a><br>
<a href="restaurant.html">Reserve</a><br>
<a href="logout.php">Logout</a><br>
</div>
<br>
<br>
<div class="container">
<?php
$msg=' ';
$result=mysqli_query($cn,"select r.restname,t.rdate,t.rtime,t.tables from table1 t,restaurant r where r.restid=t.restid and t.userid='$e'");
if (mysqli_num_rows($result) > 0) {
while($row = mysqli_fetch_assoc($result)) {
$restname=$row['restname'];
$rdate=$row['rdate'];
$rtime=$row['rtime'];
$no_of_tables=$row['tables'];
?>
<div class="tbox">
<img class="pic" src="images/rrest.png">
<div class="nameplate">
<span> RESTAURANT NAME : <?php echo $restname; ?> </span> <br><br>
<span> DATE : <?php echo $rdate; ?> </span> <br><br>
<span> TIME : <?php echo $rtime; ?> </span> <br><br>
<span> TABLES : <?php echo $no_of_tables; ?> </span><br><br>
</div>
</div>
<br><br><br>
<?php } }
else
{
$msg = "<div class='msg1'><h3 style='color:red;'>No Reservations Yet!!</h3></div>";
}
?>
<?php echo $msg; ?>
</div>
</body>
</html>