MEDASSIST2 - VISUAL UNISERVERZ VERSION

Copy the contents of this folder to:
C:\Users\rafin\Downloads\UniServerZ\www\medassist2\

The homepage can be opened by double-clicking index.html.

For PHP/database pages, start UniServerZ Apache and MySQL.

Database:
medassist2

Default MySQL settings in db.php:
host: localhost
user: root
password: 1234567

If your MySQL root password differs, edit db.php.

The visual homepage is intentionally polished, while the PHP backend uses straightforward MySQLi code consistent with a typical teaching example.


PATIENT CRUD
------------
Create: add_patient.html -> insert_patient.php
Read:   view_patients.php
Update: edit_patient.php
Delete: delete_patient.php

The Patient Records table now contains Edit and Delete buttons.

Important deletion test:
The original 10 sample patients are linked to appointments, so the database
correctly prevents their deletion because of the foreign-key relationship.
To demonstrate a successful DELETE:
1. Add a temporary test patient.
2. Do not create an appointment for that patient.
3. Open Patient Records.
4. Click Delete beside the temporary patient.
5. Confirm the deletion.
6. Capture the success page and refreshed Patient Records table as evidence.
