Drop Us a Message
0; } function isAccepted($id) { global $con; $query = "SELECT * FROM appointment WHERE AppID = '$id' AND doctorStatus=0"; $result = mysqli_query($con, $query); return mysqli_num_rows($result) > 0; } // Function to check if the appointment is cancelled function isCancelled($id) { global $con; $query = "SELECT * FROM appointment WHERE AppID = '$id' AND userStatus = 0"; $result = mysqli_query($con, $query); return mysqli_num_rows($result) > 0; } if(isset($_GET['accept'])){ $AppID=$_GET['AppID']; $sql= mysqli_query($con,"UPDATE appointment SET doctorStatus= 0 WHERE AppID = '$AppID'"); if($sql){ echo ""; } } if (isset($_GET['cancel'])) { $AppID = $_GET['AppID']; $query = mysqli_query($con, "UPDATE appointment SET userStatus = 0 WHERE AppID = '$AppID'"); if ($query) { echo ""; } } // if (isset($_GET['accept'])) { // $AppID = $_GET['AppID']; // $query = mysqli_query($con, "UPDATE appointment SET userStatus= 1 WHERE AppID = '$AppID'"); // if ($query) { // echo ""; // } // } if (isset($_GET['prescribe'])) { $AppID = $_GET['AppID']; $appdate = $_GET['appdate']; $apptime = $_GET['apptime']; $disease = $_GET['disease']; $allergy = $_GET['allergy']; $prescription = $_GET['prescription']; $query = mysqli_query($con, "INSERT INTO prescriptiontable(doctor, AppID, appdate, apptime, disease, allergy, prescription) VALUES ('$doctor', '$AppID', '$appdate', '$apptime', '$disease', '$allergy', '$prescription');"); if ($query) { echo ""; } else { echo ""; } } ?>
Necromancy Hospital

My Appointments

View Appointments

Prescriptions

View Prescriptions List

Patient ID Appointment ID First Name Last Name Gender Email Contact Appointment Date Appointment Time Current Status Action

Patient ID First Name Last Name Appointment ID Appointment Date Appointment Time Disease Allergy Prescription