Authors : Okafor Anthony Chibuzor; Ugah John O.; Ugboaja S. G.; Igwe Sylvester Agbo; Amadi, Kelvin Emmanuel

Volume/Issue : Volume 11 - 2026, Issue 10 - October

Google Scholar : https://tinyurl.com/5zet6a4z

DOI : https://doi.org/10.38124/ijisrt/26Oct1160

Note : A published paper may take 4-5 working days from the publication date to appear in PlumX Metrics, Semantic Scholar, and ResearchGate.

Abstract : Efficient management of medical records is fundamental to the delivery of high-quality healthcare services. However, many healthcare institutions, particularly in developing countries, continue to rely on fragmented and paperbased record systems, which are characterized by inefficiency, data redundancy, limited accessibility, and poor communication channels. The aim of the study was to design and implementation of an integrated medical record management system enhanced with Short Message Service (SMS) and email notification functionalities. The proposed system adopted a centralized database architecture that ensured a secured storage and efficient management of patients’ information. The system was developed using Python for backend logic, PHP for server-side scripting, MySQL as the relational database management system, and RESTful APIs for integrating SMS and email services. The development process followed a structured methodology, including system analysis, design, implementation, and testing phases. Emphasis was placed on data integrity, system scalability, and security through authentication and role-based access control mechanisms. To evaluate system performance, key metrics such as response time, data retrieval speed, system usability, and notification delivery success rate were assessed. The system achieved an average response time of less than 2 seconds, a data retrieval accuracy rate of 98%, and a notification delivery success rate of 95%. Usability testing, conducted with healthcare staff, indicated a high level of user satisfaction and ease of use. Findings from the study demonstrate that the developed system significantly reduces data processing time, minimizes errors associated with manual record-keeping, and enhances patient engagement through automated communication. The integration of SMS and email notifications proved effective in reducing missed appointments and improving adherence to medical schedules. This study contributed to the advancement of digital healthcare systems by demonstrating the effectiveness of integrating modern web technologies and communication APIs into medical record management. It is therefore recommended that healthcare institutions adopt such systems to improve operational efficiency, good data management practices, and overall quality of healthcare delivery.

Keywords : MYSQL, RESTful, SMS, APIs, PHP, Server, Html.

References :

1. Adeyeye, A. J., Adebisi, Y. A., and Oke, G. I. (2024). Awareness and adoption of electronic medical   records among healthcare professionals in developing countries. Health Information Science and Systems, 12 (1), 1–10. https://doi.org/10.1186/s12982-024-00264-0
2. Akinyemi, O. R., Sibiya, M. N., and Oladimeji, O. (2022). Communication model enhancement using electronic health record standard for tertiary hospitals. South African Journal of Information Management, 24 (1), 1–9. https://doi.org/10.4102/sajim.v24i1.1472
3. Almulhim, A., and Khan, M. (2023). Cloud-based healthcare systems: Opportunities and challenges. Journal of Healthcare Engineering, 2023, 1–12. https://doi.org/10.1155/2023/xxxxxx
4. Edeh, S. E., Okeke, C. C., and Nwankwo, I. N. (2024). Design and implementation of an SMS and email-based medical record system. IOSR Journal of Computer Engineering, 26(2), 30–35.
5. Elmasri, R., and Navathe, S. B. (2016). Fundamentals of database systems (7th ed.). Pearson.
6. Fielding, R. T. (2000). Architectural styles and the design of network-based software architectures (Doctoral dissertation, University of California, Irvine).
7. Johnson, M., Smith, R., and Brown, L. (2022). User-centered design in healthcare systems: Improving usability and adoption. International Journal of Medical Informatics, 165, 104830. https://doi.org/10.1016/j.ijmedinf.2022.104830
8. Jubayer, F., Rahman, M. S., and Karim, A. (2024). Effectiveness of SMS reminders on patient retention in hypertension care. Journal of Human Hypertension. https://doi.org/10.1038/s41371-024-00942-1
9. Karkonasasi, K., et al. (2023). Acceptance of mobile health reminder systems in healthcare settings. Vaccines, 11 (8), 1331. https://doi.org/10.3390/vaccines11081331
10. Khan, R. A., Ahmed, S., and Ali, N. (2022). Big data and NoSQL databases in healthcare applications. Journal of Big Data, 9(1), 1–15. https://doi.org/10.1186/s40537-022-005xx
11. Pressman, R. S., and Maxim, B. R. (2020). Software engineering: A practitioner’s approach (9th ed.). McGraw-Hill Education.
12. Sommerville, I. (2020). Software engineering (10th ed.). Pearson.
13. Tan, C. X. Y., Chua, W. L., and Shorey, S. (2024). Effectiveness of text message reminders on appointment attendance: A systematic review and meta-analysis. European Journal of Pediatrics. https://doi.org/10.1007/s00431-024-05769-z
14. Topol, E. (2021). Deep medicine: How artificial intelligence can make healthcare human again. Basic Books.
15. Zewdu, B. T., et al. (2024). Willingness to receive mobile phone text message reminders for hypertension management. BMC Health Services Research, 24, 11794. https://doi.org/10.1186/s12913-024-11794-3