prepare("INSERT INTO buildings (name) VALUES (?)");
$stmt->execute([$_POST['building_name']]);
} elseif (isset($_POST['add_room'])) {
$stmt = $pdo->prepare("INSERT INTO rooms (building_id, name, capacity) VALUES (?, ?, ?)");
$stmt->execute([$_POST['building_id'], $_POST['room_name'], $_POST['capacity']]);
}
header("Location: admin.php");
exit;
}
// Fetch data
$pdo = db();
$buildings = $pdo->query("SELECT * FROM buildings ORDER BY name")->fetchAll(PDO::FETCH_ASSOC);
$rooms = $pdo->query("SELECT r.*, b.name as building_name FROM rooms r JOIN buildings b ON r.building_id = b.id ORDER BY b.name, r.name")->fetchAll(PDO::FETCH_ASSOC);
?>
Admin - Room Reservation Manager
Admin Dashboard
Add New Building
Existing Buildings
| Name |
Actions |
|
|
| No buildings found. |
Add New Room
Existing Rooms
| Room |
Building |
Capacity |
Status |
|
|
|
|
| No rooms found. |