-
Notifications
You must be signed in to change notification settings - Fork 1
/
bookings.php
51 lines (41 loc) · 1.05 KB
/
bookings.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
<?php
include("auth_session.php");
include("db.php");
?>
<html lang="en">
<head>
<title>My Bookings</title>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="dashboard-style.css?version=51"/>
</head>
<body>
<div class="header">
<h1>Your Bookings</h1>
<p>Vaccination Appointments registered under this account will appear here</p>
</div>
<?php
$accid=$_SESSION['username'];
$result = mysqli_query($conn,"SELECT * FROM Bookings WHERE Booking_Account_Id='$accid' ");
echo "Vaccination appointments made under this account: <br><br>";
echo "<table border='1'>
<tr>
<th>Name</th>
<th>Age</th>
<th>Address</th>
<th>Date of Vaccination Appointment</th>
</tr>";
while($row = mysqli_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['Name'] . "</td>";
echo "<td>" . $row['Age'] . "</td>";
echo "<td>" . $row['Address'] . "</td>";
echo "<td>" . $row['Bookings_Date'] . "</td>";
echo "</tr>";
}
echo "</table>";
mysqli_close($conn);
?>
</body>
</html>