- Online medical doctor appointment system undertaking in php Mysql
PHP Online Doctor Appointment Management System has been build by using PHP with Mysql database at server side and at client-side using Ajax jQuery and other jquery plugin. This PHP project you can use for your major PHP project. The main aim for developed Doctor Appointment System is for solve the purpose for disallow the problems, which are not in the current system. This Doctor Appointment System is assume to remove the hardships, which will be available in the current appointment system. But by using electronics equipment like computer and by using this devices we can stored valuable information which we can stored under this appointment system. This Online Doctor Appointment system is show as the fast, error free and secured system with fast management of data. With the help of this Doctor Appointment System which show the good for use of resources and stored records in central location of database.
Online Doctor Appointment System using PHP and Mysql is developed with point of manage the list of data of doctors, patients, appointment bookings, doctor available schedule information etc. This PHP Project on Doctor Appointment System, which is web based or online application which will resolves the problem of booking of Appointment according to the choice and requirement of the patient. Under this system, there is one feature like it is very effective solution which has offered with different available doctor availability on suitable dates and times, so patient can book doctor appointment according to their requirements or choice and patient can also cancel doctor appointment which also available under this system.
This machine we also can known as on-line patient Scheduling or additionally called online Appointment booking gadget and it has optimized segment of clinical offerings to increase affected person healthcare enjoy in hospitals or in clinics. This device has been construct through motivating to peer the increasing recognition of on-line appointment reserving machine and the principle ambitions of developing this mission on on line appointment reserving gadget, we've upload physician scheduling model also which has been takes into money owed while patient would love to visible this selection. Now a days it's far rational to installed the problem that a very less hospitals has offer on-line appointment reserving machine. So clear up this all hassle we've construct this physician online Appointment booking system.
This on line physician Appointment booking device in php is a clean mission advanced the use of Hypertext Preprocessor script, Mysql database, Ajax and jQuery. Below this assignment there are three sides. One at Admin side, 2nd is medical doctor aspect and third is patient facet. Under this medical doctor Appointment device Admin can manipulate entire system data like medical doctor records, affected person facts, medical doctor schedule facts and appointment statistics. On the doctor facet, medical doctor can schedule their to be had time details below this gadget, medical doctor can view appointment statistics. And at affected person facet, they are able to view doctor availability data and based on that facts they are able to ebook appointment beneath this gadget.
Modules of Online Doctor Appointment Management System
Following are the main Module of Online Doctor Appointment Management System.
Appointment Management Module
Doctor Schedule Management Module
Patient Management Module
Doctor Management Module
Login Module
Registration Module
Features of Online Doctor Appointment Management System
This system has three users. Admin, Doctor and Patients. So all feature has been divided between this three users.
Admin or Master Users
Admin can Add Edit Delete and view Doctor data.
Admin can view all patient data.
Admin can Schedule any Doctor Availability data and manage that data like edit or delete it.
Admin can view all doctor appointment data and he or she can also process appointment.
Admin can edit profile detials.
Admin can login into this system.
Admin can see Analytics data.
Doctor Users
Doctor can Add Edit Delete their availablity data under this system.
Doctor can view only his or her appointment data, they cannot see other doctor appointment data.
Doctor can see appointment patients details
Doctor can write comment in patient appointment.
Doctor can edit profile detials.
Doctor can login into this system.
Patients Users
Patient can view Doctor Availability data on web page.
Patient can register into this system.
Patient can login into this system.
Patient can book appointment and they can also cancel appointment.
Patient can download appointment in PDF format also.
Patient can change their profile details also.
Web Technology Used in Online Doctor Appointment Booking System
There are following Web Technology has used for build this Online Doctor Appointment Booking System.
Server-side
PHP
Mysql Database
Client-side
jQuery
Ajax
Bootstrap 4
Parsley.js
jQuery DataTable Plugin
Bootstrap DatePicker Plugin
Database of on-line health practitioner Appointment reserving device
Earlier than start using this on line health practitioner Appointment booking machine, first you need to create database of this machine in you nearby laptop. So for create database of on line doctor Appointment reserving system you have to create new database on your neighborhood phpmyadmin and then after run following sq. Script. So it'll make required table for this on line health practitioner Appointment booking gadget and you could take a look at supply for your local laptop.
-- phpMyAdmin SQL Dump -- version 4.7.4 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Feb 25, 2021 at 05:51 AM -- Server version: 10.1.30-MariaDB -- PHP Version: 5.6.33 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `doctor_appointment` -- -- -------------------------------------------------------- -- -- Table structure for table `admin_table` -- CREATE TABLE `admin_table` ( `admin_id` int(11) NOT NULL, `admin_email_address` varchar(200) COLLATE utf8_unicode_ci NOT NULL, `admin_password` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `admin_name` varchar(200) COLLATE utf8_unicode_ci NOT NULL, `hospital_name` varchar(200) COLLATE utf8_unicode_ci NOT NULL, `hospital_address` mediumtext COLLATE utf8_unicode_ci NOT NULL, `hospital_contact_no` varchar(30) COLLATE utf8_unicode_ci NOT NULL, `hospital_logo` varchar(200) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `admin_table` -- INSERT INTO `admin_table` (`admin_id`, `admin_email_address`, `admin_password`, `admin_name`, `hospital_name`, `hospital_address`, `hospital_contact_no`, `hospital_logo`) VALUES (1, 'johnsmith@gmail.com', 'password', 'John smith', 'Mount Hospital', '115, Last Lane, NYC', '741287410', '../images/15001.png'); -- -------------------------------------------------------- -- -- Table structure for table `appointment_table` -- CREATE TABLE `appointment_table` ( `appointment_id` int(11) NOT NULL, `doctor_id` int(11) NOT NULL, `patient_id` int(11) NOT NULL, `doctor_schedule_id` int(11) NOT NULL, `appointment_number` int(11) NOT NULL, `reason_for_appointment` mediumtext COLLATE utf8_unicode_ci NOT NULL, `appointment_time` time NOT NULL, `status` varchar(30) COLLATE utf8_unicode_ci NOT NULL, `patient_come_into_hospital` enum('No','Yes') COLLATE utf8_unicode_ci NOT NULL, `doctor_comment` mediumtext COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `appointment_table` -- INSERT INTO `appointment_table` (`appointment_id`, `doctor_id`, `patient_id`, `doctor_schedule_id`, `appointment_number`, `reason_for_appointment`, `appointment_time`, `status`, `patient_come_into_hospital`, `doctor_comment`) VALUES (3, 1, 3, 2, 1000, 'Pain in Stomach', '09:00:00', 'Cancel', 'No', ''), (4, 1, 3, 2, 1001, 'Paint in stomach', '09:00:00', 'Booked', 'No', ''), (5, 1, 4, 2, 1002, 'For Delivery', '09:30:00', 'Completed', 'Yes', 'She gave birth to boy baby.'), (6, 5, 3, 7, 1003, 'Fever and cold.', '18:00:00', 'In Process', 'Yes', ''), (7, 6, 5, 13, 1004, 'Pain in Stomach.', '15:30:00', 'Completed', 'Yes', 'Acidity Problem. '); -- -------------------------------------------------------- -- -- Table structure for table `doctor_schedule_table` -- CREATE TABLE `doctor_schedule_table` ( `doctor_schedule_id` int(11) NOT NULL, `doctor_id` int(11) NOT NULL, `doctor_schedule_date` date NOT NULL, `doctor_schedule_day` enum('Sunday','Monday','Tuesday','Wednesday','Thursday','Friday','Saturday') COLLATE utf8_unicode_ci NOT NULL, `doctor_schedule_start_time` varchar(20) COLLATE utf8_unicode_ci NOT NULL, `doctor_schedule_end_time` varchar(20) COLLATE utf8_unicode_ci NOT NULL, `average_consulting_time` int(5) NOT NULL, `doctor_schedule_status` enum('Active','Inactive') COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `doctor_schedule_table` -- INSERT INTO `doctor_schedule_table` (`doctor_schedule_id`, `doctor_id`, `doctor_schedule_date`, `doctor_schedule_day`, `doctor_schedule_start_time`, `doctor_schedule_end_time`, `average_consulting_time`, `doctor_schedule_status`) VALUES (2, 1, '2021-02-19', 'Friday', '09:00', '14:00', 15, 'Active'), (3, 2, '2021-02-19', 'Friday', '09:00', '12:00', 15, 'Active'), (4, 5, '2021-02-19', 'Friday', '10:00', '14:00', 10, 'Active'), (5, 3, '2021-02-19', 'Friday', '13:00', '17:00', 20, 'Active'), (6, 4, '2021-02-19', 'Friday', '15:00', '18:00', 5, 'Active'), (7, 5, '2021-02-22', 'Monday', '18:00', '20:00', 10, 'Active'), (8, 2, '2021-02-24', 'Wednesday', '09:30', '12:30', 10, 'Active'), (9, 5, '2021-02-24', 'Wednesday', '11:00', '15:00', 10, 'Active'), (10, 1, '2021-02-24', 'Wednesday', '12:00', '15:00', 10, 'Active'), (11, 3, '2021-02-24', 'Wednesday', '14:00', '17:00', 15, 'Active'), (12, 4, '2021-02-24', 'Wednesday', '16:00', '20:00', 10, 'Active'), (13, 6, '2021-02-24', 'Wednesday', '15:30', '18:30', 10, 'Active'), (14, 6, '2021-02-25', 'Thursday', '10:00', '13:30', 10, 'Active'); -- -------------------------------------------------------- -- -- Table structure for table `doctor_table` -- CREATE TABLE `doctor_table` ( `doctor_id` int(11) NOT NULL, `doctor_email_address` varchar(200) COLLATE utf8_unicode_ci NOT NULL, `doctor_password` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `doctor_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `doctor_profile_image` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `doctor_phone_no` varchar(30) COLLATE utf8_unicode_ci NOT NULL, `doctor_address` mediumtext COLLATE utf8_unicode_ci NOT NULL, `doctor_date_of_birth` date NOT NULL, `doctor_degree` varchar(200) COLLATE utf8_unicode_ci NOT NULL, `doctor_expert_in` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `doctor_status` enum('Active','Inactive') COLLATE utf8_unicode_ci NOT NULL, `doctor_added_on` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `doctor_table` -- INSERT INTO `doctor_table` (`doctor_id`, `doctor_email_address`, `doctor_password`, `doctor_name`, `doctor_profile_image`, `doctor_phone_no`, `doctor_address`, `doctor_date_of_birth`, `doctor_degree`, `doctor_expert_in`, `doctor_status`, `doctor_added_on`) VALUES (1, 'peterparker@gmail.com', 'password', 'Dr. Peter Parker', '../images/10872.jpg', '7539518520', '102, Sky View, NYC', '1985-10-29', 'MBBS MS', 'Sergen', 'Active', '2021-02-15 17:04:59'), (2, 'adambrodly@gmail.com', 'password', 'Dr. Adam Broudly', '../images/21336.jpg', '753852963', '105, Fort, NYC', '1982-08-10', 'MBBS MD(Cardiac)', 'Cardiologist', 'Active', '2021-02-18 15:00:32'), (3, 'sophia.parker@gmail.com', 'password', 'Dr. Sophia Parker', '../images/13838.jpg', '7417417410', '50, Best street CA', '1989-04-03', 'MBBS', 'Gynacologist', 'Active', '2021-02-18 15:05:02'), (4, 'williampeterson@gmail.com', 'password', 'Dr. William Peterson', '../images/9498.jpg', '8523698520', '32, Green City, NYC', '1984-06-11', 'MBBS MD', 'Nurologist', 'Active', '2021-02-18 15:08:24'), (5, 'emmalarsdattor@gmail.com', 'password', 'Dr. Emma Larsdattor', '../images/1613641523.png', '9635852025', '25, Silver Arch', '1988-03-03', 'MBBS MD', 'General Physian', 'Active', '2021-02-18 15:15:23'), (6, 'manuel.armstrong@gmail.com', 'password', 'Dr. Manuel Armstrong', '../images/1614081376.png', '8523697410', '2378 Fire Access Road Asheboro, NC 27203', '1989-03-01', 'MBBS MD (Medicine)', 'General Physician', 'Active', '2021-02-23 17:26:16'); -- -------------------------------------------------------- -- -- Table structure for table `patient_table` -- CREATE TABLE `patient_table` ( `patient_id` int(11) NOT NULL, `patient_email_address` varchar(200) COLLATE utf8_unicode_ci NOT NULL, `patient_password` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `patient_first_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `patient_last_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `patient_date_of_birth` date NOT NULL, `patient_gender` enum('Male','Female','Other') COLLATE utf8_unicode_ci NOT NULL, `patient_address` mediumtext COLLATE utf8_unicode_ci NOT NULL, `patient_phone_no` varchar(30) COLLATE utf8_unicode_ci NOT NULL, `patient_maritial_status` varchar(30) COLLATE utf8_unicode_ci NOT NULL, `patient_added_on` datetime NOT NULL, `patient_verification_code` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `email_verify` enum('No','Yes') COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `patient_table` -- INSERT INTO `patient_table` (`patient_id`, `patient_email_address`, `patient_password`, `patient_first_name`, `patient_last_name`, `patient_date_of_birth`, `patient_gender`, `patient_address`, `patient_phone_no`, `patient_maritial_status`, `patient_added_on`, `patient_verification_code`, `email_verify`) VALUES (3, 'jacobmartin@gmail.com', 'password', 'Jacob', 'Martin', '2021-02-26', 'Male', 'Green view, 1025, NYC', '85745635210', 'Single', '2021-02-18 16:34:55', 'b1f3f8409f7687072adb1f1b7c22d4b0', 'Yes'), (4, 'oliviabaker@gmail.com', 'password', 'Olivia', 'Baker', '2001-04-05', 'Female', 'Diamond street, 115, NYC', '7539518520', 'Married', '2021-02-19 18:28:23', '8902e16ef62a556a8e271c9930068fea', 'Yes'), (5, 'web-tutorial@programmer.net', 'password', 'Amber', 'Anderson', '1995-07-25', 'Female', '2083 Cameron Road Buffalo, NY 14202', '75394511442', 'Single', '2021-02-23 17:50:06', '1909d59e254ab7e433d92f014d82ba3d', 'Yes'); -- -- Indexes for dumped tables -- -- -- Indexes for table `admin_table` -- ALTER TABLE `admin_table` ADD PRIMARY KEY (`admin_id`); -- -- Indexes for table `appointment_table` -- ALTER TABLE `appointment_table` ADD PRIMARY KEY (`appointment_id`); -- -- Indexes for table `doctor_schedule_table` -- ALTER TABLE `doctor_schedule_table` ADD PRIMARY KEY (`doctor_schedule_id`); -- -- Indexes for table `doctor_table` -- ALTER TABLE `doctor_table` ADD PRIMARY KEY (`doctor_id`); -- -- Indexes for table `patient_table` -- ALTER TABLE `patient_table` ADD PRIMARY KEY (`patient_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `admin_table` -- ALTER TABLE `admin_table` MODIFY `admin_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `appointment_table` -- ALTER TABLE `appointment_table` MODIFY `appointment_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `doctor_schedule_table` -- ALTER TABLE `doctor_schedule_table` MODIFY `doctor_schedule_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- AUTO_INCREMENT for table `doctor_table` -- ALTER TABLE `doctor_table` MODIFY `doctor_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `patient_table` -- ALTER TABLE `patient_table` MODIFY `patient_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
