find us here: http://medconnect.ecriprojects.de ,
and here: https://xginevra.github.io/project/ but it is not really working because of the missing database here :)
still prefer Strato for this.
By Paniz, Paya, Ali, Franzi
you find an sql file with the database in the repo.
First, all user-related pages should be a .php file in order to place the following snippet of code at the beginning:
<?php
session_start()
?>
After that, you can continue with html, js, or what you are using just as usual.
for html, just set the <html> tag before your code.
if you want to test your page locally with xampp or something: the functionalities for inserting or fetching data into/from database, i added the strato DB credentials as well as the "localhost" credentials - just comment out what you don't need.
Next, we're using several "name" fields in our input divs - make sure you're using the "right" names,
in order to keep you lovely frontend guys up to date, i will continuously update this page with the "names" for each input we want to have. example: (fileUpload is a column for the patients table which is so far not there (work in progress, on update_patientdata.php)
<input type="file" id="fileUpload" name="fileUpload" accept=".pdf, .doc, .docx">
So far, we have 2 tables: doctors and patients. the name in the table is going to be the name preferred for the inputs of the .html/.php files.
currently, "doctor_id" is a foreign key in the patients table - it originates from the doctors table's "id" which is the primary key there. they are linked so that each doctor can only see the patients they created. yay!
This is doctors:
| id | username | password | email_address | first_name | last_name | institution |
|---|---|---|---|---|---|---|
This is patients:
| patient_id | patient_name | gender | address | zipcode | city | phone | prevDiseases | allergies | signsSymptoms | diagnosis | doctor_id |
|---|---|---|---|---|---|---|---|---|---|---|---|
however, for some reason at the register.html we used u_username and all the other variables with the u_ in front of them, and this is somehow weird but i do not want to change it anymore because it is running and i am afraid that it would stop working xD but for future uses i want to just use the names from the table. It could make it work straight out of the repo which is always a good thing :)
we didn't put every extra thing, but it works perfectly fine.