Esign And Implementation of a PHP–MySQL Hospital Dashboard With Multi-Role Access And Api Integration
Kata Kunci:
Hospital dashboard, Health information system, Web application, Role-based access, Black-box testingAbstrak
Hospital information environments generate administrative and clinical data that are difficult to interpret when records are fragmented across separate screens or manually compiled reports. This study presents the design and implementation of a web-based hospital dashboard developed using PHP and MySQL, with an application structure that separates database configuration, the main index layer, and dashboard pages. The system supports multi-role authentication for administrators, physicians, and patients and exposes an application programming interface (API) tested through Postman and a web interface. The development process consisted of requirements analysis, system and database design, procedural PHP implementation, interface development, and black-box functional testing. The implemented prototype demonstrates role-specific login behavior, consistent JSON responses during API testing, password-protected authentication, an administrative dashboard, and API use across web and mobile-oriented workflows. In contrast to the short implementation report in the source manuscript, this expanded study interprets the prototype against contemporary evidence on hospital dashboards, usability, interoperability, data quality, and health information security. The results support the technical feasibility of a lightweight PHP–MySQL dashboard for centralized hospital information access; however, the available evidence is functional rather than clinical. No latency benchmark, usability score, cybersecurity penetration test, or patient-outcome evaluation was reported in the source study. Accordingly, the system should be considered a functional prototype whose readiness for production deployment requires further validation of usability, interoperability, data quality, scalability, and security. The study contributes a reproducible architecture and a clearer evaluation framework for subsequent hospital-dashboard research.
Unduhan
Referensi
[1] R. Rabiei and S. Almasi, “Requirements and challenges of hospital dashboards: A systematic literature review,” BMC Medical Informatics and Decision Making, vol. 22, art. no. 287, 2022, doi: 10.1186/s12911-022-02037-8.
[2] D. R. Murphy, A. Savoy, T. Satterly, D. F. Sittig, and H. Singh, “Dashboards for visual display of patient safety data: A systematic review,” BMJ Health & Care Informatics, vol. 28, no. 1, e100437, 2021, doi: 10.1136/bmjhci-2021-100437.
[3] S. Almasi, K. Bahaadinbeigy, H. Ahmadi, S. Sohrabei, and R. Rabiei, “Usability evaluation of dashboards: A systematic literature review of tools,” BioMed Research International, vol. 2023, art. no. 9990933, 2023, doi: 10.1155/2023/9990933.
[4] D. Helminski et al., “Development, implementation, and evaluation methods for dashboards in health care: Scoping review,” JMIR Medical Informatics, vol. 12, e59828, 2024, doi: 10.2196/59828.
[5] L. Young and A. Vogelsmeier, “Quality dashboards in hospital settings: A systematic review with implications for nurses,” Journal of Nursing Care Quality, vol. 39, no. 2, pp. 188–194, 2024, doi: 10.1097/NCQ.0000000000000747.
[6] I. Strechen et al., “Centralized multipatient dashboards’ impact on intensive care unit clinician performance and satisfaction: A systematic review,” Applied Clinical Informatics, vol. 15, no. 3, pp. 414–427, 2024, doi: 10.1055/a-2299-7643.
[7] M. Kittel et al., “Triptychon: Usability evaluation and implementation of a web-based application for patients’ lab and vital parameters,” Digital Health, vol. 9, 2023, doi: 10.1177/20552076231211552.
[8] J. Siette, L. Dodds, F. Sharifi, A. Nguyen, M. Baysari, K. Seaman, M. Raban, N. Wabe, and J. Westbrook, “Usability and acceptability of clinical dashboards in aged care: Systematic review,” JMIR Aging, vol. 6, e42274, 2023, doi: 10.2196/42274.
[9] B. Ansari, “Evaluating the usability of public health data dashboards as information sources for professionals and the public: Findings from a case study with domain experts,” Health Information & Libraries Journal, vol. 42, no. 2, pp. 148–161, 2025, doi: 10.1111/hir.12532.
[10] C. X. Xie, Q. Chen, C. A. Hincapié, L. Hofstetter, C. G. Maher, and G. C. Machado, “Effectiveness of clinical dashboards as audit and feedback or clinical decision support tools on medication use and test ordering: A systematic review of randomized controlled trials,” Journal of the American Medical Informatics Association, vol. 29, no. 10, pp. 1773–1785, 2022, doi: 10.1093/jamia/ocac094.
[11] S. J. Hysong, C. Yang, J. Wong, M. K. Knox, P. O’Mahen, and L. A. Petersen, “Beyond information design: Designing health care dashboards for evidence-driven decision-making,” Applied Clinical Informatics, vol. 14, no. 3, pp. 465–469, 2023, doi: 10.1055/a-2068-6699.
[12] R. Carvalho et al., “Analysis of root causes of problems affecting the quality of hospital administrative data: A systematic review and Ishikawa diagram,” International Journal of Medical Informatics, vol. 156, art. no. 104584, 2021, doi: 10.1016/j.ijmedinf.2021.104584.
[13] C. N. Vorisek, M. Lehne, S. A. I. Klopfenstein, P. J. Mayer, A. Bartschke, T. Haese, and S. Thun, “Fast Healthcare Interoperability Resources (FHIR) for interoperability in health research: Systematic review,” JMIR Medical Informatics, vol. 10, no. 7, e35724, 2022, doi: 10.2196/35724.
[14] P. K. Sari, P. W. Handayani, A. N. Hidayanto, S. Yazid, and R. F. Aji, “Information security behavior in health information systems: A review of research trends and antecedent factors,” Healthcare, vol. 10, no. 12, art. no. 2531, 2022, doi: 10.3390/healthcare10122531.
[15] M. Ayaz, M. F. Pasha, M. Y. Alzahrani, R. Budiarto, and D. Stiawan, “The Fast Health Interoperability Resources (FHIR) standard: Systematic literature review of implementations, applications, challenges and opportunities,” JMIR Medical Informatics, vol. 9, no. 7, e21929, 2021, doi: 10.2196/21929.
[16] A. Torab-Miandoab, T. Samad-Soltani, A. Jodati, and P. Rezaei-Hachesu, “Interoperability of heterogeneous health information systems: A systematic literature review,” BMC Medical Informatics and Decision Making, vol. 23, art. no. 18, 2023, doi: 10.1186/s12911-023-02115-5.
[17] M. A. de Carvalho Junior and P. Bandiera-Paiva, “Implications of loosened role-based access control session control implementation for the enforcement of dynamic mutually exclusive roles properties on health information systems,” Informatics in Medicine Unlocked, vol. 27, art. no. 100780, 2021, doi: 10.1016/j.imu.2021.100780.
[18] S. Ahouanmenou, A. Van Looy, and G. Poels, “Information security and privacy in hospitals: A literature mapping and review of research gaps,” Informatics for Health and Social Care, vol. 48, no. 1, pp. 30–46, 2023, doi: 10.1080/17538157.2022.2049274.
[19] M. Malkani, E. Madan, D. Malkani, A. Madan, N. Singh, T. Bamji, and H. Sabharwal, “Rank ordered design attributes for health care dashboards including artificial intelligence: Usability study,” Online Journal of Public Health Informatics, vol. 16, e58277, 2024, doi: 10.2196/58277.
[20] G. Gao et al., “End users’ perceived engagement with clinical dashboards: A rapid review,” Studies in Health Technology and Informatics, vol. 310, pp. 1091–1095, 2024, doi: 10.3233/SHTI231133.
