Doctor Appointment Booking System Project in PHP & MySQL with Source Code
Looking for a fully functional Doctor Appointment Booking System project built using PHP and MySQL?
This is a complete, ready-to-use, easy-to-customize project for hospitals, clinics, and healthcare centers that helps manage doctor appointments online.
This PHP project comes with a secure login system for Admins, Doctors, and Patients, allowing smooth management of appointments, doctors, and specializations.
Whether you’re a student working on a final-year project or a developer seeking a robust appointment booking system, this project is perfect for you!
✅ Project Overview:
The Doctor Appointment Booking System is designed to simplify the process of booking and managing appointments between doctors and patients. The system provides different panels for each user role:
🏥 Admin Panel:
- Login securely as Admin.
- Add, Edit, and Delete Doctor Specializations.
- Add, Edit, and Delete Doctors.
- View All Appointments.
- Edit Appointment Details (Date, Time, Status).
👨⚕️ Doctor Panel:
- Secure Doctor Login.
- View Assigned Patient Appointments.
- Edit Appointment Details (Change Date, Time, Status).
- Easy Appointment Management from Dashboard.
👩⚕️ Patient Panel:
- Patient Registration & Login.
- Book Appointments with Available Doctors.
- View Appointment History.
- Secure Password Encryption with Password Hashing.
📃 Public Pages (Available for Everyone):
- Doctors Page (List of Doctors)
- Services Page (List of Services)
- About Us Page (Information About the Clinic/Hospital)
- Contact Us Page (Contact Details)
✅ Features Included:
- Full Admin Control Panel
- Multi-Role Login System (Admin, Doctor, Patient)
- Doctor Specialization Management
- Appointment Booking & Scheduling
- Doctor Can Manage & Edit Their Appointments
- Session-Based Secure Login System
- Password Hashing using PHP password_hash() and password_verify()
- Simple and Responsive Front-End (Clean UI)
- Public Pages for Information (About, Contact, Doctors, Services)
- MySQL Database Included
- Easy to Customize & Extend
- Clean Code with Comments for Easy Learning
✅ Project Technology Stack:
- Frontend: HTML, CSS (Minimal, Clean Design)
- Backend: Core PHP (No Framework)
- Database: MySQL (phpMyAdmin Compatible)
✅ Included Files:
- Full PHP Source Code
- SQL Database Dump (doctor_appointment.sql)
- CSS & JS Assets (Basic UI)
- Complete Project Folder Structure
✅ Installation Process:
- Download the Project ZIP and extract it.
- Move the extracted folder (e.g., doctor-appointment/) into your web server root directory (htdocs for XAMPP or www for WAMP).
- Import the SQL file:
- Open phpMyAdmin.
- Create a new database named:
CopyEdit
doctor_appointment
- Import the file:
database/doctor_appointment.sql
- Update your database connection settings if needed in:
- Now visit:
arduino
CopyEdit
http://localhost/doctor-appointment/
- ✅ Default Admin Login:
- Username: admin
- Password: admin123
✅ Project Structure Overview:
- /admin/ – Admin Panel (Login, Dashboard, Doctor & Appointment Management)
- /doctor/ – Doctor Panel (Login, Dashboard, Appointments Management)
- /user/ – Patient Panel (Register, Login, Bookings)
- /assets/ – CSS & JS Assets
- /database/doctor_appointment.sql – MySQL Database Dump
✅ Why Use This Project?
- Great for Final Year Projects & Learning PHP CRUD
- Easy to Customize for Real-World Clinic or Hospital
- Simple & Clean Codebase for Quick Learning