Hostel Management System in PHP and MySQL — Final Year Project with Source Code

A Hostel Management System in PHP and MySQL is a web application that replaces a hostel's paper registers with one simple online system for student admission, room allotment, mess details and fee records. It is made for BCA, MCA, B.Tech and M.Tech final-year students who need a practical project that is easy to build, easy to demonstrate and easy to explain in the viva. On this page you will find the complete project synopsis, the admin and student modules, the database tables with SQL, and the exact steps to run the project on XAMPP.

Project Synopsis

Walk into any college hostel office and you will see the real problem this project solves. The warden maintains admission registers in thick notebooks, room allotment is written by hand, and fee receipts are stored in files that nobody can search quickly. If a parent calls to ask whether their child's hostel fee is paid, someone has to flip through hundreds of pages. Rooms sometimes get allotted twice by mistake, a leaking tap complaint gets noted on a loose paper and quietly disappears, and at the end of the month nobody knows exactly how much fee is still pending.

The Hostel Management System moves all of this work into a browser. The admin adds rooms and beds, admits students, allots rooms, records hostel and mess fees, and answers complaints from one dashboard. Students log in with their own account to see their room details, check the mess menu, view their fee status and download receipts. Every record is stored safely in a MySQL database, so searching for any student, room or payment takes seconds instead of an afternoon.

Why This Project Scores Well in Final Year

Examiners like projects that solve a visible, everyday problem, and hostel management is something every teacher and student has personally experienced. The project is CRUD-heavy, which is good news for you: almost every screen is about adding, viewing, editing or deleting records, so the core logic stays simple and well within reach of an average student. In fact, the whole system is a nicely organised CRUD app in PHP and MySQL with login, sessions and reports on top.

It also makes the viva comfortable. The questions stay predictable: How does login work? How do you stop double allotment of a bed? Why did you normalise the tables? If you have built forms with validation, used prepared statements and written a few JOIN queries for reports, you can answer almost everything calmly. And because the scope has natural extra features like visitor logs and fee defaulter reports, the project looks complete without becoming risky.

Modules of the Project

The admin (warden) controls the complete hostel, while each student gets a limited account for their own information.

Admin Module

• Dashboard: total students, total rooms, occupied and vacant beds, and the month's fee collection at a glance.
• Manage Rooms and Beds: add rooms, set room type and bed capacity, and update room fees.
• Student Admission: register new students with course, semester, address and guardian details.
• Room Allotment: assign an available bed to a student and vacate it when the student leaves.
• Mess and Fee Records: record hostel and mess fee payments and generate receipts.
• Complaints: view student complaints and mark them pending, in progress or resolved.
• Visitor Log: entry of visitors with in-time and out-time for hostel security.
• Reports: room occupancy report, student list and fee defaulter report.

Student Module

• Register and Login: students create an account and log in securely.
• View Allotted Room: see room number, room type and roommates.
• Mess Menu: check the weekly mess menu and mess charges.
• Fee Status and Receipts: view paid and pending fees and download receipts.
• Complaint Box: submit complaints about water, electricity, furniture or cleanliness.
• Room-Change Request: request a room change with a reason for the warden to approve.

Main Features

Technology Stack

The stack is kept simple and free, so the same project runs on any college lab computer. If you are new to the backend part, first learn how to connect PHP with MySQL, because every module in this project depends on that one skill. For database queries, use PHP Data Objects (PDO) with prepared statements instead of writing raw queries with user input. Prepared statements protect the login and admission forms from SQL injection, and examiners love asking about exactly that.

Database Tables

The database stays small and clean with five main tables. Each table does one job, which keeps your ER diagram neat and your normalisation answer in the viva very simple.

Here is the SQL for the rooms table. If you want to understand every column option used here, the official MySQL CREATE TABLE documentation explains them clearly.

CREATE TABLE rooms (
    id INT AUTO_INCREMENT PRIMARY KEY,
    room_no VARCHAR(10) NOT NULL UNIQUE,
    room_type ENUM('Single', 'Double', 'Triple') DEFAULT 'Double',
    total_beds INT NOT NULL,
    occupied_beds INT DEFAULT 0,
    fees_per_bed DECIMAL(10,2) NOT NULL
);

How to Run This Project on XAMPP

1. Download and install XAMPP on your computer, then open the XAMPP Control Panel and start the Apache and MySQL services.
2. Extract the project files and copy the project folder into the htdocs folder inside your XAMPP installation directory.
3. Open your browser and go to localhost/phpmyadmin, then create a new database for the project.
4. Select the new database, open the Import tab, choose the provided .sql file and import it to create all tables.
5. Check the database connection settings in the project's config file so the database name and username match your setup.
6. Now visit localhost followed by your project folder name in the browser, and log in with the admin details given in the project readme file.

What You Get in the Complete Project

Reading a synopsis is a good start, but for submission you need the working package. The complete project includes the full source code with the database file, so you can run it on XAMPP and customise names, rooms and fees for your own college. It also includes a ready project report with the synopsis, system requirements, DFD, ER diagram, table structures and screenshots of every screen, along with a clean PPT for your final presentation and viva. You can get the complete package from the Coding Cush shop. Run it once yourself before demo day, and the viva becomes much easier.

FAQ

Is this project good for BCA and MCA students?

Yes. It is one of the safest choices for BCA, MCA, B.Tech and M.Tech final-year submissions because it is practical, database-focused and easy to demonstrate live in two minutes.

Can two students show different modules of the same project?

Yes, and many project groups do exactly this. One student presents the admin module, such as admission, room allotment and reports, while the other presents the student module, fees and complaints. Just make sure both of you understand the shared database, because the examiner may cross-question.

Which viva questions are asked on this project?

Common questions include: "How do you prevent a bed from being allotted to two students?" — answered by checking occupied beds against total beds before allotment — and "How is the student login kept secure?" — answered with password hashing, sessions and prepared statements.

Can I add online fee payment later?

Yes. You can integrate a payment gateway later and simply update the payment status in the fees table after a successful transaction. The existing receipt system keeps working, so it is a safe future-scope point to mention in your report.

Conclusion

The Hostel Management System is a practical, marks-friendly final-year project: a real problem, clean CRUD modules, a small database and a viva you can prepare for with confidence. Build it, run it on XAMPP, understand your own tables, and you will walk into the demo room relaxed instead of nervous. That confidence, more than any fancy feature, is what examiners reward.