-
Notifications
You must be signed in to change notification settings - Fork 0
/
LogP.php
129 lines (120 loc) · 4.19 KB
/
LogP.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
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
<?php
session_start();
include('DB_Con.php');
$_SESSION['found']=false;
if(isset($_POST['Bbtn']))
{
$_SESSION['Stat']="";
$_SESSION['AFname']="";
$_SESSION['ASname']="";
$_SESSION['ADOB']="";
$_SESSION['Atrn']="";
$_SESSION['Adate']="";
$_SESSION['errStat']="";
$_SESSION['errDate']="";
$_SESSION['Errkey']="";
$_SESSION['key']="";
header("Location: NursePortal.php");
}
else if(isset($_POST['Sbtn']))
{
$key=$_POST['key'];
$_SESSION['key']=$key;
if(($key=="")||(!is_numeric($key)))
{
$errKey="<p style='color:red'>Invalid Patient's TRN</p>";
$_SESSION['Errkey']=$errKey;
header('Location: LogPatient.php');
}
else{
$errKey="";
$_SESSION['Errkey']=$errKey;
$_SESSION['key']=$key;
$query="SELECT * from Patient WHERE PatientsTRN='".$key."' ";
$result = $conn->query($query);
$row = mysqli_fetch_array($result);
$_SESSION['Atrn']=$row["PatientsTRN"];
$_SESSION['AFname']=$row["FirstName"];
$_SESSION['ASname']=$row["LastName"];
$_SESSION['ADOB']=$row["DOB"];
if( $_SESSION['Atrn']=="")
{
$errKey="<p style='color:red'>Patient not found</p>";
$_SESSION['Errkey']=$errKey;
header('Location: LogPatient.php');
}
else{
$_SESSION['found']=true;
header('Location: LogPatient.php');
}
$conn->close();
}
}
else if(isset($_POST['Lbtn']))
{
$key=$_POST['key'];
if($_SESSION['Atrn']=="")
{
echo "<script>alert('Please select a Patient Profile');</script>";
$_SESSION['Errkey']=$errKey;
$_SESSION['aerrStat']="";
header("refresh:0; url=LogPatient.php");
}
else{
$errKey="";
$_SESSION['Errkey']=$errKey;
$_SESSION['key']=$key;
$Date=$_POST["Adate"];
$Status=$_POST["status"];
$errChk=0;
if($Status=="")
{
$errChk++;
$errStat="<p style='color:red'>Invalid Status. </p>";
}
else
{
$errStat="";
}
$test_arr = explode('/', $Date);
if ((checkdate($test_arr[1], $test_arr[0], $test_arr[2])) && ($Date!="")) {
$errDate="";
}
else
{
$errChk++;
$errDate="<p style='color:red'>Invalid Date. </p>";
}
$_SESSION['Stat']=$Status;
$_SESSION['Adate']=$Date;
$_SESSION['errStat']=$errStat;
$_SESSION['errDate']=$errDate;
if($errChk==0)
{
$query = "INSERT INTO Appointment (PatientsTRN, StaffID, Date, Status) VALUES ('".$_SESSION['Atrn']."', '".$_SESSION['CurrentUID']."', '".$Date."', '".$Status."') ";
if ($conn->query($query) === TRUE) {
echo "<script>alert('Patient Successfully Logged');</script>";
$_SESSION['Stat']="";
$_SESSION['Atrn']="";
$_SESSION['Adate']="";
$_SESSION['AFname']="";
$_SESSION['ASname']="";
$_SESSION['ADOB']="";
$_SESSION['AFname']="";
$_SESSION['ASname']="";
$_SESSION['ADOB']="";
$_SESSION['errStat']="";
$_SESSION['errDate']="";
$_SESSION['key']="";
header( "refresh:0; url=LogPatient.php" );
}
else {
echo "Error: " . $query . "<br>" . $conn->error;
}
}
else{
header("Location: LogPatient.php");
}
}
}
?>