Paying Guest Accommodation System using PHP & MySQL

he Paying Guest Accommodation System using PHP and MySQL is a highly practical and user-friendly final year project designed for BCA, MCA, B.Tech, and M.Tech students. It helps manage PG room bookings, tenant information, payment tracking, and availability — all from one centralized platform.

Moreover, this system is developed using core PHP and MySQL, ensuring speed and efficiency. It includes separate modules for both admins and tenants. Admins, for instance, can add new PG properties, update room availability, track rental payments, and respond to inquiries. Tenants, on the other hand, can browse available rooms, view rent details, apply online, and make payments. As a result, the system reduces manual work, eliminates paperwork, and improves transparency between property owners and tenants.

In addition, it provides a modern alternative to traditional PG management methods by offering an online experience that is accessible from anywhere.

In Paying Guest Accommodation System project we use PHP and  Mysql database. It has three modules.

1.Admin Module

2.PG Owner Module

3.User Module

Admin Module

1. Dashboard: In this section, admin can see all detail in brief like total state, total city, total owner and total pg.
2. State: In this section, admin can manage state(add/update).
3. City: In this section, admin can manage city(add/update).
4. Reg Owner: In this section, admin can view and edit the registered owner.
5. PG Details: In this section, admin can view pg detail which is listed by pg owner.
6. Reg. Users: In this section admin can view the details of users and their bookings.
7. Pages: In this section, admin can manage about us and contact us pages.

Admin can also update his profile, change the password and recover the password.

PG Owner Module

1. Dashboard: In this section, owner can see all detail in brief like total listed pg, total booking, total new booking, total confirmed booking, and total canceled booking.
2. List Your PG: In this section, owner can list their pg.
3. Received Booking Request: In this section, admin can view new booking and he has right to confirmed booking.
4. Search: In this section, the owner can search booking request by booking number.
5. Notification: In this owner can see new notification of booking.

The owner can also update his profile, change the password and recover the password.

User Module

In this module, there is two types of user guest user and registered user.

Guest User: In this guest, user can see only general information like about us, pg details, search pg and contact details.

Registered users can do the following activity

1. Book the pg.

2. Update his/her own profile.

3. Change Password.

4. Registered user can also recover his/her own password.

This Paying Guest Management System PHP project includes complete source code, a structured MySQL database, detailed documentation, ER diagrams, DFDs, and a presentation file for project submission. Furthermore, the system is built with clean, modular code, making it easy for students to understand, deploy, and enhance as needed.

Additionally, it offers real-time features such as rent alerts, booking confirmations, and status updates — which are essential for building real-world web applications. Therefore, students not only learn PHP and MySQL, but also understand how to develop solutions that address real problems.

Most importantly, this project is ideal for final year submissions, viva sessions, and practical demonstrations. As such, if you’re looking for a project that is easy to implement yet impactful, the PG Accommodation System is a perfect fit.