Hostel Management System Project in PHP & MySQL

Managing hostel activities manually is a real headache. From room allotment to handling student complaints, everything becomes slow, messy, and error-prone. Thats exactly why I decided to build a complete Hostel Management System using PHP and MySQL a real-world web application that automates hostel operations digitally.

Why Hostel Management System is Needed Today

In most colleges, hostel work is still done using registers and files. Because of this:

• Room allotment takes days
• Student data is hard to track
• Complaints are ignored or lost
• Managers cant monitor everything centrally

What is Hostel Management System (HMS)?

The Hostel Management System (HMS) is a web-based application that helps colleges manage:

• Student registration & login
• Hostel and room allocation
• Hostel managers and admins
• Student complaints & messages
• Vacating rooms and tracking occupancy

Real System Flow (How It Works)

Student  Apply for Hostel  Manager Reviews  Room Allocated
Student  Submit Complaint  Manager Responds  Issue Resolved
Admin  Controls Managers, Students, Hostels

Main Modules in the System

According to the SRS document, the system is divided into 3 core modules:

• Administrator Module
• User (Student) Module
• Application Module

User Roles in Hostel Management System

The system supports three user roles:

Role	Work
Student	Register, Login, Apply for Room, Submit Complaint
Hostel Manager	Allocate Rooms, Manage Complaints, Vacate Rooms
Admin	Appoint Managers, View All Students, Control System

Key Features of Hostel Management System

1. Student Registration & Login

Students can register and login securely using their roll number and password. The system uses session-based authentication.

2. Hostel & Room Allocation System

Students can:

• View available hostels
• Apply for any hostel
• Wait for approval

Hostel managers can:

• View applications received
• Allocate rooms
• Track empty & filled rooms

3. Complaint Management System

This is the most powerful module of this project.

Students can:

• Submit complaints (Fan, Water, Electricity, etc.)
• Set priority (Low, Medium, High, Urgent)
• Track complaint status

Managers/Admin can:

• View all complaints
• Sort by priority
• Update status (Pending In Progress Resolved)
• Reply to students

4. Messaging System

Students and hostel managers can communicate using an internal message system. This feature is documented in the Contact Form & Messages Page section of User Manual

5. Vacate Room System

W hen a student leaves hostel, the manager can vacate the room using a simple form. This process is shown in the User Manual Vacate Room page

System Architecture

The system follows 3-tier architecture:

1. Presentation Layer HTML, CSS, Bootstrap
2. Business Layer PHP logic files
3. Data Layer MySQL Database

Database Design Overview

Main tables:

• student
• hostel
• room
• hostel_manager
• application
• message
• complaints

This relational structure avoids redundancy and keeps data consistent.

Technology Stack Used

Backend

• PHP 8.x
• MySQL
• MySQLi

Frontend

• HTML5
• CSS3
• Bootstrap 4
• JavaScript
• Font Awesome

Tools

• XAMPP
• VS Code
• phpMyAdmin

How to Install Hostel Management System

Step 1: Install XAMPP

Start Apache and MySQL.

Step 2: Create Database

CREATE DATABASE hostel_management_system;

Step 3: Import SQL Files

Import all SQL files from /database folder.

Step 4: Configure Database

Edit includes/config.inc.php

$conn = mysqli_connect("localhost","root","","hostel_management_system");

Step 5: Run Project

http://localhost/Hostel-Management-System/

Project Documentation

Notice: Please note that technical documentation is not included with the base project files. A full reportcomprising DFDs, supplemental diagrams, and an in-depth project overviewcan be provided for an additional fee of 560

Flow Diagram

Learning Benefits from This Project

By building this project, you will learn:

• PHP authentication system
• MySQL relational design
• Role-based access control
• Complaint workflow system
• Real-world dashboard logic

Future Scope

In future, this system can be extended with:

• Online fee payment
• Email/SMS notifications
• Attendance system
• Mobile app
• Admin analytics dashboard

Includes Source Code + SQL File + User Manual