Room Rent Management System Using PHP and MySQL

Project Overview

Room Rent Management System Using PHP and MySQL is a web-based management application designed to simplify the complete process of managing rental properties. The system provides separate Admin and User workspaces for managing buildings, rooms, tenants, reservations, rental periods, payments and additional services.

The application is developed using Core PHP, MySQL, HTML, CSS, JavaScript, AJAX and Bootstrap. It uses a real MySQL database with PHP Sessions for authentication and PDO for database access.

Available Features

• Admin Login and Logout
• Admin Dashboard
• User Registration and Login
• User Management
• Role Management
• Permission Management
• Building Management
• Room Category Management
• Room Management
• Room Availability Tracking
• Tenant Management
• Room Booking and Reservation
• Check-In and Check-Out Management
• Rental Period Management
• Rent Payment Management
• Additional Services
• Reservation Status Management
• Seasonal Rent Management
• Booking History
• Payment Records
• Search and Filtering
• Dashboard Statistics
• Reports and Analytics
• Profile Management
• Responsive Bootstrap Interface

Administrator Workspace

The Administrator has centralized control over the rental operation. Administrators can manage users, roles, permissions, buildings, room categories, rooms, tenants, reservations, additional services, payments, seasonal rental rates and reports.

User Workspace

Registered users can browse available rooms, search and filter rental properties, view room information, select additional services, submit reservations, check booking status, view booking history, review payment information and manage their profile.

Building Management

Administrators can create and manage multiple buildings. Building records can contain information such as building name, address, description and status.

Room Management

Each building can contain multiple rooms. Administrators can manage room numbers, floors, capacity, room categories, rental prices, descriptions and availability status.

Room statuses include Available, Reserved, Occupied and Maintenance.

Room Categories

The system supports customizable room categories such as Single, Double, Deluxe and other rental categories. Each category can contain a description and base rental amount.

Tenant Management

Administrators can maintain tenant information including identity details, address, emergency contact information and associated user accounts.

Room Booking and Reservation

Users can browse available rooms and use search and filtering options to find suitable accommodation. During booking, users can select check-in and check-out dates, rental periods and additional services.

The system calculates the estimated rental amount according to the selected room, rental duration and additional services. The reservation is then stored in the database for administrator processing.

Check-In and Check-Out

Administrators can manage the reservation lifecycle. Confirmed reservations can be marked as checked in when the tenant occupies the room. After the rental period is completed, the reservation can be marked as checked out and the room can become available again.

Additional Services

The application supports additional services that can be selected during room booking. Services can include Wi-Fi, laundry, cleaning and other property-specific services. Each service can have its own price and status.

Seasonal Rent Management

Administrators can define different rental seasons with start dates, end dates and rental multipliers. This allows rental pricing to be adjusted according to different periods.

Payment Management

Administrators can record rental payments against reservations. Supported payment methods include Cash, UPI, Card and Bank Transfer.

Payment records maintain information such as payment amount, payment date, payment method, reference number and payment status.

Reports and Analytics

The reporting section provides reservation statistics based on reservation status and monthly payment revenue. These database-driven reports help administrators monitor the overall rental operation.

Search and Filtering

Users can search available rooms using room numbers, buildings and room categories. Category-based filtering makes it easier to find rooms according to specific requirements.

Profile Management

Users can view and update their profile information, including name and phone number. The registered email remains associated with the account.

Dashboard Statistics

The Admin dashboard provides real database-driven statistics including total users, buildings, rooms, available rooms, reservations, tenants, services and collected revenue.

Technology Stack

• Core PHP
• MySQL
• HTML5
• CSS3
• Bootstrap
• JavaScript
• AJAX
• PHP Sessions
• PDO

Software and Tools Required

• XAMPP
• PHP
• MySQL
• phpMyAdmin
• Visual Studio Code
• Modern Web Browser

More Details and Full Documentation

View Room Rent Management System Using PHP and MySQL Details