A frontend & backend solution for easily managing patients in a clinic.

This is my Computer Science IA for the International Baccalaurete Diploma Program.

Written in PHP, MySQL and HTML, CSS, JS. Tested to run on MySQL version 8.0.x and PHP 7.3.x.

Frontend is written using the following FOSS projects:

• Bulma CSS framework
• Bootstrap CSS framework
• EasyAutocomplete.js
• Jquery Repetable.js
• FullCalendar.js
• Popper.js
• Moment.js

Features Rundown

1. Autocomplete search for a patient or a patient's visit.
2. Advanced search of a patient's visit. Search by giving name or surname or both and date of visit or diagnosis. Example: Foo,1/2019 fetches all visits of patient Foo from Jan 2019.
3. Batch manipulation of patients. Easy and fast removal of multiple rows from database.
4. Multiple phone number support for each patient using Jquery Repeatable on frontend.
5. Intuitive agenda/calendar showing future and past appointments using FullCalendar.js
6. Secure | SQL Injection, Self-XSS and CSRF protection.

Demo video showing some of the features.

Initial setup

• Clone this github repository.
• Execute SCRIPT.sql on your MySQL Server.
• Move all files of this repository to your localhost,root directory.
• Change the MySQL credentials present in /login/index_int.php and /Classes/Connect.php
• Start your Apache,PHP Server and navigate to localhost.

Note

For further explanation of features please see the Changelog.