Cyber Cafe Management System in PHP 8 & MySQL 8 | Full Project with Bootstrap & JS

✔ Key Features

1. Secure Admin Authentication System — The system features a robust login mechanism using PHP sessions with bcrypt password hashing ($2y$10$...), protecting the admin panel from unauthorized access with proper session validation on every protected page.
2. Interactive Admin Dashboard — A real-time dashboard built with Bootstrap 5 displays live KPI cards showing Total Computers, Total Users, and Today's Entries — all fetched dynamically from the MySQL 8 database using PDO prepared statements.
3. Computer Inventory Management — Admins can add, update, and monitor all computers in the cafe. Each computer has a name, IP address, and Active/Inactive status, giving full control over the physical infrastructure of the cafe.
4. User Session & Entry Tracking — Every customer visit is recorded with a unique Entry ID, name, address, mobile number, assigned computer, and check-in time — enabling complete traceability of who used which machine and when.
5. Check-in / Check-out with Automatic Duration Calculation — The system records both entry (in_time) and exit (out_time) timestamps and automatically calculates the total usage duration in minutes for accurate billing purposes.
6. Billing & Printable Receipt Generation — A dedicated receipt.php module generates a professional, print-optimized receipt showing the customer's name, computer used, check-in/out time, session duration, and total charge — with an auto print-trigger on page load.
7. Date-Range Report Generation — The reporting module allows the admin to filter and view all user entries between any two dates using a secure PDO parameterized query, helping track business activity and earnings over any period.
8. Search Functionality — A dedicated search.php module allows the admin to quickly look up specific user records or session entries, improving operational efficiency in high-traffic environments.
9. Fully Offline Asset Architecture — All front-end dependencies including Bootstrap 5 CSS, Bootstrap JS Bundle, and jQuery are hosted locally under the /assets/ folder — ensuring the application runs completely without internet connectivity on a WAMP server environment.

⚙ Installation Guide

1. Download & Extract the Project — Download the project ZIP file and extract it. You will get a folder named Cyber Cafe Management System which contains all the PHP files, assets, and the SQL database file.
2. Install WAMP Server — Download and install WAMP Server (recommended) or XAMPP on your Windows machine. Ensure that PHP 8 and MySQL 8 are selected during setup, as the project is specifically built and tested on these versions.
3. Place Project in Web Root Directory — Copy the entire Cyber Cafe Management System folder into your WAMP web root directory: C:\wamp64\www\ or for XAMPP users: C:\xampp\htdocs\. This makes it accessible via the local web server.
4. Start WAMP Services — Launch WAMP Server and ensure both the Apache and MySQL services are running. The WAMP icon in the system tray should turn green, confirming all services are active before proceeding.
5. Open phpMyAdmin — Open your browser and navigate to http://localhost/phpmyadmin. Log in using your MySQL credentials (default username is root with a blank password on WAMP).
6. Create the Database — Inside phpMyAdmin, click New and create a fresh database named exactly ccms_db. The database name is case-sensitive and must match this name as it is hardcoded in the connection configuration file.
7. Import the SQL File — Select the ccms_db database, go to the Import tab, click Choose File, and select the ccms_db.sql file from the project root folder. Click Go to import — this will create all three tables: admin, computers, and users with sample data.
8. Configure Database Connection — Open the file includes/db_connect.php in a text editor. Verify or update the database credentials — hostname (localhost), database name (ccms_db), username (root), and password — to match your local WAMP/XAMPP MySQL settings.
9. Run the Application in Browser — Open your browser and navigate to: http://localhost/Cyber%20Cafe%20Management%20System/ — this will load the login page (index.php). Use the default admin credentials: Username: admin | Password: admin123 to log in.
10. Change Default Password After Login — Immediately after your first successful login, navigate to Admin Profile → Change Password and update the default password. Alternatively, the Forgot Password feature on the login page can also be used to reset credentials securely via the token-based reset flow.