-
Notifications
You must be signed in to change notification settings - Fork 0
/
edit_patient_process.php
54 lines (43 loc) · 2.38 KB
/
edit_patient_process.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
<?php
if(isset($_POST['confirmEdit'])){
echo "aaaaa";
}
$username = $_POST['usernamePatient'];
$name = $_POST['namePatient'];
$gender = $_POST['genderPatient'];
$age = $_POST['agePatient'];
$newAddress = $_POST['newAddressPatient'];
$contactNumber = $_POST['contactNumberPatient'];
$emailAdd = $_POST['emailAddressPatient'];
$medHistory = $_POST['medicalHistoryPatient'];
// alter this as per your configuration
$host = "localhost";
$user = "postgres";
$pass = "cmsc128";
$db = "UHS_Information_Management_System";
// open a connection to the database server
$connection = pg_connect("host=$host port=5432 dbname=$db user=$user password=$pass");
if (!$connection) die("Could not open connection to database server");
$query = "BEGIN WORK";
$result = pg_query($connection, $query) or die("Error in query: $query." . pg_last_error($connection));
$query = "UPDATE patient SET name='$name', gender='$gender', age='$age', medical_history='$medHistory' WHERE username='$username' ";
$result = pg_query($connection,$query) or die("Error in query: $query. " . pg_last_error($connection));
$query = "COMMIT";
$result = pg_query($connection, $query) or die("Error in query: $query." . pg_last_error($connection));
$query = "UPDATE patient_address SET address='$newAddress' WHERE username='$username' ";
$result = pg_query($connection,$query) or die("Error in query: $query. " . pg_last_error($connection));
$query = "COMMIT";
$result = pg_query($connection, $query) or die("Error in query: $query." . pg_last_error($connection));
$query = "UPDATE patient_email_address SET email_address='$emailAdd' WHERE username='$username' ";
$result = pg_query($connection,$query) or die("Error in query: $query. " . pg_last_error($connection));
$query = "COMMIT";
$result = pg_query($connection, $query) or die("Error in query: $query." . pg_last_error($connection));
$query = "UPDATE patient_contact_number SET contact_number='$contactNumber' WHERE username='$username' ";
$result = pg_query($connection,$query) or die("Error in query: $query. " . pg_last_error($connection));
$query = "COMMIT";
$result = pg_query($connection, $query) or die("Error in query: $query." . pg_last_error($connection));
$query = "COMMIT";
$result = pg_query($connection, $query) or die("Error in query: $query." . pg_last_error($connection));
pg_close($connection);
header('Location:view_all_patients.php');
?>