Online Multi Doctor Appointment System With Php And Mysql

Building a complete multi doctor online appointment website using the PHP, PDO & MySQL from scartch.

What you'll learn

Complete project using php, pdo and mysql

Full admin panel authentication system from scratch

Sending email using phpmailer

Complete CRUD system

PHP session

Patient registration, login, reset password (full authentication)

Doctor login, reset password (full authentication)

Connecting database with php, pdo

Form validation technique

Photo uploading system

Toast message notification

Ajax based appointment selection by patient (during appointment)

Date slot creation by admin

Patient payment system for online appointment

PayPal and Stripe Integration

Doctor consulting patient and adding symptom

Doctor diagnosis the patient and giving advice

Prescription making by doctor and schedule next appointment date

Managing departmentwise doctors

Requirements

Basic knowledge in HTML

Basic knowledge in CSS

Basic knowledge in Javascript and Jquery

Basic knowledge in Bootstrap

Basic knowledge in Code Editor like VS Code or any other

Description

In this course, I am going to teach students how to build a complete Online Multi-Doctor Appointment System from scratch using PHP and MySQL. The course will cover all the core aspects of web application development, including authentication systems, email verification, role management, and template mastering.We will develop a real-world doctor appointment platform where multiple doctors can manage their schedules, patients can book appointments, and admins can monitor the entire system. This project will be built using the latest version of PHP at the time of recording, ensuring students learn modern and up-to-date practices.This course is designed especially for beginners who have little or no experience with PHP, but even advanced learners will find it useful as we implement real-life features like doctor availability, appointment booking, patient management, and advanced reporting that are commonly required in real medical systems.Admin Panel Features:1. Admin can create, edit and delete doctors.2. Admin can create, edit and delete patients.3. Admin can change logo, favicon etc. 4. Admin can manage home page data.5. Admin can manage medicines.7. Admin can manage terms and privacy pages.8.  Admin can manage departments.9. Admin can see date and time schedules added by doctors.10. Admin can see appointments done by patient.11. Admin can view and delete subscribers.12. Admin can export subscriber list as CSV.13. Admin can change his own photo, information and password. 14. Admin can see important dashboard data including his commission and earning.15. Admin can approve or cancel the withdraw request comes from doctor.Doctor Features1. Doctor can login in this system after his account is created by admin.2. Doctor can reset profile information if needed.3. Doctor can reset password.4. Doctor can change his or her own photo, and signature.5. Doctor can setup datewise time schedules and maximum capacity.6. Doctor can run consultation and fill up data for patients.7. Doctor can select multiple medicines during consultation.8. Doctor can see total earnings and available balance.9. Doctor can add withdraw request.Patient Features1. Patient can create account in this system for free.2. Patient can reset password if needed.3. Patient can change his or her own photo, and profile information.4. Patient can pay using paypal, stripe and create appointment to any doctor.5. Patient can see prescription and download or print that prescription.

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Local Server Setup & Preparing Environment

Lecture 2 Installing XAMPP (Windows OS)

Lecture 3 Shift between php versions in XAMPP (Windows OS)

Lecture 4 Installing Laragon (Windows OS)

Lecture 5 Shift between php versions in Laragon (Windows OS)

Lecture 6 Install PHP 8.2 in Laragon (Windows OS)

Lecture 7 Installing XAMPP (MAC OS)

Lecture 8 Installing MAMP (MAC OS)

Lecture 9 Shift between php versions in MAMP (MAC OS)

Lecture 10 Download & Install Composer (Windows OS)

Lecture 11 Download & Install Composer (MAC OS)

Lecture 12 Code Editors

Section 3: Admin Panel Template Mastering

Lecture 13 Describing HTML Template

Lecture 14 Separate Dashboard and Login

Lecture 15 Moving all data into admin folder

Lecture 16 Config File and Mailtrap Setup

Lecture 17 Creating Users Table and Developing Login & Logout System

Lecture 18 Forget Password

Lecture 19 Reset Password

Lecture 20 Edit Profile - Part 1

Lecture 21 Edit Profile - Part 2

Lecture 22 Other Pages

Section 4: Front End Template Mastering

Lecture 23 HTML Template

Lecture 24 Project Folder Setup

Lecture 25 Changing all html extensions to php

Lecture 26 Creating header and footer php files and link to all pages

Section 5: Patient Panel - Full Authentication using Multi Table

Lecture 27 Patient Registration - Part 1

Lecture 28 Patient Registration - Part 2

Lecture 29 Patient Registration Verify

Lecture 30 Patient Login, Dashboard and Logout

Lecture 31 Patient Edit Profile - Part 1

Lecture 32 Patient Edit Profile - Part 2

Lecture 33 Patient Forget & Reset Password

Lecture 34 Removed CDN and used local files for linking

Lecture 35 Apply Toastr For Success and Error Message

Section 6: Admin Panel - Departments

Lecture 36 View Departments

Lecture 37 Create Department

Lecture 38 Edit and Delete Departments

Section 7: Doctor Panel - Full Authentication using Multi Table

Lecture 39 Create and View Doctor by Admin

Lecture 40 Edit and Delete Doctor by Admin

Lecture 41 Adding Sample Doctor Data

Lecture 42 Doctor Login, Dashboard and Logout

Lecture 43 Doctor Edit Profile

Lecture 44 Doctor Forget and Reset Password

Section 8: Admin Panel - Photo Gallery for Department

Lecture 45 Create, View and Delete Photos

Lecture 46 Adding Department Photos as Sample Data

Section 9: Front End - Departments and Single Department Page

Lecture 47 Departments Page and Pagination

Lecture 48 Show Data in Single Department Page

Section 10: Admin Panel - Manage Patients

Lecture 49 View Patients

Lecture 50 Create Patient

Lecture 51 Edit and Delete Patient

Section 11: Admin Panel - Doctor Fee

Lecture 52 Setup Fee for Each Doctor

Section 12: Doctor - Setup Schedule

Lecture 53 Create and View Schedule

Lecture 54 Edit and Delete Schedule

Section 13: Patient - Book Appointment

Lecture 55 Chained Select using Jquery and Ajax - Departmentwise Doctors

Lecture 56 Chained Select using Jquery and Ajax - Doctorwise Schedule Dates

Lecture 57 Chained Select using Jquery and Ajax - Datewise Time Schedules

Lecture 58 Creating Table and Checking Validation

Lecture 59 PayPal Developer & Sandbox Accounts and Getting API Keys

Lecture 60 Pay with PayPal and Confirm Booking

Lecture 61 Pay with Stripe and Confirm Booking

Section 14: Patient - View Appointment

Lecture 62 View Appointment

Section 15: Admin Panel - Medicine

Lecture 63 Add and View Medicine

Lecture 64 Edit and Delete Medicine

Section 16: Doctor - Preparing Prescription

Lecture 65 Show All Appointments

Lecture 66 Treatment Process and Create Prescription - Part 1

Lecture 67 Treatment Process and Create Prescription - Part 2

Lecture 68 Treatment Process and Update Prescription

Lecture 69 Working with Medicine - Part 1

Lecture 70 Working with Medicine - Part 2

Section 17: Patient - Treatment and Medicine

Lecture 71 View Treatment and Medicine with Print Option - Part 1

Lecture 72 View Treatment and Medicine with Print Option - Part 2

Lecture 73 Setup Doctor Signature and Add in Prescription

Section 18: Admin Panel - Appointment, Prescription and Schedule

Lecture 74 View Appointment and Prescription

Lecture 75 View Schedule

Section 19: Front End - Showing All Doctors and Doctor Detail Page

Lecture 76 All Doctors in Home Page and Doctor Detail Page

Lecture 77 Show Schedules on Doctor Detail Page

Lecture 78 Doctors Page and Search Option

Section 20: Doctor - Withdraw Money

Lecture 79 Withdraw Request by Doctors

Lecture 80 Withdraw Approval or Cancellation by Admin

Lecture 81 Admin Commission in Percentage

Section 21: Subscriber

Lecture 82 Send Email and Verify

Lecture 83 Show All Subscribers and Download Data as CSV

Section 22: Pages

Lecture 84 Contact Page - Send Email

Lecture 85 Contact Page - Map and Contact Information

Lecture 86 Terms and Privacy Page

Section 23: Settings

Lecture 87 Change Footer Information

Lecture 88 Change Logo and Favicon

Section 24: Dashboard

Lecture 89 Admin Dashboard

Lecture 90 Doctor Dashboard

Lecture 91 Patient Dashboard

Section 25: Source Code

Lecture 92 Source Code

Persons who want to learn php from scratch,Persons who want to learn mysql from scratch,Persons who are looking for a good job in web development sector,Persons who want to have a remote job in php,Persons who want to start his freelancing career using php,Persons who want to learn making an online doctor appointment website using PHP, PDO, MySQL