This is PHP and MySQL Project on Medical Store or Shop Management System and this Pharmacy Management System is a web based PHP Project and it has been developed in PHP Language and MySQL database. With the help of this free pharmacy management system, we can manage medicine location details, medicine company data, medicine supplier data, live medicine inventory data, medicine purchase and sales data and even we can also create medicine sales bill also. The main object for develop Online Medical Store Management System with PHP and MySQL for overcome the manual errors in operate Medical store and convert whole Medical Store day to day work like managing sells, medicine purchase, medicine stock or inventory, medicine billing into computerized system.
This Medical Store Management System is web based application, so multiple user can work on the system at the same time. This is nice project for your education purpose. If you want to learn How to build web application in PHP step by step, then this is best PHP Project in which you can learn lots of things regarding how to build big web application in PHP. In this Medical Shop Management System Project there are many modules like Medicine Category module, Location Rack module, medicine company module, medicine supplier module, medicine purchase module, medicine module and medicine module. By using this project User can easily manage the inventory of their medical store easily and generate medical sales bill also. Their whole medical store data will store in centralized system. So from one location they can easily track the total sales, total purchase data, in stock medicine data and out of stock medicine data in single click.
Technology of User for Build Medical Store Management System
Server Side
PHP
MySQL
DomPDF Library
Client Side
Vanilla JavaScript
Bootstrap 5
Vanilla JavaScript Simple-DataTables
Font Awesome Library
Vanilla SelectBox
Chart.js
Users of Medical Store Management System
Under this Online Pharmacy Billing System, there are main two user.
Admin or Master User
Sub User will be created by Master User
Relational Model Diagram of Medical Store Management System
Modules of Medical Store Management System
This are the main modules of this PHP and MySQL Pharmacy Management System.
Medicine Category Module : Master User can Add, Edit, Read and Delete Medicine Category data under this Category Module.
Medicine Location Rack Module : Master User can Add, Edit, Read and Delete Medicine Location Rack data under this Location Rack Module.
Medicine Company Module : Master User can Add, Edit, Read and Delete Medicine Company data under this Company Module.
Medicine Supplier Module : Master User can Add, Edit, Read and Delete Medicine Supplier data under this Medicine Supplier Module.
Medicine Module : Master User can Add, Edit, Read and Delete Medicine data under this Medicine Module.
Medicine Purchase Module : Master User or Sub User can Add, Edit, Read and Delete Medicine Purchase data under this Medicine Purchase Module.
Medicine Sells Module : Master User or Sub User can Add, Edit, Read and Delete Medicine Sells data and they can also generate Medicine Sells Bill also under this Medicine Sells Module.
System Set Up Module : When first time this system has been run then this set up module will create database connection under this system, then after it will make required Mysql table under define database, next it will create master or admin user account and at the end of set up it will also set up medical store also.
Login Module : With help of this Login module, Master User or Sub User can get access into under Medical Store Management System.
User Module : Master User can Add, Edit, Read and Delete Sub User data under this User Module.
Analytics Module : Master can see analytics data like No. of In Stock Medicine, No. of Out of Stock Medicine, Total value of Sales, Total Values of Purchase, Master user can see last 15 days sales data in graph format. In this Analytics Master user can see last six month Medicine store data in graph format and at the end of page, Master user can see the list of out of Stock Medicine.
Run Medical Store Management System in Local Computer or Laptop
Download XAMPP Server and Install in your Computer.
After Install XAMPP Server, Start Apache and MySQL Server in installed XAMPP Server.
Next you can download source code file from this web page, we have put source code download link at below of this web page.
When you have click on below source code download link, then it will redirect to another page, and on that page you have to enter your email address.
Once you have enter your email address, then source code download link will be send to your email address. If you have not received email in your Inbox, please check your SPAM folder.
Once you have download Medical Store Management System Source code, so you have to extract source code file under xampp/htdocs folder where you have install xampp server.
This Pharmacy Stop Management System Source is password protected, so you can get source code file at this the Video description.
Once you have extract file in xampp/htdocs folder, then after you have to open browser and visit localhost/phpmyadmin. And create new blank database for this Medical Store Management System.
After this in another tab, you have to run http://localhost/msbs/index.php file of this Pharmacy Management System.
When you have hit above URL then it will first you ask Mysql database configuration details and base url details. So when you fill required details, and submit format, then it will make database connection and create required folder in define MySQL database.
After this it will ask you Master user registration details like email address, name and password details, once you have fill all details and submit form then it will create master user account under this Medical Store Management System.
Once Master user account has been created then it will ask for set up medical store details, so in this step you have to define medical store details and once you have fill all details and submit it, it will create medical store under this PHP Pharmacy Management and Billing System.
After follow all above step lastly it will redirect you to login page so here you have to enter master user login details. So follow this step and run this Medical Store Management System.
This is fully dynamic Medical Store Management System which has been build in PHP language with MySQL Database, and here you can get the complete source code of Medical Shop Management System, so you can run this system in your localhost and check the functionality of this system and you can learn how to build any system in PHP.
If you have find any bug under this system, please share under comment box, we will overcome that bug and we will again published error free source code of this Medical Store Management System.
If you have any suggestion or we have to required to add any feature under this Medical Shop Management system, please write your suggestion under this post comment box, we will add you suggestion under this system and we will again published updated source code of Pharmacy Shop and Billing System.
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 system we can also called Online Patient Scheduling or also known as Online Appointment booking system and it has optimized phase of medical services to increase patient healthcare experience in hospitals or in clinics. This system has been build by motivating to see the increasing popularity of online appointment booking system and the main aims of developing this project on online appointment booking system, we have add doctor scheduling model also which has been takes into accounts when patient would like to seen this feature. Now a days it is rational to established the issue that a very less hospitals has provide online appointment booking system. So solve this all problem we have build this Doctor Online Appointment booking system.
This Online Doctor Appointment Booking System in PHP is a easy project developed using PHP script, Mysql database, Ajax and jQuery. Under this project there are three sides. One at Admin side, second is doctor side and third is patient side. Under this Doctor Appointment System Admin can manage whole system data like doctor data, patient data, doctor schedule data and appointment data. At the Doctor side, doctor can schedule their available time details under this system, Doctor can view appointment data. And at patient side, they can view doctor availability data and based on that data they can book appointment under this system.
Modules of Online Doctor Appointment Management System
Following are the main Module of Online Doctor Appointment Management System.
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 Online Doctor Appointment Booking System
Before start using this Online Doctor Appointment Booking System, first you have to create database of this system in you local computer. So for create database of Online Doctor Appointment Booking System you have to create new database in your local phpmyadmin and then after run following sql script. So it will make required table for this Online Doctor Appointment Booking System and you can check source in your local computer.
-- 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 */;
