Live Demo Interface

Room Scheduler System

A full-stack conference room booking platform supporting scheduling, equipment tracking, and administrative management — built with PHP, MySQL, HTML, and CSS.

PHP 8 MySQL HTML5 CSS3 CRUD Operations Database Design
View Source Code
Total Rooms
5
Conference spaces
Active Bookings
8
This month
Available Now
3
Ready to book
Equipment Items
12
Tracked resources

Upcoming Bookings

Room Organizer Time Status

Room Availability

RoomCapacityFloorStatus

Quick Book a Room

Fill in the details below to create a new booking. Conflicts are checked automatically before confirming.
Room Management
Conference Rooms
Scheduling
All Bookings
# Room Meeting Title Organizer Date Time Status Actions
Availability at a Glance

February 2026

Sun
Mon
Tue
Wed
Thu
Fri
Sat
Has bookings
Today
Available
Resource Tracking
Equipment Inventory
Item Category Assigned Room Condition Actions
Architecture & Implementation
Technical Details

Database Schema

  • Rooms table — ID, name, floor, capacity, status
  • Bookings table — ID, room_id (FK), organizer, date, start/end time, title, status
  • Equipment table — ID, name, category, room_id (FK), condition
  • Users table — ID, name, email, role, profile data
  • Foreign key constraints ensure referential integrity

PHP Backend

  • db.php — PDO connection layer with prepared statements
  • room.php / equipment.php — Insert handlers
  • display.php / DisplayTables.php — Read / list views
  • update.php / update2.php — Edit record flows
  • delete.php / delete2.php — Soft-delete handlers
  • Join.php — Multi-table JOIN queries

CRUD Workflow

  • Create — HTML forms POST to PHP insert handlers
  • Read — PHP SELECT queries render dynamic tables
  • Update — Pre-filled forms via fill_to_update.php pattern
  • Delete — Confirmation forms before execution
  • Conflict detection — Time overlap query logic before booking inserts
  • JOIN queries — Booking ↔ Room ↔ Equipment relational views

Skills Demonstrated

  • Relational database design with normalization
  • Server-side form validation and sanitization
  • PDO prepared statements for SQL injection protection
  • Multi-table JOIN queries for relational reporting
  • Structured HTML/CSS UI without a framework
  • Admin flow separation from user booking flow

Data Flow Architecture

HTML Form
→
PHP Handler
→
MySQL DB

POST request → validate & sanitize → PDO prepared statement → MySQL → redirect with status

View Full Source on GitHub