Booking Availability Checker (Hosted on AWS)

Apr. 2025

This project is a web-based booking availability system developed using PHP, JavaScript, HTML/CSS, and MySQL. It was originally run locally via XAMPP, but has since been successfully deployed on AWS infrastructure using an EC2 instance and an RDS-hosted database. public IP.

Objectives

Allow users to check and book available slots by location, date and time
Deploy the application on AWS EC2 and connect it to RDS
Demonstrate integration between frontend, backend, and cloud services

Tools & Technologies

AWS EC2 and RDS (MySQL)
Apache Web Server
phpMyAdmin
PHP, HTML, CSS, JavaScript

Deployment and workflow

Configured an RDS MySQL database instance
Launched EC2 with LAMP stack and uploaded code via FileZilla
Adjusted PHP config to connect to the RDS endpoint
Imported the booking database and tested functionality via EC2 IP

Project Photos

Project Photo 1

Project Photo 2

Project Photo 3

Result

The system is now fully accessible online. Users can check availability and make bookings in real-time. This demonstrated successful migration of a local project to the cloud.