PHP 8 MySQL Project on Online Doctor Appointment Booking System

Summary

This video tutorial showcases a comprehensive online doctor appointment booking system developed in PHP, utilizing MySQL, Ajax, jQuery, and Bootstrap. It features a robust backend with five tables catering to admin, doctors, patients, schedules, and appointments. The system allows patients to book appointments from home, with functionalities for admin to manage users and appointments, doctors to set schedules and view patient details, and patients to register, book, and cancel appointments. The video provides a detailed walkthrough of the system's functionality and includes a live demo and source code.

Takeaways

• 😀 The video introduces a new PHP project: an online doctor appointment booking system.
• 💻 The system is built using PHP, MySQL, Ajax, jQuery, and other web technologies.
• 🔗 The video provides a source code link and an online demo link in the description for viewers to explore.
• 📊 The system features appointment analytics for admins, including total appointments and registered patients.
• 👨‍⚕️ There are three types of users in the system: admin, doctor, and patient, each with different access levels and functionalities.
• 👤 Admin users can manage doctor profiles, including adding, viewing, editing, and deleting doctor details.
• 🗓️ Doctors can schedule their availability and manage their appointment calendar within the system.
• 📝 Patients can book appointments online, view their appointment history, and download appointment details in PDF format.
• 🛠️ The system allows for appointment status updates, such as marking an appointment as 'in process' or 'completed'.
• ✅ The video concludes with a call for feedback and suggestions to improve the system.

Q & A

What is the main feature of the online doctor appointment booking system discussed in the video?

The main feature of the system is that patients can book doctor appointments online from their home or office without having to visit the hospital.

What technologies were used to build the online doctor appointment booking system?

The system was built using PHP script, MySQL database, Ajax, jQuery, jQuery DataTable plugin, Bootstrap Datepicker library, and Parsley JavaScript library.

What are the different user roles in the doctor appointment booking system?

There are three user roles in the system: admin, doctor, and patient.

How can an admin user add new doctor data to the system?

An admin user can add new doctor data by clicking on the plus button, filling out the doctor details form in the popup model, and then clicking on the ADD button.

What actions can an admin perform on doctor accounts?

An admin can view, add, edit, and delete doctor details. They can also change the doctor's account status to active or inactive.

How does a doctor schedule their availability in the system?

A doctor can schedule their availability by clicking on the plus button, filling in the scheduling details such as date, start time, end time, and average consulting time, and then clicking on the ADD button.

How can a patient book an appointment using the system?

A patient can book an appointment by selecting a doctor's available time slot, clicking on the book appointment button, logging in or registering if necessary, and then filling out the appointment details including the reason for the appointment.

What can patients do after booking an appointment?

After booking an appointment, patients can view their appointment details, download a PDF of the appointment details, and cancel the appointment if needed.

How can the admin manage patient appointments?

The admin can view all doctor appointments on a single page, filter appointments by date range, and update the appointment status to indicate that the patient has arrived for their check-up.

What is the process for a doctor to complete a patient's appointment in the system?

After checking up on a patient, the doctor can enter comments regarding the patient's health checkup, save the comment, and change the appointment status to completed.

Outlines

00:00

💻 Introduction to the Online Doctor Appointment Booking System

This paragraph introduces a PHP project on an online doctor appointment booking system. The project is built using PHP, MySQL database, Ajax, jQuery, and other web technologies. The video aims to demonstrate the complete functionality of the system and invites viewers to provide suggestions for improvement. The system allows patients to book appointments online without visiting the hospital, showcasing a robust solution for managing doctor appointments. The video also mentions the availability of the source code and an online demo for further exploration.

05:02

👨‍⚕️ Doctor Management Features in the Appointment System

This section details the doctor management capabilities within the system. Admin users can add, view, edit, and delete doctor details using a form that pops up in a modal. The system also allows for the activation and deactivation of doctor accounts, which affects the doctor's ability to log in. The paragraph walks through the process of managing doctor profiles, including adding new doctors, viewing complete details, and scheduling availability. It also highlights the role of the doctor in the system, such as changing their profile details and managing their availability for appointments.

10:02

📅 Scheduling and Booking Appointments

This paragraph explains how doctors can schedule their availability within the system. Doctors can add, edit, or delete their availability dates and times through a modal form. The admin can also manage doctor schedules, including adding new schedules and selecting doctors from a list. The paragraph then shifts to the patient's perspective, showing how they can view available doctor schedules and book appointments online. It describes the process of logging in as a patient, selecting a doctor, and filling out the appointment form, including specifying the reason for the appointment.

15:04

📝 Appointment Management and Patient Interaction

This section discusses how appointments are managed and processed within the system. It covers the patient's ability to view, download, and cancel their appointments in PDF format. The paragraph also explains how admin users can view and manage patient details and appointments, including filtering appointments by date range. It describes the process of marking an appointment as 'in process' when a patient arrives at the hospital and how doctors can update appointment statuses and add comments after a consultation. The system ensures that appointment data is accessible to all users, including admin, doctors, and patients.

20:06

📱 Patient Dashboard and System Demonstration

The final paragraph focuses on the patient dashboard, where patients can view their appointment history and status. It mentions the ability to download appointment details in PDF format, which includes the doctor's comments. The paragraph concludes with an invitation for viewers to understand the system better through an online demo and to provide feedback or suggestions in the comments section. It also reminds viewers of the availability of the source code and the demo link in the video description.

Keywords

💡PHP

PHP is a server-side scripting language designed for web development. In the context of the video, it is used to build the backend of the online doctor appointment booking system, handling server-side logic, database interactions, and generating dynamic web content. The script mentions that the project is built 'in PHP script with MySQL database,' indicating PHP's role in creating the system's functionality.

💡MySQL

MySQL is an open-source relational database management system (RDBMS) that is widely used for storing and managing data for web applications. The video script refers to a 'MySQL database' as the data storage solution for the doctor appointment system, where information about doctors, patients, appointments, and schedules is managed.

💡Ajax

Ajax stands for Asynchronous JavaScript and XML. It is a set of web development techniques that allows for creating interactive web applications by exchanging small amounts of data with the server without reloading the whole page. The script mentions Ajax as one of the technologies used to enhance user experience by enabling features like real-time data updates without page refreshes.

💡jQuery

jQuery is a fast, small, and feature-rich JavaScript library. It simplifies HTML document traversing, event handling, and AJAX interactions. In the video, jQuery is used on the client side to facilitate interactions with the PHP backend, such as handling form submissions and dynamic content updates in the doctor appointment booking system.

💡Bootstrap

Bootstrap is a popular front-end framework for developing responsive and mobile-first websites. It includes a grid system, prebuilt components, and JavaScript plugins. The video script mentions Bootstrap in the context of the user interface design for the doctor appointment system, likely for creating a responsive layout that works on various devices.

💡Datepicker

A Datepicker is a user interface component that allows users to select dates from a calendar-style interface. The script refers to the 'bootstrap datepicker library' as a feature of the system that enables patients to easily select dates for their appointments, streamlining the booking process.

💡Doctor Scheduling

Doctor Scheduling refers to the process of managing and allocating time slots for doctors to see patients. In the video, the system allows doctors to set their availability, which is a crucial feature of the appointment booking system, enabling patients to book appointments during the times when doctors are available.

💡Appointment Booking

Appointment Booking is the process of reserving a time slot with a service provider, in this case, a doctor. The video's main theme revolves around an 'online doctor appointment booking system,' which allows patients to book appointments with doctors from their homes or offices, showcasing the system's core functionality.

💡User Roles

User Roles define the different types of users within a system and their respective permissions. The script describes three user roles: admin, doctor, and patient, each with different access levels and functionalities within the system, such as managing doctors' profiles, scheduling availability, and booking appointments.

💡CRUD Operations

CRUD stands for Create, Read, Update, and Delete, which are the basic functions of persistent storage. The video script mentions CRUD operations in the context of managing doctor and patient data, as well as appointments, where admin and doctors can add, view, edit, or delete records as part of the system's administrative functions.

💡PDF Format

PDF stands for Portable Document Format, a file format used to present documents in a manner independent of application software, hardware, and operating systems. The script refers to the ability for patients to download their appointment details in 'PDF format,' which serves as a printable record for their hospital visits.

Highlights

Introduction to a new PHP project: an online doctor appointment booking system.

The system is built using PHP, MySQL, Ajax, jQuery, and other web technologies.

Source code and database file are available for the project.

Online demo of the system is provided for testing and evaluation.

The system allows patients to book appointments without visiting the hospital.

Overview of the technologies used: PHP, MySQL, Ajax, jQuery, DataTables, Bootstrap Datepicker, and Parsley.

Database structure explained, featuring tables for admin, doctors, patients, schedules, and appointments.

Demonstration of the admin user login and dashboard with appointment analytics.

Admin can manage doctor profiles, including adding, viewing, editing, and deleting doctor data.

Doctors can log in, view, and manage their schedules and availability.

Patients can register, log in, and book appointments through the system.

Appointments can be viewed, edited, and cancelled by both patients and doctors.

Admin has access to manage all patient and doctor appointment data.

Appointments can be marked as 'in process' and 'completed' to track patient visits.

Doctors can provide comments on patient health checkups, which are only editable by the doctor.

Patients can view their appointment history and details, including doctor comments, on their dashboard.

Call to action for viewers to provide suggestions for system improvement in the comments section.

Transcripts

Hello friends this is webs lesson

programming YouTube

channel and here we will show you our

new PHP project on an online doctor

appointment booking

system which we have built in PHP script

with my SQL database and Ajax

jQuery in this video we will show you

complete functionality of the doctor

appointment booking

system and we have requested you to give

us some suggestions regarding this

system so we have improved this system

and made a robust doctor appointment

booking system in

PHP here you can find the complete

source code of this project with a

database file also and here you can also

check online demo of this online do

appointment booking

system and you can also find source code

link an online demo link under this

video

description in the current Digital World

all types of work is mostly done

online so some subscribers have

requested us to publish any projects on

an online doctor appointment booking

system so here we have published this

project so you can learn how we can make

doctor appointment Management Systems in

PHP from scratch the main feature of of

this system is that patient does not

come into the hospital or does not want

to be called in the

hospital but a patient from their home

or office they can book doctor

appointments online by using this online

doctor appointment booking

system now we have show you which web

technology we have used for build this

online doctor appointment booking system

so here you can see that we have used

PHP script mySQL database at server

side and at client side we have used

Ajax jQuery jQuery data table plug-in

bootstrap dat picker library and parley

JavaScript library same way here you can

see the database structure of this

doctor appointment booking system so

here we can see five

tables here in the admin table it will

store admin details and Hospital

details in the doctor table we will

store the doctor data with Doctor other

profile

details in the patient table we will

store patients details with other

profile

details in the doctor schedule table we

will store doctor available time

details and lastly all appointment data

we will store under this appointment

table

so these are the databased structure of

this online doctor appointment booking

system now we show you the functionality

of this doctor appointment booking

system so in this system there are three

users one is admin user second is dror

user and third is patient

user so first we want to log in as admin

user so here we can see admin user login

page so here we have enter admin user

details once we have entered admin data

now we have clicked on the

button and after clicking on the button

here the page has been redirected to

this dashboard page and on this page we

can see appointment analytics data

like total today appointment yesterday

total appointment last 7day total

appointment total appointment till date

and total register patient

data after this here at the right side

we can see the user icon with

username so we have clicked on the user

icon so here we can see one drop- down

menu has displayed on the web page with

two links like profile and log

out so suppose admin users want to

change profile

details so here we have clicked on

profile link and here the page has been

redirected to profile web

page and here admin users can change

their profile details and Hospital

details so all this details admin can

change by clicking on this edit

button next on the left side we can see

different menus like dashboard doctor

patient doctor schedule appointment and

profile now we have clicked on Dr Link

so after clicking on Dr

Link here page has been redirected to

this doctor management page so admin

user can manage all doctor data suppose

admin users want to add new doctor

data so here we have to click on this

plus button so after click on plus

button here we can see that model has

been pop up in the browser with ad

doctor details

form so here admin can fill all doctor

details one by one also

once admin has filled all details so now

we have click on ADD

button so after click on ADD button here

we can see success message on web page

and in below we can also check that

newly added doctor details has been

displayed with view edit and delete

button so this way admin users can

create new doctor accounts under this

doctor appointment management system and

this doctor can able to login under this

system suppose admin users want to view

complete doctor

details so we have to click on this view

button so by click on this button admin

users can view complete doctor details

so here we can see that modal dialogue

box has been pop up on web page and

under this system and we can view

complete doctor

details same way suppose admin user want

to edit existing doctor

details so we have to click on this edit

button and after click on this edit

button here we can see that bootstrap

model has pop up in browser and under

this we can C edit form with filled

doctor details so from this model admin

can edit existing doctor

details next suppose we want to delete

particular doctor details so by clicking

on this delete button admin users can

remove particular doctor data from this

system here in the doctor module we have

also added active or inactive features

also currently here we can see this

doctor status is active that means this

doctor is able to login into the

system so now we have clicked on this

active button so it asks do you want to

inactive this doctor

account so we have clicked on the okay

button so after clicking on the okay

button here on the web page we can see a

success message like this doctor account

has been successfully

inactive now another browser we have

logined with that inactive doctor

account so here we have entered login

details after this we have clicked on

this login button so after clicking on

the login

button here we can see that your account

is inactive contact admin for active

again so we have again go to admin area

and we want to again active this

account so we have simply click on this

inactive button button and it has again

asked do you want to active this doctor

account so we have click on okay button

and after click on okay button and this

doctor account has been active again now

we have gone to the doctor area and

again click on the login button and

after clicking on the login button and

here web page has been redirected to Dr

schedule

page under this doctor appointment

booking system doctors can also change

their profile details by going into this

profile

link after this under this system

doctors can schedule their availability

from this page suppose doctors want to

add availability for a particular date

so for this we have to click on this

plus

button after clicking on the add button

here we can see that model has popped up

in the

browser and here doctor can fill their

scheduling details like schedule date

start time end time and average

Consulting

time so by filling these details doctors

can schedule their availability under

this

system so here we have filled all these

details now we have click on ADD

button so after click on ADD button here

we can see that doctor availability data

has been stored under this

system here doctor can also edit this

schedule data also by clicking on this

edit

button and doctor can also remove their

doctor schedule data by click on this

delete button

also now we have again go to admin side

and here also we can see Dr schedule

link

also so here we have click on this link

so after click on this link the web page

has been redirect to Dr availability

management page

here admin can see that all doctor

schedule data and here also admin can

add doctor schedule

data so for add doctor schedule data

here we have to click on this add

button and after clicking on the ad

button here we can see that bootstrap

model has popped up in the browser and

under this we can fill form for schedule

doctor availability data but here we can

see one more

field here admin has to select

particular doctor name from a list of

doctors and then after admin can enter

other data under this

form once all data has been filled then

after we have to click on this add

button and after click on ADD button

here doctor availability data has been

stored under this system by

admin and newly added data which we can

see on the web page with the edit and

delete

button so under this system admin can

also edit or delete dror schedule data

also now in your mind one question will

arise where will this doctor schedule

data will be

displayed so this data will be displayed

to the patient so the patient can book

an appointment for a particular

doctor so we have gone to the front part

of this doctor appointment system and

here this web page has been opened for

the

public and here we can see different

doctor availability dates and time with

a book appointment button

also now we want to book an appointment

so we have to click on this row

appointment

button so after click on appointment

button so system has been redirected us

to login page so if you have already

account of this

system then you can directly login into

system and suppose you are not register

under this system so by click on this

link you can register into this

system so here we can see patient

register form so here patient can fill

their detail one by one and register

under this system

now we have login under this online

doctor appointment booking system as a

patient and here web page has been

redirected to do schedule list again and

here we can see available do schedule

data with appointment

button so now we want to get an

appointment for this doctor so we have

to click on the get appointment

button and after clicking on the get

appointment button here we can see that

the model has has pop up in the

browser and under this model we can see

two sections in one section we can see

patient details and in other sections we

can see appointment

details now for get appointment here we

have to Define reason for appointment

like which problem you have to

face after defined reason for

appointment now we have to click on book

button

once we have click on book button so

here our appointment has been booked and

here we can see that our appointment

details has been display in my

appointment list

page here we can see our last

appointment details like appointment

number Doctor name appointment date time

and Daye

details here we can also see appointment

status which has been display booked

that means our appointment is confirmed

after this we can also see the PDF

button also so we have click on this

button and here we can see that our

complete appointment details in PDF

format so we can download this file and

take print and go to hospital with that

print which is proof of

appointment and lastly we can also

cancel our appointment so here by

clicking on this cancel button we can

cancel our appointment M

also now again we have to go to the

admin account and here we have to go to

the patient

module after click on patient link here

system has redirect us to patient

management

page and here we can see complete

register patient details on single page

this page is only viewable to admin and

Doctor cannot see all patient

details in this module admin can view

complete complete single patient details

by click on this view

button so patient details will be load

in the popup model and here admin can

also edit and delete patient details

also now we have go to doctor account

and here we have to click on appointment

link so after click on appointment link

here system has been redirect us to

appointment management

page and on this page

the doctor can see patient details who

has book appointments for this

doctor so here the doctor can see

appointment number patient name

appointment date details appointment

time appointment day appointment status

details here doctor can view complete

appointment details by clicking on this

view button so once doctor has clicked

on view

button then model will be pop up and

doctor can view complete appointment

details with reason why patient has book

appointment now again we have to go to

the admin part and go to the appointment

page where admin can also access the

appointment page and admin can view all

doctor appointments on a single

page here admin can filter appointment

data by using date range

filter so suppose admin wants to know

total Appo appointment of today so admin

can simply select date from both select

boxes and after this admin has to click

on this search button so after clicking

on search

button admin can able to filter

appointment data and can view total

appointment for particular

date and by click on this button admin

can reload all appointment data

also now we have show you how

appointments have been processed

so suppose a patient has come in

hospital and then the admin can ask the

patient for appointment

details so when a patient has told his

or her appointment number then admin has

filter data and view appointment

details here in modo admin has to select

yes that means the patient has come in

hospital for check

up and once admin has clicked on the

save button then that appoint M status

has been changed to in process same way

after going to doctor's side and here

doctor can see all appointment status

and doctor can also able to see this

appointment status has been changed to

in

process that means particular patient

has already seat outside his or her

cabin so now doctor can able to tell

that patient for come in his or her

cabin and once doctor has completely

check up patient

then after doctor can also able to enter

comment regarding patient Health

checkup and once a doctor has clicked on

the save button then that comment will

be saved and appointment status will be

changed to

completed so this is whole cycle of

appointment once a doctor has saved a

comment then only the doctor can only

edit that comment and admin cannot edit

that

comment so this appointment data will be

available to all three users like admin

doctor and patient

also patients also can see complete

appointment details into their dashboard

also so here again we have come to the

patient dashboard and here we have gone

to my appointment link so the patient

can see their history of appointment

with appointment status also

and to see complete appointment details

so the patient has to click on this PDF

button and in PDF format the patient can

view their complete appointment details

with dror comment

also so this is complete demo of this

online doctor appointment booking system

which has been developed in PHP

languages if you have not understand

complete system under this video then

you can also check online demo also so

by check online demo you can also

understand the flow of this system step

by step and we have already put online

demo link under this video description

and under demo you can find the source

code download

link lastly if you have some suggestion

regarding this system then you can write

your suggestion in the comment box and

thank you for watching this video