COVID-19 Testing Management System Using PHP & MYSQL
You will ask what is the purpose of this project? So it is used to manage patients, testing details online from anywhere, any device.
As the COVID-19 crisis endures and the virus continues to spread globally, the need for collecting epidemiological data and patient information also grows exponentially. The race against the clock to find a cure and a vaccine to the disease means researchers require storage of increasingly large and diverse types of information; for doctors following patients, recording symptoms and reactions to treatments, the need for storage flexibility is only surpassed by the necessity of storage security. The volume, variety, and variability of COVID-19 patient data requires storage in database management systems.
Covid-19 Testing is developed in PHP with MySQL database.
It includes two types of modules.
- Admin module.
- Patients module.
Admin Module:
⮚ Admin is the super-user of the website who can manage everything on the website. Admin can log in through the login page.
● Dashboard: In this section, the admin can see all detail in brief like the total, assigned and the sample collected and completed tests.
● Phlebotomist: In this section, the admin can manage Phlebotomist (add, update, delete).
We can add phlebotomist by adding valid employee id, name and mobile number.
Here we can see that it is added successfully. In manage phlebotomist we can see all added phlebotomist.
● Testing: In this section, the admin can manage all the tests like assign the test to Phlebotomist and update the history.
Also we can view details in view section.
● Report: In this section, the admin can generate two types of report.
- Between dates reports
- By search using order number, name and mobile number
Patients module:
⮚ User can visit the application through a URL.
● Testing: This section divided into two parts. One is for new user and another one is for registered user. New user (First-time user) needs to provide personal and testing Information. A registered user only needs to provide test information, their personal information will be fetched from the database.
In testing, we can see New Test Requests, Assigned, On the way for sample collection, Sample collected, Sent to lab, Report delivered, and All Tests.
● Report: In this section, Users can search their test report using order number, name and registered mobile number.
● Dashboard: In this section, the User can see the in which State of how many tests are done.
Software requirements
Frontend : HTML, AJAX, JQUERY, JAVASCRIPT and PHP
Backend : MySQL.
Assumption & Dependencies
● The functioning of the application relies on MySQL being available on the host machine.
● It is also dependent on a web browser to access the application.
● The product is assumed to be developed for demonstrative purposes and hence internet connectivity is not include.
Advantages
⮚ Remote learning: “It is useful in distant learning and during COVID 19 situation we can continue our education system”.
⮚ Easy administration: “Our teacher has authority to unmute our mics and video. And can see and check whether we are listening attentively or not”.
⮚ Accessibility: “The students who are not much confident, they contact through the WhatsApp easily”.
⮚ Comfortable: “You can easily and comfortably listen to the lecture and learn”. Student-centered Self-directed. “I think eLearning is making good students more active and learning self-learner.”
Limitations
⮚ Unable to teach skills: “In anatomy, the study through models was good. But hands on training is not possible, the student will not be able to understand properly. Skills needs actual hands on training”.
⮚ Lack of student feedback: “I and it annoying that during lectures you don’t have students feedback whether they are getting the point or not”.
⮚ Limited attention span: “There is no continuity of lecture. We lose our concentration and the syllabus is so lengthy.”
⮚ Lack of attentiveness: “As the students know that they will get the recordings, they don’t listen the lecture properly”.
Future Enhancement
In future, we would like to see from the perspective of teaching and pedagogic: how it affects the learning outcome and how teaching and learning activities can be organized to increase learning outcome and reduce the adverse impacts. Future work can also include identifying the learning challenges students face in capstone project compared to other courses such as a theoretical course or a programming course. Besides, challenges from a capstone project can be also compared with projects in industry settings, where small and medium sized groups were forced to collaborate online due to lockdown.
Thank you :)