Building a Comprehensive Human Metapneumovirus (HMPV) Testing Management System with PHP and MySQL: A Step-by-Step Guide

Introduction: The Human Metapneumovirus (HMPV) Testing Management System is a web-based technology that streamlines various diagnostic processes online. This system allows patients to register on the website, provide personal and test information, and book appointments for sample collection. Once the sample is collected, patients can track their test history using their name, order number, and registered mobile number. The system also allows administrators to attach and display copies of test reports for users to download. This article will provide a comprehensive guide on how to set up and run the HMPV Testing Management System using PHP and MySQL.

Project Modules: The HMPV Testing Management System is built using PHP and MySQL database and has two main modules: Admin and User (Patient).

Admin Module: The Admin module is for the super user of the website who can manage everything on the site. The Admin can:

• Log in through the login page
• View the dashboard, which shows the total, assigned, and completed tests
• Manage Phlebotomists (add, update, delete)
• Manage all tests, including assigning tests to Phlebotomists and updating test history
• Generate two types of reports: between dates reports and search-based reports. The Admin can search reports by order number, name, and mobile number.
• Receive notifications for every new test request
• Update their profile, change password, and recover password

User (Patient) Module: The User module is for patients who visit the application through a URL. The User can:

• View their test report using order number, name, and registered mobile number
• See the state of how many tests are done in their dashboard
• Register on the website and provide personal and testing information (first-time users) or just provide test information (registered users)

How to Run the HMPV Testing Management Project Using PHP and MySQL:

1. Download the project zip file from the provided link.
2. Extract the file and copy the hmpv-tms folder.
3. Paste it inside the 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 the name hmpvtmsdb.
6. Import the hmpvtmsdb.sql file (given inside the zip package in the SQL file folder).
7. Run the script by accessing http://localhost/hmpv-tms.

Admin Credential: Username: admin
Password: Test@123

Conclusion: The HMPV Testing Management System is a valuable tool for managing diagnostic processes online. By following the steps outlined in this guide, you can set up and run the system on your local server using PHP and MySQL. This system will not only streamline your diagnostic processes but also provide a user-friendly interface for both administrators and patients.