Description:

The PHP and SQL-Based Hotel Management System is a comprehensive and user-friendly solution for managing hotel operations. This system covers key functionalities like room reservations, guest check-ins/check-outs, billing, and staff management. Built with PHP for the backend and SQL for database management, it is ideal for small to medium-sized hotels seeking a digital transformation.

With its modular architecture and responsive interface, this system ensures seamless operations, improves customer satisfaction, and reduces manual workload.

Features:

1. Room Management

   • Add, edit, and categorize rooms (e.g., single, double, deluxe).
   • Real-time room availability status.

2. Reservation System

   • Online and offline reservation functionality.
   • Track booking details, including guest info and duration of stay.

3. Guest Management

   • Maintain guest profiles with detailed information.
   • History tracking for returning guests.

4. Check-In/Check-Out

   • Efficient workflows for guest check-ins and check-outs.
   • Automatic updates to room availability.

5. Billing and Payments

   • Generate invoices with detailed breakdowns.
   • Support for multiple payment methods (cash, card, online).

6. Staff Management

   • Manage staff roles, shifts, and profiles.
   • Role-based access to system features.

7. Reporting and Analytics

   • Generate reports for revenue, occupancy rates, and booking trends.

8. Customizable Settings

   • Configure room pricing, tax rates, and policies.

9. Responsive Design

   • Mobile and desktop-friendly interface for ease of access.

10. Database Backup and Restore

    • Simple tools to back up and restore the database to prevent data loss.

Requirements:

Requirements

• Server: Local server environment (XAMPP, WAMP, or LAMP)
• PHP: Version 7.4 or higher
• MySQL: Version 5.7 or higher
• Browser: Modern web browser
• Dependencies:
  • Bootstrap (for responsive design)
  • jQuery (for dynamic components)
  • FontAwesome (for icons)

Instructions:

1. Set Up the Server

   • Install a local server environment like XAMPP, WAMP, or LAMP.
   • Place the cloned project folder in the htdocs directory (for XAMPP/WAMP).

2. Create the Database

   • Import the provided hotel_management.sql file into your MySQL database:

     bash

     Copy code

     mysql -u username -p database_name < path_to/hotel_management.sql

3. Configure the Application

   • Open the config.php file in the project directory.
   • Update the database credentials to match your local server:

     php

     Copy code

     define('DB_HOST', 'localhost'); define('DB_USER', 'your_db_username'); define('DB_PASS', 'your_db_password'); define('DB_NAME', 'hotel_management');

4. Run the Application

   • Start your local server and access the application in your browser:

     perl

     Copy code

     http://localhost/hotel-management-system

5. Admin Access

   • Use the default admin credentials to log in:
     • Username: admin
     • Password: admin123
   • Change these credentials after the first login for security.