Online Doctor Appointment Using PHP and MySql

• Admin login and logout in this final year project
• Admin dashboard with doctors, patients, appointments, departments, and recent appointment statistics
• View appointment count by status
• View recent appointments
• Doctor management
• Add doctor profile
• Edit doctor profile
• Delete doctor user
• Activate/deactivate doctor account
• Search and filter doctors
• Manage doctor professional details
• Manage doctor consultation fee in INR
• Manage doctor department
• Manage doctor language, location, room, license, and bio
• Open and manage doctor weekly schedule
• Patient management
• Add patient profile
• Edit patient details
• Block/unblock patient account
• Delete patient record
• Search patients
• View patient details
• Department/category management
• Add department
• Edit department
• Delete department if no doctors are assigned
• Appointment management
• View all appointments
• Search appointments
• Filter appointments by status
• Filter appointments by date
• Filter appointments by doctor
• Filter appointments by department
• View appointment details
• Approve appointment
• Mark appointment as completed
• Cancel appointment with message
• Edit clinical notes
• Reschedule appointment
• Reassign doctor for eligible appointment
• Delete appointment record with confirmation
• Create new appointment on behalf of patient
• Validate doctor slot availability
• Create appointment as pending or approved
• Slot monitor
• View theoretical slots vs booked slots
• Check doctor-wise day schedule
• Link to weekly schedule editor
• Schedule management
• Select any doctor
• Add weekly availability
• Edit weekly availability
• Delete weekly schedule block
• Manage slot duration
• Manage capacity per slot
• Manage optional lunch break
• Admin settings
• Change administrator password with current password validation

• Doctor login and logout in this final year project
• Doctor dashboard with pending appointments, today’s schedule, and quick actions
• Doctor profile management
• Update professional details
• Update consultation fee in INR
• Update department
• Update bio
• Update location
• Update languages
• Update license information
• Update room details
• Change password
• Schedule and slot management
• Add weekly schedule template
• Update weekday availability
• Delete schedule blocks
• Set start time and end time
• Set slot duration
• Set capacity per slot
• Add optional lunch break
• View appointment list
• Open encounter details
• View patient snapshot
• View chief complaint
• Approve appointment request
• Mark appointment as completed
• Cancel appointment with patient-visible message
• Add doctor clinical notes
• View today’s appointment board
• View patients who booked with the doctor
• Open patient record
• View shared appointment history with patient

• Patient registration in this final year project
• Patient login and logout
• Patient dashboard
• Browse doctor directory
• Search doctors
• Filter doctors by department
• View doctor consultation fee in INR
• View doctor profile
• View doctor qualification
• View doctor specialties
• View doctor weekly hours
• View doctor bio
• View doctor location and languages
• Book appointment
• Select doctor
• Select appointment date
• View open time slots using AJAX
• Submit chief complaint
• Appointment remains pending until approved
• View my appointments
• Filter appointments by status
• Filter appointments by date range
• View upcoming and past appointments
• View appointment detail
• View visit information
• View doctor details
• View appointment fee
• View cancellation message
• Reschedule appointment when allowed
• Update appointment date
• Update appointment time
• Update complaint details
• Cancel appointment with reason
• Edit demographic profile
• Update address
• Update emergency contact
• Update blood group
• Update medical notes
• Change password
• Complete online doctor appointment source code
• Suitable for final year project, major project, and minor project
• Project report content can be prepared from included modules
• Public Website, Patient Portal, Doctor Portal, and Admin Portal included
• Slot-based doctor appointment booking
• AJAX slot loading
• Doctor weekly availability templates
• Double-booking prevention for active appointments
• Appointment status flow: Pending → Approved → Completed
• Appointment cancellation with message and cancelled-by tracking
• Doctor clinical notes support
• Admin appointment reschedule/reassign support
• INR consultation fee display
• Role-based access: admin, doctor, patient
• Session-based authentication
• CSRF tokens on forms
• Password hashing using bcrypt
• Inactive users cannot log in
• PDO database connection
• MySQL utf8mb4 support
• Optional PHP intl support for INR formatting
• Demo seed users included
• Optional database migrations included
• Useful for viva, source code review, project report writing, and project demonstration

• Create MySQL database:

  hospital_appointment

• Import schema file:

  sql/schema.sql

• Import seed data:

  sql/seed.sql

• Configure database connection:

  config/database.php

• Set database details:

  DB_HOST = localhost
  DB_NAME = hospital_appointment
  DB_USER = your_mysql_user
  DB_PASS = your_mysql_password

• If project is inside a subfolder, update:

  config/app.php

• Set BASE_URL according to your folder path:

  BASE_URL = '/hospital-app'

• Run using PHP built-in server from project root:

  php -S localhost:8000

• Open:

  http://localhost:8000/

• For XAMPP/WAMP, place project folder inside htdocs or server root and open through localhost

All Seeded Accounts Password:

• Password@123

Administrator

• Email: [email protected]

Doctors

• [email protected] — Cardiology
• [email protected] — General Physician
• [email protected] — Dermatology
• [email protected] — Orthopedics

Patients

• [email protected] — Alex Thompson
• [email protected] — Maria Garcia
• [email protected] — Raj Patel
• [email protected] — Sophie Laurent