Online Diagnostic Lab Management System using PHP and MySQL
Project Name : Online Diagnostic Lab Management System Project (ODLMS)
Language Used : PHP
Database : MySQL
User Interface Design : HTML, AJAX,JQUERY,JAVASCRIPT
Web Browser : Mozilla, Google Chrome, IE8, OPERA
Software : XAMPP / Wamp / Mamp/ Lamp (anyone)
In the Online Diagnostic Lab Management System Project, we use PHP and MySQL database. It has three modules i.e.
- Admin
- Lab Employee
- User
Admin
Dashboard: In this section, admin can briefly view the total register users, total new appointment, total approved appointment, total rejected appointment by admin, total cancelled appointment by user, total sample received, total report uploaded and total employee.
Test Detail: In this section, admin can manage test detail(Add/Update).
Lab Employee: In this section, admin can manage employee(Add/Update).
Appointments: In this section, admin can view the booking appointment and admin also has the right to change appointment status according to the current status and his/her remarks.
Lab: In this section, admin received the information of the sample collected by an employee and upload the report a test.
View Reg Users: In this section, admin views the detail registered users.
Search: In this section, admin can search a particular appointment detail by patient appointment number, name and mobile number.
Report: In this section admin can view between dates appointment reports, sales report and employee wise report according to dates.
Admin can also update his profile, change the password and recover the password.
Employee
Dashboard: In this section, an employee can briefly view the total new assign appointment, the total sample collected, the total sample sent to the lab and total appointments.
Test Detail: In this section, an employee can view test detail.
Assign Appointments: In this section, an employee can view the appointment which is assigned by the admin and the employee has the rights to change the appointment status according to current status.
Search: In this section, the employee can search a particular appointment detail by patient appointment number, name and mobile number.
Reports: In this section, an employee can view how many appointments have been assign, how many samples have been collected and how many appointments have been pending in his/her end.
An employee can also update his profile, change the password and recover the password.
Users(Patients)
Dashboard: This is the welcome page for users or patients
Test Detail: In this section, an employee can view test detail.
Appointment: In this section, the user can book the appointments for the test.
Appointment History: In this section, the user can view the appointment history and also can check the status of the appointment.
View Medical Report: In this section, the user can download the patient report.
Users can also update his profile, change the password and recover the password.
Some Project Screenshots
How to run the Online Diagnostic Lab Management System Project (ODLMS)
1.Download the zip file
2.Extract the file and copy odlms folder
3.Paste inside root directory(for xampp xampp/htdocs, for wamp wamp/www, for lamp var/www/html)
4.Open PHPMyAdmin (http://localhost/phpmyadmin)
5.Create a database with name odlmsdb
6.Import odlmsdb.sql file(given inside the zip package in SQL file folder)
7.Run the script http://localhost/odlms
Admin Credential
Username: admin
Password: Test@123
Employee Credential
Username: lab1124
Password: Test@123
User/ pateint Credential
Username: testuser@gmail.com
Password: Test@123
View Demo ————————————————