pasdaven/clinic-system

Database system project

Clinic System

The project of Database Systems course, provide clinic management doctors and patients.

Screenshots

Features

Clinic

• Edit Appointment
• Search Patient Records
• Search / Update / Add Patient Information
• Search / Update / Add Doctor Information
• Search / Update / Add Medicine Information
• Doctor Schedule
• Update Doctor Schedule

Patient

• Patient Appointment
• Doctor Schedule
• Search Patient Records
• Search Medicine Information

Doctor

• Search / Add Patient Records
• Add / Delete Patient Allergy
• Search Medicine Information

Tech Stack

Client: HTML, CSS, Javascript, Bootstrap, jQuery, jQuery UI

Server: PHP, MySQL

Run Locally

1. Change directory to XAMPP's htdoc

2. Clone the project

  git clone https://github.com/davidho0403/clinic-system.git

3. Setup db connection info db_con.php

  cd /database/

4. Run XAMPP Apache Server and Database Server

5. Execute create_tables.sql and add_test_data.sql in the DBMS

6. Open homepage localhost/clinic-system/view/clinic/

Authors

• @davidho0403

• @ridemountainpig

• @pascal910107