connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$memberId = $_SESSION['user_id']; // Get user ID from session
// Fetch user's bookings
$sql = "SELECT b.*, c.name AS class_name FROM booking b LEFT JOIN class c ON b.reference_id = c.id WHERE b.member_id = ?";
$stmt = $conn->prepare($sql);
$stmt->bind_param("i", $memberId);
$stmt->execute();
$result = $stmt->get_result();
?>
Manage Bookings
Your Bookings
num_rows > 0): ?>
| Booking ID |
Class Name |
Booking Date |
Status |
fetch_assoc()): ?>
|
|
|
|
No bookings found.
Book a Class