Creating Admin module
Here are some features of admin module:
- Can view all the data e.g. Doctor’s data , patient’s data, sessions data, appointments data etc.
- Can edit, remove any of the doctor or patient or sessions and appointments.
Admin homepage:
View -Edit – Remove Doctor’s page:
View – remove Schedules:
View – cancel appointments:
Here is the code for Admin module:
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="stylesheet" href="../css/animations.css">
<link rel="stylesheet" href="../css/main.css">
<link rel="stylesheet" href="../css/admin.css">
<title>Doctor</title>
<style>
.popup {
animation: transitionIn-Y-bottom 0.5s;
}
</style>
</head>
<body>
<?php
//learn from w3schools.com
session_start();
if (isset($_SESSION["user"])) {
if (($_SESSION["user"]) == "" or $_SESSION['usertype'] != 'a') {
header("location: ../login.php");
}
} else {
header("location: ../login.php");
}
include("../connection.php");
if ($_POST) {
//print_r($_POST);
$result = $database->query("select * from webuser");
$name = $_POST['name'];
$nic = $_POST['nic'];
$spec = $_POST['spec'];
$email = $_POST['email'];
$tele = $_POST['Tele'];
$password = $_POST['password'];
$cpassword = $_POST['cpassword'];
if ($password == $cpassword) {
$error = '3';
$result = $database->query("select * from webuser where email='$email';");
if ($result->num_rows == 1) {
$error = '1';
} else {
$sql1 = "insert into doctor(docemail,docname,docpassword,docnic,doctel,specialties) values('$email','$name','$password','$nic','$tele',$spec);";
$sql2 = "insert into webuser values('$email','d')";
$database->query($sql1);
$database->query($sql2);
//echo $sql1;
//echo $sql2;
$error = '4';
}
} else {
$error = '2';
}
} else {
$error = '3';
}
header("location: doctors.php?action=add&error=" . $error);
?>
</body>
</html>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="stylesheet" href="../css/animations.css">
<link rel="stylesheet" href="../css/main.css">
<link rel="stylesheet" href="../css/admin.css">
<title>Patients</title>
<style>
.popup{
animation: transitionIn-Y-bottom 0.5s;
}
.sub-table{
animation: transitionIn-Y-bottom 0.5s;
}
</style>
</head>
<body>
<?php
session_start();
if(isset($_SESSION["user"])){
if(($_SESSION["user"])=="" or $_SESSION['usertype']!='a'){
header("location: ../login.php");
}
}else{
header("location: ../login.php");
}
include("../connection.php");
?>
<div class="container">
<div class="menu">
<table class="menu-container" border="0">
<tr>
<td style="padding:10px" colspan="2">
<table border="0" class="profile-container">
<tr>
<td width="30%" style="padding-left:20px" >
<img src="../img/user.png" alt="" width="100%" style="border-radius:50%">
</td>
<td style="padding:0px;margin:0px;">
<p class="profile-title">Administrator</p>
<p class="profile-subtitle">admin@edoc.com</p>
</td>
</tr>
<tr>
<td colspan="2">
<a href="../logout.php" ><input type="button" value="Log out" class="logout-btn btn-primary-soft btn"></a>
</td>
</tr>
</table>
</td>
</tr>
<tr class="menu-row" >
<td class="menu-btn menu-icon-dashbord" >
<a href="index.php" class="non-style-link-menu"><div><p class="menu-text">Dashboard</p></a></div></a>
</td>
</tr>
<tr class="menu-row">
<td class="menu-btn menu-icon-doctor ">
<a href="doctors.php" class="non-style-link-menu "><div><p class="menu-text">Doctors</p></a></div>
</td>
</tr>
<tr class="menu-row" >
<td class="menu-btn menu-icon-schedule">
<a href="schedule.php" class="non-style-link-menu"><div><p class="menu-text">Schedule</p></div></a>
</td>
</tr>
<tr class="menu-row">
<td class="menu-btn menu-icon-appoinment">
<a href="appointment.php" class="non-style-link-menu"><div><p class="menu-text">Appointment</p></a></div>
</td>
</tr>
<tr class="menu-row" >
<td class="menu-btn menu-icon-patient menu-active menu-icon-patient-active">
<a href="patient.php" class="non-style-link-menu non-style-link-menu-active"><div><p class="menu-text">Patients</p></a></div>
</td>
</tr>
</table>
</div>
<div class="dash-body">
<table border="0" width="100%" style=" border-spacing: 0;margin:0;padding:0;margin-top:25px; ">
<tr >
<td width="13%">
<a href="patient.php" ><button class="login-btn btn-primary-soft btn btn-icon-back" style="padding-top:11px;padding-bottom:11px;margin-left:20px;width:125px"><font class="tn-in-text">Back</font></button></a>
</td>
<td>
<form action="" method="post" class="header-search">
<input type="search" name="search" class="input-text header-searchbar" placeholder="Search Patient name or Email" list="patient">
<?php
echo '<datalist id="patient">';
$list11 = $database->query("select pname,pemail from patient;");
for ($y=0;$y<$list11->num_rows;$y++){
$row00=$list11->fetch_assoc();
$d=$row00["pname"];
$c=$row00["pemail"];
echo "<option value='$d'><br/>";
echo "<option value='$c'><br/>";
};
echo ' </datalist>';
?>
<input type="Submit" value="Search" class="login-btn btn-primary btn" style="padding-left: 25px;padding-right: 25px;padding-top: 10px;padding-bottom: 10px;">
</form>
</td>
<td width="15%">
<p style="font-size: 14px;color: rgb(119, 119, 119);padding: 0;margin: 0;text-align: right;">
Today's Date
</p>
<p class="heading-sub12" style="padding: 0;margin: 0;">
<?php
date_default_timezone_set('Asia/Kolkata');
$date = date('Y-m-d');
echo $date;
?>
</p>
</td>
<td width="10%">
<button class="btn-label" style="display: flex;justify-content: center;align-items: center;"><img src="../img/calendar.svg" width="100%"></button>
</td>
</tr>
<tr>
<td colspan="4" style="padding-top:10px;">
<p class="heading-main12" style="margin-left: 45px;font-size:18px;color:rgb(49, 49, 49)">All Patients (<?php echo $list11->num_rows; ?>)</p>
</td>
</tr>
<?php
if($_POST){
$keyword=$_POST["search"];
$sqlmain= "select * from patient where pemail='$keyword' or pname='$keyword' or pname like '$keyword%' or pname like '%$keyword' or pname like '%$keyword%' ";
}else{
$sqlmain= "select * from patient order by pid desc";
}
?>
<tr>
<td colspan="4">
<center>
<div class="abc scroll">
<table width="93%" class="sub-table scrolldown" style="border-spacing:0;">
<thead>
<tr>
<th class="table-headin">
Name
</th>
<th class="table-headin">
NIC
</th>
<th class="table-headin">
Telephone
</th>
<th class="table-headin">
Email
</th>
<th class="table-headin">
Date of Birth
</th>
<th class="table-headin">
Events
</tr>
</thead>
<tbody>
<?php
$result= $database->query($sqlmain);
if($result->num_rows==0){
echo '<tr>
<td colspan="4">
<br><br><br><br>
<center>
<img src="../img/notfound.svg" width="25%">
<br>
<p class="heading-main12" style="margin-left: 45px;font-size:20px;color:rgb(49, 49, 49)">We couldnt find anything related to your keywords !</p>
<a class="non-style-link" href="patient.php"><button class="login-btn btn-primary-soft btn" style="display: flex;justify-content: center;align-items: center;margin-left:20px;"> Show all Patients </font></button>
</a>
</center>
<br><br><br><br>
</td>
</tr>';
}
else{
for ( $x=0; $x<$result->num_rows;$x++){
$row=$result->fetch_assoc();
$pid=$row["pid"];
$name=$row["pname"];
$email=$row["pemail"];
$nic=$row["pnic"];
$dob=$row["pdob"];
$tel=$row["ptel"];
echo '<tr>
<td> '.
substr($name,0,35)
.'</td>
<td>
'.substr($nic,0,12).'
</td>
<td>
'.substr($tel,0,10).'
</td>
<td>
'.substr($email,0,20).'
</td>
<td>
'.substr($dob,0,10).'
</td>
<td >
<div style="display:flex;justify-content: center;">
<a href="?action=view&id='.$pid.'" class="non-style-link"><button class="btn-primary-soft btn button-icon btn-view" style="padding-left: 40px;padding-top: 12px;padding-bottom: 12px;margin-top: 10px;"><font class="tn-in-text">View</font></button></a>
</div>
</td>
</tr>';
}
}
?>
</tbody>
</table>
</div>
</center>
</td>
</tr>
</table>
</div>
</div>
<?php
if($_GET){
$id=$_GET["id"];
$action=$_GET["action"];
$sqlmain= "select * from patient where pid='$id'";
$result= $database->query($sqlmain);
$row=$result->fetch_assoc();
$name=$row["pname"];
$email=$row["pemail"];
$nic=$row["pnic"];
$dob=$row["pdob"];
$tele=$row["ptel"];
$address=$row["paddress"];
echo '
<div id="popup1" class="overlay">
<div class="popup">
<center>
<a class="close" href="patient.php">×</a>
<div class="content">
</div>
<div style="display: flex;justify-content: center;">
<table width="80%" class="sub-table scrolldown add-doc-form-container" border="0">
<tr>
<td>
<p style="padding: 0;margin: 0;text-align: left;font-size: 25px;font-weight: 500;">View Details.</p><br><br>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<label for="name" class="form-label">Patient ID: </label>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
P-'.$id.'<br><br>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<label for="name" class="form-label">Name: </label>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
'.$name.'<br><br>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<label for="Email" class="form-label">Email: </label>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
'.$email.'<br><br>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<label for="nic" class="form-label">NIC: </label>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
'.$nic.'<br><br>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<label for="Tele" class="form-label">Telephone: </label>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
'.$tele.'<br><br>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<label for="spec" class="form-label">Address: </label>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
'.$address.'<br><br>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<label for="name" class="form-label">Date of Birth: </label>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
'.$dob.'<br><br>
</td>
</tr>
<tr>
<td colspan="2">
<a href="patient.php"><input type="button" value="OK" class="login-btn btn-primary-soft btn" ></a>
</td>
</tr>
</table>
</div>
</center>
<br><br>
</div>
</div>
';
};
?>
</div>
</body>
</html>
<?php
//import database
include("../connection.php");
if($_POST){
$result= $database->query("select * from webuser");
$name=$_POST['name'];
$nic=$_POST['nic'];
$oldemail=$_POST["oldemail"];
$spec=$_POST['spec'];
$email=$_POST['email'];
$tele=$_POST['Tele'];
$password=$_POST['password'];
$cpassword=$_POST['cpassword'];
$id=$_POST['id00'];
if ($password==$cpassword){
$error='3';
$result= $database->query("select doctor.docid from doctor inner join webuser on doctor.docemail=webuser.email where webuser.email='$email';");
if($result->num_rows==1){
$id2=$result->fetch_assoc()["docid"];
}else{
$id2=$id;
}
echo $id2."jdfjdfdh";
if($id2!=$id){
$error='1';
}else{
$sql1="update doctor set docemail='$email',docname='$name',docpassword='$password',docnic='$nic',doctel='$tele',specialties=$spec where docid=$id ;";
$database->query($sql1);
$sql1="update webuser set email='$email' where email='$oldemail' ;";
$database->query($sql1);
$error= '4';
}
}else{
$error='2';
}
}else{
$error='3';
}
header("location: doctors.php?action=edit&error=".$error."&id=".$id);
?>
</body>
</html>
<?php
session_start();
if(isset($_SESSION["user"])){
if(($_SESSION["user"])=="" or $_SESSION['usertype']!='a'){
header("location: ../login.php");
}
}else{
header("location: ../login.php");
}
if($_POST){
//import database
include("../connection.php");
$title=$_POST["title"];
$docid=$_POST["docid"];
$nop=$_POST["nop"];
$date=$_POST["date"];
$time=$_POST["time"];
$sql="insert into schedule (docid,title,scheduledate,scheduletime,nop) values ($docid,'$title','$date','$time',$nop);";
$result= $database->query($sql);
header("location: schedule.php?action=session-added&title=$title");
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="stylesheet" href="../css/animations.css">
<link rel="stylesheet" href="../css/main.css">
<link rel="stylesheet" href="../css/admin.css">
<title>Appointments</title>
<style>
.popup{
animation: transitionIn-Y-bottom 0.5s;
}
.sub-table{
animation: transitionIn-Y-bottom 0.5s;
}
</style>
</head>
<body>
<?php
session_start();
if(isset($_SESSION["user"])){
if(($_SESSION["user"])=="" or $_SESSION['usertype']!='a'){
header("location: ../login.php");
}
}else{
header("location: ../login.php");
}
//import database
include("../connection.php");
?>
<div class="container">
<div class="menu">
<table class="menu-container" border="0">
<tr>
<td style="padding:10px" colspan="2">
<table border="0" class="profile-container">
<tr>
<td width="30%" style="padding-left:20px" >
<img src="../img/user.png" alt="" width="100%" style="border-radius:50%">
</td>
<td style="padding:0px;margin:0px;">
<p class="profile-title">Administrator</p>
<p class="profile-subtitle">admin@edoc.com</p>
</td>
</tr>
<tr>
<td colspan="2">
<a href="../logout.php" ><input type="button" value="Log out" class="logout-btn btn-primary-soft btn"></a>
</td>
</tr>
</table>
</td>
</tr>
<tr class="menu-row" >
<td class="menu-btn menu-icon-dashbord" >
<a href="index.php" class="non-style-link-menu"><div><p class="menu-text">Dashboard</p></a></div></a>
</td>
</tr>
<tr class="menu-row">
<td class="menu-btn menu-icon-doctor ">
<a href="doctors.php" class="non-style-link-menu "><div><p class="menu-text">Doctors</p></a></div>
</td>
</tr>
<tr class="menu-row" >
<td class="menu-btn menu-icon-schedule ">
<a href="schedule.php" class="non-style-link-menu"><div><p class="menu-text">Schedule</p></div></a>
</td>
</tr>
<tr class="menu-row">
<td class="menu-btn menu-icon-appoinment menu-active menu-icon-appoinment-active">
<a href="appointment.php" class="non-style-link-menu non-style-link-menu-active"><div><p class="menu-text">Appointment</p></a></div>
</td>
</tr>
<tr class="menu-row" >
<td class="menu-btn menu-icon-patient">
<a href="patient.php" class="non-style-link-menu"><div><p class="menu-text">Patients</p></a></div>
</td>
</tr>
</table>
</div>
<div class="dash-body">
<table border="0" width="100%" style=" border-spacing: 0;margin:0;padding:0;margin-top:25px; ">
<tr >
<td width="13%" >
<a href="appointment.php" ><button class="login-btn btn-primary-soft btn btn-icon-back" style="padding-top:11px;padding-bottom:11px;margin-left:20px;width:125px"><font class="tn-in-text">Back</font></button></a>
</td>
<td>
<p style="font-size: 23px;padding-left:12px;font-weight: 600;">Appointment Manager</p>
</td>
<td width="15%">
<p style="font-size: 14px;color: rgb(119, 119, 119);padding: 0;margin: 0;text-align: right;">
Today's Date
</p>
<p class="heading-sub12" style="padding: 0;margin: 0;">
<?php
date_default_timezone_set('Asia/Kolkata');
$today = date('Y-m-d');
echo $today;
$list110 = $database->query("select * from appointment;");
?>
</p>
</td>
<td width="10%">
<button class="btn-label" style="display: flex;justify-content: center;align-items: center;"><img src="../img/calendar.svg" width="100%"></button>
</td>
</tr>
<tr>
<td colspan="4" style="padding-top:10px;width: 100%;" >
<p class="heading-main12" style="margin-left: 45px;font-size:18px;color:rgb(49, 49, 49)">All Appointments (<?php echo $list110->num_rows; ?>)</p>
</td>
</tr>
<tr>
<td colspan="4" style="padding-top:0px;width: 100%;" >
<center>
<table class="filter-container" border="0" >
<tr>
<td width="10%">
</td>
<td width="5%" style="text-align: center;">
Date:
</td>
<td width="30%">
<form action="" method="post">
<input type="date" name="sheduledate" id="date" class="input-text filter-container-items" style="margin: 0;width: 95%;">
</td>
<td width="5%" style="text-align: center;">
Doctor:
</td>
<td width="30%">
<select name="docid" id="" class="box filter-container-items" style="width:90% ;height: 37px;margin: 0;" >
<option value="" disabled selected hidden>Choose Doctor Name from the list</option><br/>
<?php
$list11 = $database->query("select * from doctor order by docname asc;");
for ($y=0;$y<$list11->num_rows;$y++){
$row00=$list11->fetch_assoc();
$sn=$row00["docname"];
$id00=$row00["docid"];
echo "<option value=".$id00.">$sn</option><br/>";
};
?>
</select>
</td>
<td width="12%">
<input type="submit" name="filter" value=" Filter" class=" btn-primary-soft btn button-icon btn-filter" style="padding: 15px; margin :0;width:100%">
</form>
</td>
</tr>
</table>
</center>
</td>
</tr>
<?php
if($_POST){
$sqlpt1="";
if(!empty($_POST["sheduledate"])){
$sheduledate=$_POST["sheduledate"];
$sqlpt1=" schedule.scheduledate='$sheduledate' ";
}
$sqlpt2="";
if(!empty($_POST["docid"])){
$docid=$_POST["docid"];
$sqlpt2=" doctor.docid=$docid ";
}
$sqlmain= "select appointment.appoid,schedule.scheduleid,schedule.title,doctor.docname,patient.pname,schedule.scheduledate,schedule.scheduletime,appointment.apponum,appointment.appodate from schedule inner join appointment on schedule.scheduleid=appointment.scheduleid inner join patient on patient.pid=appointment.pid inner join doctor on schedule.docid=doctor.docid";
$sqllist=array($sqlpt1,$sqlpt2);
$sqlkeywords=array(" where "," and ");
$key2=0;
foreach($sqllist as $key){
if(!empty($key)){
$sqlmain.=$sqlkeywords[$key2].$key;
$key2++;
};
};
}else{
$sqlmain= "select appointment.appoid,schedule.scheduleid,schedule.title,doctor.docname,patient.pname,schedule.scheduledate,schedule.scheduletime,appointment.apponum,appointment.appodate from schedule inner join appointment on schedule.scheduleid=appointment.scheduleid inner join patient on patient.pid=appointment.pid inner join doctor on schedule.docid=doctor.docid order by schedule.scheduledate desc";
}
?>
<tr>
<td colspan="4">
<center>
<div class="abc scroll">
<table width="93%" class="sub-table scrolldown" border="0">
<thead>
<tr>
<th class="table-headin">
Patient name
</th>
<th class="table-headin">
Appointment number
</th>
<th class="table-headin">
Doctor
</th>
<th class="table-headin">
Session Title
</th>
<th class="table-headin" style="font-size:10px">
Session Date & Time
</th>
<th class="table-headin">
Appointment Date
</th>
<th class="table-headin">
Events
</tr>
</thead>
<tbody>
<?php
$result= $database->query($sqlmain);
if($result->num_rows==0){
echo '<tr>
<td colspan="7">
<br><br><br><br>
<center>
<img src="../img/notfound.svg" width="25%">
<br>
<p class="heading-main12" style="margin-left: 45px;font-size:20px;color:rgb(49, 49, 49)">We couldnt find anything related to your keywords !</p>
<a class="non-style-link" href="appointment.php"><button class="login-btn btn-primary-soft btn" style="display: flex;justify-content: center;align-items: center;margin-left:20px;"> Show all Appointments </font></button>
</a>
</center>
<br><br><br><br>
</td>
</tr>';
}
else{
for ( $x=0; $x<$result->num_rows;$x++){
$row=$result->fetch_assoc();
$appoid=$row["appoid"];
$scheduleid=$row["scheduleid"];
$title=$row["title"];
$docname=$row["docname"];
$scheduledate=$row["scheduledate"];
$scheduletime=$row["scheduletime"];
$pname=$row["pname"];
$apponum=$row["apponum"];
$appodate=$row["appodate"];
echo '<tr >
<td style="font-weight:600;"> '.
substr($pname,0,25)
.'</td >
<td style="text-align:center;font-size:23px;font-weight:500; color: var(--btnnicetext);">
'.$apponum.'
</td>
<td>
'.substr($docname,0,25).'
</td>
<td>
'.substr($title,0,15).'
</td>
<td style="text-align:center;font-size:12px;">
'.substr($scheduledate,0,10).' <br>'.substr($scheduletime,0,5).'
</td>
<td style="text-align:center;">
'.$appodate.'
</td>
<td>
<div style="display:flex;justify-content: center;">
<!--<a href="?action=view&id='.$appoid.'" class="non-style-link"><button class="btn-primary-soft btn button-icon btn-view" style="padding-left: 40px;padding-top: 12px;padding-bottom: 12px;margin-top: 10px;"><font class="tn-in-text">View</font></button></a>
-->
<a href="?action=drop&id='.$appoid.'&name='.$pname.'&session='.$title.'&apponum='.$apponum.'" class="non-style-link"><button class="btn-primary-soft btn button-icon btn-delete" style="padding-left: 40px;padding-top: 12px;padding-bottom: 12px;margin-top: 10px;"><font class="tn-in-text">Cancel</font></button></a>
</div>
</td>
</tr>';
}
}
?>
</tbody>
</table>
</div>
</center>
</td>
</tr>
</table>
</div>
</div>
<?php
if($_GET){
$id=$_GET["id"];
$action=$_GET["action"];
if($action=='add-session'){
echo '
<div id="popup1" class="overlay">
<div class="popup">
<center>
<a class="close" href="schedule.php">×</a>
<div style="display: flex;justify-content: center;">
<div class="abc">
<table width="80%" class="sub-table scrolldown add-doc-form-container" border="0">
<tr>
<td class="label-td" colspan="2">'.
""
.'</td>
</tr>
<tr>
<td>
<p style="padding: 0;margin: 0;text-align: left;font-size: 25px;font-weight: 500;">Add New Session.</p><br>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<form action="add-session.php" method="POST" class="add-new-form">
<label for="title" class="form-label">Session Title : </label>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<input type="text" name="title" class="input-text" placeholder="Name of this Session" required><br>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<label for="docid" class="form-label">Select Doctor: </label>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<select name="docid" id="" class="box" >
<option value="" disabled selected hidden>Choose Doctor Name from the list</option><br/>';
$list11 = $database->query("select * from doctor;");
for ($y=0;$y<$list11->num_rows;$y++){
$row00=$list11->fetch_assoc();
$sn=$row00["docname"];
$id00=$row00["docid"];
echo "<option value=".$id00.">$sn</option><br/>";
};
echo ' </select><br><br>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<label for="nop" class="form-label">Number of Patients/Appointment Numbers : </label>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<input type="number" name="nop" class="input-text" min="0" placeholder="The final appointment number for this session depends on this number" required><br>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<label for="date" class="form-label">Session Date: </label>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<input type="date" name="date" class="input-text" min="'.date('Y-m-d').'" required><br>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<label for="time" class="form-label">Schedule Time: </label>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<input type="time" name="time" class="input-text" placeholder="Time" required><br>
</td>
</tr>
<tr>
<td colspan="2">
<input type="reset" value="Reset" class="login-btn btn-primary-soft btn" >
<input type="submit" value="Place this Session" class="login-btn btn-primary btn" name="shedulesubmit">
</td>
</tr>
</form>
</tr>
</table>
</div>
</div>
</center>
<br><br>
</div>
</div>
';
}elseif($action=='session-added'){
$titleget=$_GET["title"];
echo '
<div id="popup1" class="overlay">
<div class="popup">
<center>
<br><br>
<h2>Session Placed.</h2>
<a class="close" href="schedule.php">×</a>
<div class="content">
'.substr($titleget,0,40).' was scheduled.<br><br>
</div>
<div style="display: flex;justify-content: center;">
<a href="schedule.php" class="non-style-link"><button class="btn-primary btn" style="display: flex;justify-content: center;align-items: center;margin:10px;padding:10px;"><font class="tn-in-text"> OK </font></button></a>
<br><br><br><br>
</div>
</center>
</div>
</div>
';
}elseif($action=='drop'){
$nameget=$_GET["name"];
$session=$_GET["session"];
$apponum=$_GET["apponum"];
echo '
<div id="popup1" class="overlay">
<div class="popup">
<center>
<h2>Are you sure?</h2>
<a class="close" href="appointment.php">×</a>
<div class="content">
You want to delete this record<br><br>
Patient Name: <b>'.substr($nameget,0,40).'</b><br>
Appointment number : <b>'.substr($apponum,0,40).'</b><br><br>
</div>
<div style="display: flex;justify-content: center;">
<a href="delete-appointment.php?id='.$id.'" class="non-style-link"><button class="btn-primary btn" style="display: flex;justify-content: center;align-items: center;margin:10px;padding:10px;"<font class="tn-in-text"> Yes </font></button></a>
<a href="appointment.php" class="non-style-link"><button class="btn-primary btn" style="display: flex;justify-content: center;align-items: center;margin:10px;padding:10px;"><font class="tn-in-text"> No </font></button></a>
</div>
</center>
</div>
</div>
';
}elseif($action=='view'){
$sqlmain= "select * from doctor where docid='$id'";
$result= $database->query($sqlmain);
$row=$result->fetch_assoc();
$name=$row["docname"];
$email=$row["docemail"];
$spe=$row["specialties"];
$spcil_res= $database->query("select sname from specialties where id='$spe'");
$spcil_array= $spcil_res->fetch_assoc();
$spcil_name=$spcil_array["sname"];
$nic=$row['docnic'];
$tele=$row['doctel'];
echo '
<div id="popup1" class="overlay">
<div class="popup">
<center>
<h2></h2>
<a class="close" href="doctors.php">×</a>
<div class="content">
eDoc Web App<br>
</div>
<div style="display: flex;justify-content: center;">
<table width="80%" class="sub-table scrolldown add-doc-form-container" border="0">
<tr>
<td>
<p style="padding: 0;margin: 0;text-align: left;font-size: 25px;font-weight: 500;">View Details.</p><br><br>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<label for="name" class="form-label">Name: </label>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
'.$name.'<br><br>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<label for="Email" class="form-label">Email: </label>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
'.$email.'<br><br>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<label for="nic" class="form-label">NIC: </label>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
'.$nic.'<br><br>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<label for="Tele" class="form-label">Telephone: </label>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
'.$tele.'<br><br>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<label for="spec" class="form-label">Specialties: </label>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
'.$spcil_name.'<br><br>
</td>
</tr>
<tr>
<td colspan="2">
<a href="doctors.php"><input type="button" value="OK" class="login-btn btn-primary-soft btn" ></a>
</td>
</tr>
</table>
</div>
</center>
<br><br>
</div>
</div>
';
}
}
?>
</div>
</body>
</html>
<?php
session_start();
if (isset($_SESSION["user"])) {
if (($_SESSION["user"]) == "" or $_SESSION['usertype'] != 'a') {
header("location: ../login.php");
}
} else {
header("location: ../login.php");
}
if ($_GET) {
include("../connection.php");
$id = $_GET["id"];
$sql = $database->query("delete from appointment where appoid='$id';");
header("location: appointment.php");
}
<?php
session_start();
if(isset($_SESSION["user"])){
if(($_SESSION["user"])=="" or $_SESSION['usertype']!='a'){
header("location: ../login.php");
}
}else{
header("location: ../login.php");
}
if($_GET){
include("../connection.php");
$id=$_GET["id"];
$result001= $database->query("select * from doctor where docid=$id;");
$email=($result001->fetch_assoc())["docemail"];
$sql= $database->query("delete from webuser where email='$email';");
$sql= $database->query("delete from doctor where docemail='$email';");
header("location: doctors.php");
}
?>
<?php
session_start();
if(isset($_SESSION["user"])){
if(($_SESSION["user"])=="" or $_SESSION['usertype']!='a'){
header("location: ../login.php");
}
}else{
header("location: ../login.php");
}
if($_GET){
include("../connection.php");
$id=$_GET["id"];
$sql= $database->query("delete from schedule where scheduleid='$id';");
header("location: schedule.php");
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="stylesheet" href="../css/animations.css">
<link rel="stylesheet" href="../css/main.css">
<link rel="stylesheet" href="../css/admin.css">
<title>Doctors</title>
<style>
.popup{
animation: transitionIn-Y-bottom 0.5s;
}
.sub-table{
animation: transitionIn-Y-bottom 0.5s;
}
</style>
</head>
<body>
<?php
session_start();
if(isset($_SESSION["user"])){
if(($_SESSION["user"])=="" or $_SESSION['usertype']!='a'){
header("location: ../login.php");
}
}else{
header("location: ../login.php");
}
include("../connection.php");
?>
<div class="container">
<div class="menu">
<table class="menu-container" border="0">
<tr>
<td style="padding:10px" colspan="2">
<table border="0" class="profile-container">
<tr>
<td width="30%" style="padding-left:20px" >
<img src="../img/user.png" alt="" width="100%" style="border-radius:50%">
</td>
<td style="padding:0px;margin:0px;">
<p class="profile-title">Administrator</p>
<p class="profile-subtitle">admin@edoc.com</p>
</td>
</tr>
<tr>
<td colspan="2">
<a href="../logout.php" ><input type="button" value="Log out" class="logout-btn btn-primary-soft btn"></a>
</td>
</tr>
</table>
</td>
</tr>
<tr class="menu-row" >
<td class="menu-btn menu-icon-dashbord" >
<a href="index.php" class="non-style-link-menu"><div><p class="menu-text">Dashboard</p></a></div></a>
</td>
</tr>
<tr class="menu-row">
<td class="menu-btn menu-icon-doctor menu-active menu-icon-doctor-active">
<a href="doctors.php" class="non-style-link-menu non-style-link-menu-active"><div><p class="menu-text">Doctors</p></a></div>
</td>
</tr>
<tr class="menu-row" >
<td class="menu-btn menu-icon-schedule">
<a href="schedule.php" class="non-style-link-menu"><div><p class="menu-text">Schedule</p></div></a>
</td>
</tr>
<tr class="menu-row">
<td class="menu-btn menu-icon-appoinment">
<a href="appointment.php" class="non-style-link-menu"><div><p class="menu-text">Appointment</p></a></div>
</td>
</tr>
<tr class="menu-row" >
<td class="menu-btn menu-icon-patient">
<a href="patient.php" class="non-style-link-menu"><div><p class="menu-text">Patients</p></a></div>
</td>
</tr>
</table>
</div>
<div class="dash-body">
<table border="0" width="100%" style=" border-spacing: 0;margin:0;padding:0;margin-top:25px; ">
<tr >
<td width="13%">
<a href="doctors.php" ><button class="login-btn btn-primary-soft btn btn-icon-back" style="padding-top:11px;padding-bottom:11px;margin-left:20px;width:125px"><font class="tn-in-text">Back</font></button></a>
</td>
<td>
<form action="" method="post" class="header-search">
<input type="search" name="search" class="input-text header-searchbar" placeholder="Search Doctor name or Email" list="doctors">
<?php
echo '<datalist id="doctors">';
$list11 = $database->query("select docname,docemail from doctor;");
for ($y=0;$y<$list11->num_rows;$y++){
$row00=$list11->fetch_assoc();
$d=$row00["docname"];
$c=$row00["docemail"];
echo "<option value='$d'><br/>";
echo "<option value='$c'><br/>";
};
echo ' </datalist>';
?>
<input type="Submit" value="Search" class="login-btn btn-primary btn" style="padding-left: 25px;padding-right: 25px;padding-top: 10px;padding-bottom: 10px;">
</form>
</td>
<td width="15%">
<p style="font-size: 14px;color: rgb(119, 119, 119);padding: 0;margin: 0;text-align: right;">
Today's Date
</p>
<p class="heading-sub12" style="padding: 0;margin: 0;">
<?php
date_default_timezone_set('Asia/Kolkata');
$date = date('Y-m-d');
echo $date;
?>
</p>
</td>
<td width="10%">
<button class="btn-label" style="display: flex;justify-content: center;align-items: center;"><img src="../img/calendar.svg" width="100%"></button>
</td>
</tr>
<tr >
<td colspan="2" style="padding-top:30px;">
<p class="heading-main12" style="margin-left: 45px;font-size:20px;color:rgb(49, 49, 49)">Add New Doctor</p>
</td>
<td colspan="2">
<a href="?action=add&id=none&error=0" class="non-style-link"><button class="login-btn btn-primary btn button-icon" style="display: flex;justify-content: center;align-items: center;margin-left:75px;background-image: url('../img/icons/add.svg');">Add New</font></button>
</a></td>
</tr>
<tr>
<td colspan="4" style="padding-top:10px;">
<p class="heading-main12" style="margin-left: 45px;font-size:18px;color:rgb(49, 49, 49)">All Doctors (<?php echo $list11->num_rows; ?>)</p>
</td>
</tr>
<?php
if($_POST){
$keyword=$_POST["search"];
$sqlmain= "select * from doctor where docemail='$keyword' or docname='$keyword' or docname like '$keyword%' or docname like '%$keyword' or docname like '%$keyword%'";
}else{
$sqlmain= "select * from doctor order by docid desc";
}
?>
<tr>
<td colspan="4">
<center>
<div class="abc scroll">
<table width="93%" class="sub-table scrolldown" border="0">
<thead>
<tr>
<th class="table-headin">
Doctor Name
</th>
<th class="table-headin">
Email
</th>
<th class="table-headin">
Specialties
</th>
<th class="table-headin">
Events
</tr>
</thead>
<tbody>
<?php
$result= $database->query($sqlmain);
if($result->num_rows==0){
echo '<tr>
<td colspan="4">
<br><br><br><br>
<center>
<img src="../img/notfound.svg" width="25%">
<br>
<p class="heading-main12" style="margin-left: 45px;font-size:20px;color:rgb(49, 49, 49)">We couldnt find anything related to your keywords !</p>
<a class="non-style-link" href="doctors.php"><button class="login-btn btn-primary-soft btn" style="display: flex;justify-content: center;align-items: center;margin-left:20px;"> Show all Doctors </font></button>
</a>
</center>
<br><br><br><br>
</td>
</tr>';
}
else{
for ( $x=0; $x<$result->num_rows;$x++){
$row=$result->fetch_assoc();
$docid=$row["docid"];
$name=$row["docname"];
$email=$row["docemail"];
$spe=$row["specialties"];
$spcil_res= $database->query("select sname from specialties where id='$spe'");
$spcil_array= $spcil_res->fetch_assoc();
$spcil_name=$spcil_array["sname"];
echo '<tr>
<td> '.
substr($name,0,30)
.'</td>
<td>
'.substr($email,0,20).'
</td>
<td>
'.substr($spcil_name,0,20).'
</td>
<td>
<div style="display:flex;justify-content: center;">
<a href="?action=edit&id='.$docid.'&error=0" class="non-style-link"><button class="btn-primary-soft btn button-icon btn-edit" style="padding-left: 40px;padding-top: 12px;padding-bottom: 12px;margin-top: 10px;"><font class="tn-in-text">Edit</font></button></a>
<a href="?action=view&id='.$docid.'" class="non-style-link"><button class="btn-primary-soft btn button-icon btn-view" style="padding-left: 40px;padding-top: 12px;padding-bottom: 12px;margin-top: 10px;"><font class="tn-in-text">View</font></button></a>
<a href="?action=drop&id='.$docid.'&name='.$name.'" class="non-style-link"><button class="btn-primary-soft btn button-icon btn-delete" style="padding-left: 40px;padding-top: 12px;padding-bottom: 12px;margin-top: 10px;"><font class="tn-in-text">Remove</font></button></a>
</div>
</td>
</tr>';
}
}
?>
</tbody>
</table>
</div>
</center>
</td>
</tr>
</table>
</div>
</div>
<?php
if($_GET){
$id=$_GET["id"];
$action=$_GET["action"];
if($action=='drop'){
$nameget=$_GET["name"];
echo '
<div id="popup1" class="overlay">
<div class="popup">
<center>
<h2>Are you sure?</h2>
<a class="close" href="doctors.php">×</a>
<div class="content">
You want to delete this record<br>('.substr($nameget,0,40).').
</div>
<div style="display: flex;justify-content: center;">
<a href="delete-doctor.php?id='.$id.'" class="non-style-link"><button class="btn-primary btn" style="display: flex;justify-content: center;align-items: center;margin:10px;padding:10px;"<font class="tn-in-text"> Yes </font></button></a>
<a href="doctors.php" class="non-style-link"><button class="btn-primary btn" style="display: flex;justify-content: center;align-items: center;margin:10px;padding:10px;"><font class="tn-in-text"> No </font></button></a>
</div>
</center>
</div>
</div>
';
}elseif($action=='view'){
$sqlmain= "select * from doctor where docid='$id'";
$result= $database->query($sqlmain);
$row=$result->fetch_assoc();
$name=$row["docname"];
$email=$row["docemail"];
$spe=$row["specialties"];
$spcil_res= $database->query("select sname from specialties where id='$spe'");
$spcil_array= $spcil_res->fetch_assoc();
$spcil_name=$spcil_array["sname"];
$nic=$row['docnic'];
$tele=$row['doctel'];
echo '
<div id="popup1" class="overlay">
<div class="popup">
<center>
<h2></h2>
<a class="close" href="doctors.php">×</a>
<div class="content">
eDoc Web App<br>
</div>
<div style="display: flex;justify-content: center;">
<table width="80%" class="sub-table scrolldown add-doc-form-container" border="0">
<tr>
<td>
<p style="padding: 0;margin: 0;text-align: left;font-size: 25px;font-weight: 500;">View Details.</p><br><br>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<label for="name" class="form-label">Name: </label>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
'.$name.'<br><br>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<label for="Email" class="form-label">Email: </label>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
'.$email.'<br><br>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<label for="nic" class="form-label">NIC: </label>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
'.$nic.'<br><br>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<label for="Tele" class="form-label">Telephone: </label>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
'.$tele.'<br><br>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<label for="spec" class="form-label">Specialties: </label>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
'.$spcil_name.'<br><br>
</td>
</tr>
<tr>
<td colspan="2">
<a href="doctors.php"><input type="button" value="OK" class="login-btn btn-primary-soft btn" ></a>
</td>
</tr>
</table>
</div>
</center>
<br><br>
</div>
</div>
';
}elseif($action=='add'){
$error_1=$_GET["error"];
$errorlist= array(
'1'=>'<label for="promter" class="form-label" style="color:rgb(255, 62, 62);text-align:center;">Already have an account for this Email address.</label>',
'2'=>'<label for="promter" class="form-label" style="color:rgb(255, 62, 62);text-align:center;">Password Conformation Error! Reconform Password</label>',
'3'=>'<label for="promter" class="form-label" style="color:rgb(255, 62, 62);text-align:center;"></label>',
'4'=>"",
'0'=>'',
);
if($error_1!='4'){
echo '
<div id="popup1" class="overlay">
<div class="popup">
<center>
<a class="close" href="doctors.php">×</a>
<div style="display: flex;justify-content: center;">
<div class="abc">
<table width="80%" class="sub-table scrolldown add-doc-form-container" border="0">
<tr>
<td class="label-td" colspan="2">'.
$errorlist[$error_1]
.'</td>
</tr>
<tr>
<td>
<p style="padding: 0;margin: 0;text-align: left;font-size: 25px;font-weight: 500;">Add New Doctor.</p><br><br>
</td>
</tr>
<tr>
<form action="add-new.php" method="POST" class="add-new-form">
<td class="label-td" colspan="2">
<label for="name" class="form-label">Name: </label>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<input type="text" name="name" class="input-text" placeholder="Doctor Name" required><br>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<label for="Email" class="form-label">Email: </label>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<input type="email" name="email" class="input-text" placeholder="Email Address" required><br>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<label for="nic" class="form-label">NIC: </label>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<input type="text" name="nic" class="input-text" placeholder="NIC Number" required><br>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<label for="Tele" class="form-label">Telephone: </label>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<input type="tel" name="Tele" class="input-text" placeholder="Telephone Number" required><br>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<label for="spec" class="form-label">Choose specialties: </label>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<select name="spec" id="" class="box" >';
$list11 = $database->query("select * from specialties order by sname asc;");
for ($y=0;$y<$list11->num_rows;$y++){
$row00=$list11->fetch_assoc();
$sn=$row00["sname"];
$id00=$row00["id"];
echo "<option value=".$id00.">$sn</option><br/>";
};
echo ' </select><br>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<label for="password" class="form-label">Password: </label>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<input type="password" name="password" class="input-text" placeholder="Defind a Password" required><br>
</td>
</tr><tr>
<td class="label-td" colspan="2">
<label for="cpassword" class="form-label">Conform Password: </label>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<input type="password" name="cpassword" class="input-text" placeholder="Conform Password" required><br>
</td>
</tr>
<tr>
<td colspan="2">
<input type="reset" value="Reset" class="login-btn btn-primary-soft btn" >
<input type="submit" value="Add" class="login-btn btn-primary btn">
</td>
</tr>
</form>
</tr>
</table>
</div>
</div>
</center>
<br><br>
</div>
</div>
';
}else{
echo '
<div id="popup1" class="overlay">
<div class="popup">
<center>
<br><br><br><br>
<h2>New Record Added Successfully!</h2>
<a class="close" href="doctors.php">×</a>
<div class="content">
</div>
<div style="display: flex;justify-content: center;">
<a href="doctors.php" class="non-style-link"><button class="btn-primary btn" style="display: flex;justify-content: center;align-items: center;margin:10px;padding:10px;"><font class="tn-in-text"> OK </font></button></a>
</div>
<br><br>
</center>
</div>
</div>
';
}
}elseif($action=='edit'){
$sqlmain= "select * from doctor where docid='$id'";
$result= $database->query($sqlmain);
$row=$result->fetch_assoc();
$name=$row["docname"];
$email=$row["docemail"];
$spe=$row["specialties"];
$spcil_res= $database->query("select sname from specialties where id='$spe'");
$spcil_array= $spcil_res->fetch_assoc();
$spcil_name=$spcil_array["sname"];
$nic=$row['docnic'];
$tele=$row['doctel'];
$error_1=$_GET["error"];
$errorlist= array(
'1'=>'<label for="promter" class="form-label" style="color:rgb(255, 62, 62);text-align:center;">Already have an account for this Email address.</label>',
'2'=>'<label for="promter" class="form-label" style="color:rgb(255, 62, 62);text-align:center;">Password Conformation Error! Reconform Password</label>',
'3'=>'<label for="promter" class="form-label" style="color:rgb(255, 62, 62);text-align:center;"></label>',
'4'=>"",
'0'=>'',
);
if($error_1!='4'){
echo '
<div id="popup1" class="overlay">
<div class="popup">
<center>
<a class="close" href="doctors.php">×</a>
<div style="display: flex;justify-content: center;">
<div class="abc">
<table width="80%" class="sub-table scrolldown add-doc-form-container" border="0">
<tr>
<td class="label-td" colspan="2">'.
$errorlist[$error_1]
.'</td>
</tr>
<tr>
<td>
<p style="padding: 0;margin: 0;text-align: left;font-size: 25px;font-weight: 500;">Edit Doctor Details.</p>
Doctor ID : '.$id.' (Auto Generated)<br><br>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<form action="edit-doc.php" method="POST" class="add-new-form">
<label for="Email" class="form-label">Email: </label>
<input type="hidden" value="'.$id.'" name="id00">
<input type="hidden" name="oldemail" value="'.$email.'" >
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<input type="email" name="email" class="input-text" placeholder="Email Address" value="'.$email.'" required><br>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<label for="name" class="form-label">Name: </label>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<input type="text" name="name" class="input-text" placeholder="Doctor Name" value="'.$name.'" required><br>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<label for="nic" class="form-label">NIC: </label>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<input type="text" name="nic" class="input-text" placeholder="NIC Number" value="'.$nic.'" required><br>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<label for="Tele" class="form-label">Telephone: </label>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<input type="tel" name="Tele" class="input-text" placeholder="Telephone Number" value="'.$tele.'" required><br>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<label for="spec" class="form-label">Choose specialties: (Current'.$spcil_name.')</label>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<select name="spec" id="" class="box">';
$list11 = $database->query("select * from specialties;");
for ($y=0;$y<$list11->num_rows;$y++){
$row00=$list11->fetch_assoc();
$sn=$row00["sname"];
$id00=$row00["id"];
echo "<option value=".$id00.">$sn</option><br/>";
};
echo ' </select><br><br>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<label for="password" class="form-label">Password: </label>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<input type="password" name="password" class="input-text" placeholder="Defind a Password" required><br>
</td>
</tr><tr>
<td class="label-td" colspan="2">
<label for="cpassword" class="form-label">Conform Password: </label>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<input type="password" name="cpassword" class="input-text" placeholder="Conform Password" required><br>
</td>
</tr>
<tr>
<td colspan="2">
<input type="reset" value="Reset" class="login-btn btn-primary-soft btn" >
<input type="submit" value="Save" class="login-btn btn-primary btn">
</td>
</tr>
</form>
</tr>
</table>
</div>
</div>
</center>
<br><br>
</div>
</div>
';
}else{
echo '
<div id="popup1" class="overlay">
<div class="popup">
<center>
<br><br><br><br>
<h2>Edit Successfully!</h2>
<a class="close" href="doctors.php">×</a>
<div class="content">
</div>
<div style="display: flex;justify-content: center;">
<a href="doctors.php" class="non-style-link"><button class="btn-primary btn" style="display: flex;justify-content: center;align-items: center;margin:10px;padding:10px;"><font class="tn-in-text"> OK </font></button></a>
</div>
<br><br>
</center>
</div>
</div>
';
}; };
};
?>
</div>
</body>
</html>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="stylesheet" href="../css/animations.css">
<link rel="stylesheet" href="../css/main.css">
<link rel="stylesheet" href="../css/admin.css">
<title>Dashboard</title>
<style>
.dashbord-tables{
animation: transitionIn-Y-over 0.5s;
}
.filter-container{
animation: transitionIn-Y-bottom 0.5s;
}
.sub-table{
animation: transitionIn-Y-bottom 0.5s;
}
</style>
</head>
<body>
<?php
session_start();
if(isset($_SESSION["user"])){
if(($_SESSION["user"])=="" or $_SESSION['usertype']!='a'){
header("location: ../login.php");
}
}else{
header("location: ../login.php");
}
//import database
include("../connection.php");
?>
<div class="container">
<div class="menu">
<table class="menu-container" border="0">
<tr>
<td style="padding:10px" colspan="2">
<table border="0" class="profile-container">
<tr>
<td width="30%" style="padding-left:20px" >
<img src="../img/user.png" alt="" width="100%" style="border-radius:50%">
</td>
<td style="padding:0px;margin:0px;">
<p class="profile-title">Administrator</p>
<p class="profile-subtitle">admin@edoc.com</p>
</td>
</tr>
<tr>
<td colspan="2">
<a href="../logout.php" ><input type="button" value="Log out" class="logout-btn btn-primary-soft btn"></a>
</td>
</tr>
</table>
</td>
</tr>
<tr class="menu-row" >
<td class="menu-btn menu-icon-dashbord menu-active menu-icon-dashbord-active" >
<a href="index.php" class="non-style-link-menu non-style-link-menu-active"><div><p class="menu-text">Dashboard</p></a></div></a>
</td>
</tr>
<tr class="menu-row">
<td class="menu-btn menu-icon-doctor ">
<a href="doctors.php" class="non-style-link-menu "><div><p class="menu-text">Doctors</p></a></div>
</td>
</tr>
<tr class="menu-row" >
<td class="menu-btn menu-icon-schedule">
<a href="schedule.php" class="non-style-link-menu"><div><p class="menu-text">Schedule</p></div></a>
</td>
</tr>
<tr class="menu-row">
<td class="menu-btn menu-icon-appoinment">
<a href="appointment.php" class="non-style-link-menu"><div><p class="menu-text">Appointment</p></a></div>
</td>
</tr>
<tr class="menu-row" >
<td class="menu-btn menu-icon-patient">
<a href="patient.php" class="non-style-link-menu"><div><p class="menu-text">Patients</p></a></div>
</td>
</tr>
</table>
</div>
<div class="dash-body" style="margin-top: 15px">
<table border="0" width="100%" style=" border-spacing: 0;margin:0;padding:0;" >
<tr >
<td colspan="2" class="nav-bar" >
<form action="doctors.php" method="post" class="header-search">
<input type="search" name="search" class="input-text header-searchbar" placeholder="Search Doctor name or Email" list="doctors">
<?php
echo '<datalist id="doctors">';
$list11 = $database->query("select docname,docemail from doctor;");
for ($y=0;$y<$list11->num_rows;$y++){
$row00=$list11->fetch_assoc();
$d=$row00["docname"];
$c=$row00["docemail"];
echo "<option value='$d'><br/>";
echo "<option value='$c'><br/>";
};
echo ' </datalist>';
?>
<input type="Submit" value="Search" class="login-btn btn-primary-soft btn" style="padding-left: 25px;padding-right: 25px;padding-top: 10px;padding-bottom: 10px;">
</form>
</td>
<td width="15%">
<p style="font-size: 14px;color: rgb(119, 119, 119);padding: 0;margin: 0;text-align: right;">
Today's Date
</p>
<p class="heading-sub12" style="padding: 0;margin: 0;">
<?php
date_default_timezone_set('Asia/Kolkata');
$today = date('Y-m-d');
echo $today;
$patientrow = $database->query("select * from patient;");
$doctorrow = $database->query("select * from doctor;");
$appointmentrow = $database->query("select * from appointment where appodate>='$today';");
$schedulerow = $database->query("select * from schedule where scheduledate='$today';");
?>
</p>
</td>
<td width="10%">
<button class="btn-label" style="display: flex;justify-content: center;align-items: center;"><img src="../img/calendar.svg" width="100%"></button>
</td>
</tr>
<tr>
<td colspan="4">
<center>
<table class="filter-container" style="border: none;" border="0">
<tr>
<td colspan="4">
<p style="font-size: 20px;font-weight:600;padding-left: 12px;">Status</p>
</td>
</tr>
<tr>
<td style="width: 25%;">
<div class="dashboard-items" style="padding:20px;margin:auto;width:95%;display: flex">
<div>
<div class="h1-dashboard">
<?php echo $doctorrow->num_rows ?>
</div><br>
<div class="h3-dashboard">
Doctors
</div>
</div>
<div class="btn-icon-back dashboard-icons" style="background-image: url('../img/icons/doctors-hover.svg');"></div>
</div>
</td>
<td style="width: 25%;">
<div class="dashboard-items" style="padding:20px;margin:auto;width:95%;display: flex;">
<div>
<div class="h1-dashboard">
<?php echo $patientrow->num_rows ?>
</div><br>
<div class="h3-dashboard">
Patients
</div>
</div>
<div class="btn-icon-back dashboard-icons" style="background-image: url('../img/icons/patients-hover.svg');"></div>
</div>
</td>
<td style="width: 25%;">
<div class="dashboard-items" style="padding:20px;margin:auto;width:95%;display: flex; ">
<div>
<div class="h1-dashboard" >
<?php echo $appointmentrow ->num_rows ?>
</div><br>
<div class="h3-dashboard" >
NewBooking
</div>
</div>
<div class="btn-icon-back dashboard-icons" style="margin-left: 0px;background-image: url('../img/icons/book-hover.svg');"></div>
</div>
</td>
<td style="width: 25%;">
<div class="dashboard-items" style="padding:20px;margin:auto;width:95%;display: flex;padding-top:26px;padding-bottom:26px;">
<div>
<div class="h1-dashboard">
<?php echo $schedulerow ->num_rows ?>
</div><br>
<div class="h3-dashboard" style="font-size: 15px">
Today Sessions
</div>
</div>
<div class="btn-icon-back dashboard-icons" style="background-image: url('../img/icons/session-iceblue.svg');"></div>
</div>
</td>
</tr>
</table>
</center>
</td>
</tr>
<tr>
<td colspan="4">
<table width="100%" border="0" class="dashbord-tables">
<tr>
<td>
<p style="padding:10px;padding-left:48px;padding-bottom:0;font-size:23px;font-weight:700;color:var(--primarycolor);">
Upcoming Appointments until Next <?php
echo date("l",strtotime("+1 week"));
?>
</p>
<p style="padding-bottom:19px;padding-left:50px;font-size:15px;font-weight:500;color:#212529e3;line-height: 20px;">
Here's Quick access to Upcoming Appointments until 7 days<br>
More details available in @Appointment section.
</p>
</td>
<td>
<p style="text-align:right;padding:10px;padding-right:48px;padding-bottom:0;font-size:23px;font-weight:700;color:var(--primarycolor);">
Upcoming Sessions until Next <?php
echo date("l",strtotime("+1 week"));
?>
</p>
<p style="padding-bottom:19px;text-align:right;padding-right:50px;font-size:15px;font-weight:500;color:#212529e3;line-height: 20px;">
Here's Quick access to Upcoming Sessions that Scheduled until 7 days<br>
Add,Remove and Many features available in @Schedule section.
</p>
</td>
</tr>
<tr>
<td width="50%">
<center>
<div class="abc scroll" style="height: 200px;">
<table width="85%" class="sub-table scrolldown" border="0">
<thead>
<tr>
<th class="table-headin" style="font-size: 12px;">
Appointment number
</th>
<th class="table-headin">
Patient name
</th>
<th class="table-headin">
Doctor
</th>
<th class="table-headin">
Session
</th>
</tr>
</thead>
<tbody>
<?php
$nextweek=date("Y-m-d",strtotime("+1 week"));
$sqlmain= "select appointment.appoid,schedule.scheduleid,schedule.title,doctor.docname,patient.pname,schedule.scheduledate,schedule.scheduletime,appointment.apponum,appointment.appodate from schedule inner join appointment on schedule.scheduleid=appointment.scheduleid inner join patient on patient.pid=appointment.pid inner join doctor on schedule.docid=doctor.docid where schedule.scheduledate>='$today' and schedule.scheduledate<='$nextweek' order by schedule.scheduledate desc";
$result= $database->query($sqlmain);
if($result->num_rows==0){
echo '<tr>
<td colspan="3">
<br><br><br><br>
<center>
<img src="../img/notfound.svg" width="25%">
<br>
<p class="heading-main12" style="margin-left: 45px;font-size:20px;color:rgb(49, 49, 49)">We couldnt find anything related to your keywords !</p>
<a class="non-style-link" href="appointment.php"><button class="login-btn btn-primary-soft btn" style="display: flex;justify-content: center;align-items: center;margin-left:20px;"> Show all Appointments </font></button>
</a>
</center>
<br><br><br><br>
</td>
</tr>';
}
else{
for ( $x=0; $x<$result->num_rows;$x++){
$row=$result->fetch_assoc();
$appoid=$row["appoid"];
$scheduleid=$row["scheduleid"];
$title=$row["title"];
$docname=$row["docname"];
$scheduledate=$row["scheduledate"];
$scheduletime=$row["scheduletime"];
$pname=$row["pname"];
$apponum=$row["apponum"];
$appodate=$row["appodate"];
echo '<tr>
<td style="text-align:center;font-size:23px;font-weight:500; color: var(--btnnicetext);padding:20px;">
'.$apponum.'
</td>
<td style="font-weight:600;"> '.
substr($pname,0,25)
.'</td >
<td style="font-weight:600;"> '.
substr($docname,0,25)
.'</td >
<td>
'.substr($title,0,15).'
</td>
</tr>';
}
}
?>
</tbody>
</table>
</div>
</center>
</td>
<td width="50%" style="padding: 0;">
<center>
<div class="abc scroll" style="height: 200px;padding: 0;margin: 0;">
<table width="85%" class="sub-table scrolldown" border="0" >
<thead>
<tr>
<th class="table-headin">
Session Title
</th>
<th class="table-headin">
Doctor
</th>
<th class="table-headin">
Sheduled Date & Time
</th>
</tr>
</thead>
<tbody>
<?php
$nextweek=date("Y-m-d",strtotime("+1 week"));
$sqlmain= "select schedule.scheduleid,schedule.title,doctor.docname,schedule.scheduledate,schedule.scheduletime,schedule.nop from schedule inner join doctor on schedule.docid=doctor.docid where schedule.scheduledate>='$today' and schedule.scheduledate<='$nextweek' order by schedule.scheduledate desc";
$result= $database->query($sqlmain);
if($result->num_rows==0){
echo '<tr>
<td colspan="4">
<br><br><br><br>
<center>
<img src="../img/notfound.svg" width="25%">
<br>
<p class="heading-main12" style="margin-left: 45px;font-size:20px;color:rgb(49, 49, 49)">We couldnt find anything related to your keywords !</p>
<a class="non-style-link" href="schedule.php"><button class="login-btn btn-primary-soft btn" style="display: flex;justify-content: center;align-items: center;margin-left:20px;"> Show all Sessions </font></button>
</a>
</center>
<br><br><br><br>
</td>
</tr>';
}
else{
for ( $x=0; $x<$result->num_rows;$x++){
$row=$result->fetch_assoc();
$scheduleid=$row["scheduleid"];
$title=$row["title"];
$docname=$row["docname"];
$scheduledate=$row["scheduledate"];
$scheduletime=$row["scheduletime"];
$nop=$row["nop"];
echo '<tr>
<td style="padding:20px;"> '.
substr($title,0,30)
.'</td>
<td>
'.substr($docname,0,20).'
</td>
<td style="text-align:center;">
'.substr($scheduledate,0,10).' '.substr($scheduletime,0,5).'
</td>
</tr>';
}
}
?>
</tbody>
</table>
</div>
</center>
</td>
</tr>
<tr>
<td>
<center>
<a href="appointment.php" class="non-style-link"><button class="btn-primary btn" style="width:85%">Show all Appointments</button></a>
</center>
</td>
<td>
<center>
<a href="schedule.php" class="non-style-link"><button class="btn-primary btn" style="width:85%">Show all Sessions</button></a>
</center>
</td>
</tr>
</table>
</td>
</tr>
</table>
</center>
</td>
</tr>
</table>
</div>
</div>
</body>
</html>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="stylesheet" href="../css/animations.css">
<link rel="stylesheet" href="../css/main.css">
<link rel="stylesheet" href="../css/admin.css">
<title>Schedule</title>
<style>
.popup{
animation: transitionIn-Y-bottom 0.5s;
}
.sub-table{
animation: transitionIn-Y-bottom 0.5s;
}
</style>
</head>
<body>
<?php
session_start();
if(isset($_SESSION["user"])){
if(($_SESSION["user"])=="" or $_SESSION['usertype']!='a'){
header("location: ../login.php");
}
}else{
header("location: ../login.php");
}
//import database
include("../connection.php");
?>
<div class="container">
<div class="menu">
<table class="menu-container" border="0">
<tr>
<td style="padding:10px" colspan="2">
<table border="0" class="profile-container">
<tr>
<td width="30%" style="padding-left:20px" >
<img src="../img/user.png" alt="" width="100%" style="border-radius:50%">
</td>
<td style="padding:0px;margin:0px;">
<p class="profile-title">Administrator</p>
<p class="profile-subtitle">admin@edoc.com</p>
</td>
</tr>
<tr>
<td colspan="2">
<a href="../logout.php" ><input type="button" value="Log out" class="logout-btn btn-primary-soft btn"></a>
</td>
</tr>
</table>
</td>
</tr>
<tr class="menu-row" >
<td class="menu-btn menu-icon-dashbord" >
<a href="index.php" class="non-style-link-menu"><div><p class="menu-text">Dashboard</p></a></div></a>
</td>
</tr>
<tr class="menu-row">
<td class="menu-btn menu-icon-doctor ">
<a href="doctors.php" class="non-style-link-menu "><div><p class="menu-text">Doctors</p></a></div>
</td>
</tr>
<tr class="menu-row" >
<td class="menu-btn menu-icon-schedule menu-active menu-icon-schedule-active">
<a href="schedule.php" class="non-style-link-menu non-style-link-menu-active"><div><p class="menu-text">Schedule</p></div></a>
</td>
</tr>
<tr class="menu-row">
<td class="menu-btn menu-icon-appoinment">
<a href="appointment.php" class="non-style-link-menu"><div><p class="menu-text">Appointment</p></a></div>
</td>
</tr>
<tr class="menu-row" >
<td class="menu-btn menu-icon-patient">
<a href="patient.php" class="non-style-link-menu"><div><p class="menu-text">Patients</p></a></div>
</td>
</tr>
</table>
</div>
<div class="dash-body">
<table border="0" width="100%" style=" border-spacing: 0;margin:0;padding:0;margin-top:25px; ">
<tr >
<td width="13%" >
<a href="schedule.php" ><button class="login-btn btn-primary-soft btn btn-icon-back" style="padding-top:11px;padding-bottom:11px;margin-left:20px;width:125px"><font class="tn-in-text">Back</font></button></a>
</td>
<td>
<p style="font-size: 23px;padding-left:12px;font-weight: 600;">Shedule Manager</p>
</td>
<td width="15%">
<p style="font-size: 14px;color: rgb(119, 119, 119);padding: 0;margin: 0;text-align: right;">
Today's Date
</p>
<p class="heading-sub12" style="padding: 0;margin: 0;">
<?php
date_default_timezone_set('Asia/Kolkata');
$today = date('Y-m-d');
echo $today;
$list110 = $database->query("select * from schedule;");
?>
</p>
</td>
<td width="10%">
<button class="btn-label" style="display: flex;justify-content: center;align-items: center;"><img src="../img/calendar.svg" width="100%"></button>
</td>
</tr>
<tr>
<td colspan="4" >
<div style="display: flex;margin-top: 40px;">
<div class="heading-main12" style="margin-left: 45px;font-size:20px;color:rgb(49, 49, 49);margin-top: 5px;">Schedule a Session</div>
<a href="?action=add-session&id=none&error=0" class="non-style-link"><button class="login-btn btn-primary btn button-icon" style="margin-left:25px;background-image: url('../img/icons/add.svg');">Add a Session</font></button>
</a>
</div>
</td>
</tr>
<tr>
<td colspan="4" style="padding-top:10px;width: 100%;" >
<p class="heading-main12" style="margin-left: 45px;font-size:18px;color:rgb(49, 49, 49)">All Sessions (<?php echo $list110->num_rows; ?>)</p>
</td>
</tr>
<tr>
<td colspan="4" style="padding-top:0px;width: 100%;" >
<center>
<table class="filter-container" border="0" >
<tr>
<td width="10%">
</td>
<td width="5%" style="text-align: center;">
Date:
</td>
<td width="30%">
<form action="" method="post">
<input type="date" name="sheduledate" id="date" class="input-text filter-container-items" style="margin: 0;width: 95%;">
</td>
<td width="5%" style="text-align: center;">
Doctor:
</td>
<td width="30%">
<select name="docid" id="" class="box filter-container-items" style="width:90% ;height: 37px;margin: 0;" >
<option value="" disabled selected hidden>Choose Doctor Name from the list</option><br/>
<?php
$list11 = $database->query("select * from doctor order by docname asc;");
for ($y=0;$y<$list11->num_rows;$y++){
$row00=$list11->fetch_assoc();
$sn=$row00["docname"];
$id00=$row00["docid"];
echo "<option value=".$id00.">$sn</option><br/>";
};
?>
</select>
</td>
<td width="12%">
<input type="submit" name="filter" value=" Filter" class=" btn-primary-soft btn button-icon btn-filter" style="padding: 15px; margin :0;width:100%">
</form>
</td>
</tr>
</table>
</center>
</td>
</tr>
<?php
if($_POST){
//print_r($_POST);
$sqlpt1="";
if(!empty($_POST["sheduledate"])){
$sheduledate=$_POST["sheduledate"];
$sqlpt1=" schedule.scheduledate='$sheduledate' ";
}
$sqlpt2="";
if(!empty($_POST["docid"])){
$docid=$_POST["docid"];
$sqlpt2=" doctor.docid=$docid ";
}
//echo $sqlpt2;
//echo $sqlpt1;
$sqlmain= "select schedule.scheduleid,schedule.title,doctor.docname,schedule.scheduledate,schedule.scheduletime,schedule.nop from schedule inner join doctor on schedule.docid=doctor.docid ";
$sqllist=array($sqlpt1,$sqlpt2);
$sqlkeywords=array(" where "," and ");
$key2=0;
foreach($sqllist as $key){
if(!empty($key)){
$sqlmain.=$sqlkeywords[$key2].$key;
$key2++;
};
};
}else{
$sqlmain= "select schedule.scheduleid,schedule.title,doctor.docname,schedule.scheduledate,schedule.scheduletime,schedule.nop from schedule inner join doctor on schedule.docid=doctor.docid order by schedule.scheduledate desc";
}
?>
<tr>
<td colspan="4">
<center>
<div class="abc scroll">
<table width="93%" class="sub-table scrolldown" border="0">
<thead>
<tr>
<th class="table-headin">
Session Title
</th>
<th class="table-headin">
Doctor
</th>
<th class="table-headin">
Sheduled Date & Time
</th>
<th class="table-headin">
Max num that can be booked
</th>
<th class="table-headin">
Events
</tr>
</thead>
<tbody>
<?php
$result= $database->query($sqlmain);
if($result->num_rows==0){
echo '<tr>
<td colspan="4">
<br><br><br><br>
<center>
<img src="../img/notfound.svg" width="25%">
<br>
<p class="heading-main12" style="margin-left: 45px;font-size:20px;color:rgb(49, 49, 49)">We couldnt find anything related to your keywords !</p>
<a class="non-style-link" href="schedule.php"><button class="login-btn btn-primary-soft btn" style="display: flex;justify-content: center;align-items: center;margin-left:20px;"> Show all Sessions </font></button>
</a>
</center>
<br><br><br><br>
</td>
</tr>';
}
else{
for ( $x=0; $x<$result->num_rows;$x++){
$row=$result->fetch_assoc();
$scheduleid=$row["scheduleid"];
$title=$row["title"];
$docname=$row["docname"];
$scheduledate=$row["scheduledate"];
$scheduletime=$row["scheduletime"];
$nop=$row["nop"];
echo '<tr>
<td> '.
substr($title,0,30)
.'</td>
<td>
'.substr($docname,0,20).'
</td>
<td style="text-align:center;">
'.substr($scheduledate,0,10).' '.substr($scheduletime,0,5).'
</td>
<td style="text-align:center;">
'.$nop.'
</td>
<td>
<div style="display:flex;justify-content: center;">
<a href="?action=view&id='.$scheduleid.'" class="non-style-link"><button class="btn-primary-soft btn button-icon btn-view" style="padding-left: 40px;padding-top: 12px;padding-bottom: 12px;margin-top: 10px;"><font class="tn-in-text">View</font></button></a>
<a href="?action=drop&id='.$scheduleid.'&name='.$title.'" class="non-style-link"><button class="btn-primary-soft btn button-icon btn-delete" style="padding-left: 40px;padding-top: 12px;padding-bottom: 12px;margin-top: 10px;"><font class="tn-in-text">Remove</font></button></a>
</div>
</td>
</tr>';
}
}
?>
</tbody>
</table>
</div>
</center>
</td>
</tr>
</table>
</div>
</div>
<?php
if($_GET){
$id=$_GET["id"];
$action=$_GET["action"];
if($action=='add-session'){
echo '
<div id="popup1" class="overlay">
<div class="popup">
<center>
<a class="close" href="schedule.php">×</a>
<div style="display: flex;justify-content: center;">
<div class="abc">
<table width="80%" class="sub-table scrolldown add-doc-form-container" border="0">
<tr>
<td class="label-td" colspan="2">'.
""
.'</td>
</tr>
<tr>
<td>
<p style="padding: 0;margin: 0;text-align: left;font-size: 25px;font-weight: 500;">Add New Session.</p><br>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<form action="add-session.php" method="POST" class="add-new-form">
<label for="title" class="form-label">Session Title : </label>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<input type="text" name="title" class="input-text" placeholder="Name of this Session" required><br>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<label for="docid" class="form-label">Select Doctor: </label>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<select name="docid" id="" class="box" >
<option value="" disabled selected hidden>Choose Doctor Name from the list</option><br/>';
$list11 = $database->query("select * from doctor order by docname asc;");
for ($y=0;$y<$list11->num_rows;$y++){
$row00=$list11->fetch_assoc();
$sn=$row00["docname"];
$id00=$row00["docid"];
echo "<option value=".$id00.">$sn</option><br/>";
};
echo ' </select><br><br>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<label for="nop" class="form-label">Number of Patients/Appointment Numbers : </label>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<input type="number" name="nop" class="input-text" min="0" placeholder="The final appointment number for this session depends on this number" required><br>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<label for="date" class="form-label">Session Date: </label>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<input type="date" name="date" class="input-text" min="'.date('Y-m-d').'" required><br>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<label for="time" class="form-label">Schedule Time: </label>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<input type="time" name="time" class="input-text" placeholder="Time" required><br>
</td>
</tr>
<tr>
<td colspan="2">
<input type="reset" value="Reset" class="login-btn btn-primary-soft btn" >
<input type="submit" value="Place this Session" class="login-btn btn-primary btn" name="shedulesubmit">
</td>
</tr>
</form>
</tr>
</table>
</div>
</div>
</center>
<br><br>
</div>
</div>
';
}elseif($action=='session-added'){
$titleget=$_GET["title"];
echo '
<div id="popup1" class="overlay">
<div class="popup">
<center>
<br><br>
<h2>Session Placed.</h2>
<a class="close" href="schedule.php">×</a>
<div class="content">
'.substr($titleget,0,40).' was scheduled.<br><br>
</div>
<div style="display: flex;justify-content: center;">
<a href="schedule.php" class="non-style-link"><button class="btn-primary btn" style="display: flex;justify-content: center;align-items: center;margin:10px;padding:10px;"><font class="tn-in-text"> OK </font></button></a>
<br><br><br><br>
</div>
</center>
</div>
</div>
';
}elseif($action=='drop'){
$nameget=$_GET["name"];
echo '
<div id="popup1" class="overlay">
<div class="popup">
<center>
<h2>Are you sure?</h2>
<a class="close" href="schedule.php">×</a>
<div class="content">
You want to delete this record<br>('.substr($nameget,0,40).').
</div>
<div style="display: flex;justify-content: center;">
<a href="delete-session.php?id='.$id.'" class="non-style-link"><button class="btn-primary btn" style="display: flex;justify-content: center;align-items: center;margin:10px;padding:10px;"<font class="tn-in-text"> Yes </font></button></a>
<a href="schedule.php" class="non-style-link"><button class="btn-primary btn" style="display: flex;justify-content: center;align-items: center;margin:10px;padding:10px;"><font class="tn-in-text"> No </font></button></a>
</div>
</center>
</div>
</div>
';
}elseif($action=='view'){
$sqlmain= "select schedule.scheduleid,schedule.title,doctor.docname,schedule.scheduledate,schedule.scheduletime,schedule.nop from schedule inner join doctor on schedule.docid=doctor.docid where schedule.scheduleid=$id";
$result= $database->query($sqlmain);
$row=$result->fetch_assoc();
$docname=$row["docname"];
$scheduleid=$row["scheduleid"];
$title=$row["title"];
$scheduledate=$row["scheduledate"];
$scheduletime=$row["scheduletime"];
$nop=$row['nop'];
$sqlmain12= "select * from appointment inner join patient on patient.pid=appointment.pid inner join schedule on schedule.scheduleid=appointment.scheduleid where schedule.scheduleid=$id;";
$result12= $database->query($sqlmain12);
echo '
<div id="popup1" class="overlay">
<div class="popup" style="width: 70%;">
<center>
<h2></h2>
<a class="close" href="schedule.php">×</a>
<div class="content">
</div>
<div class="abc scroll" style="display: flex;justify-content: center;">
<table width="80%" class="sub-table scrolldown add-doc-form-container" border="0">
<tr>
<td>
<p style="padding: 0;margin: 0;text-align: left;font-size: 25px;font-weight: 500;">View Details.</p><br><br>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<label for="name" class="form-label">Session Title: </label>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
'.$title.'<br><br>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<label for="Email" class="form-label">Doctor of this session: </label>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
'.$docname.'<br><br>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<label for="nic" class="form-label">Scheduled Date: </label>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
'.$scheduledate.'<br><br>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<label for="Tele" class="form-label">Scheduled Time: </label>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
'.$scheduletime.'<br><br>
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<label for="spec" class="form-label"><b>Patients that Already registerd for this session:</b> ('.$result12->num_rows."/".$nop.')</label>
<br><br>
</td>
</tr>
<tr>
<td colspan="4">
<center>
<div class="abc scroll">
<table width="100%" class="sub-table scrolldown" border="0">
<thead>
<tr>
<th class="table-headin">
Patient ID
</th>
<th class="table-headin">
Patient name
</th>
<th class="table-headin">
Appointment number
</th>
<th class="table-headin">
Patient Telephone
</th>
</thead>
<tbody>';
$result= $database->query($sqlmain12);
if($result->num_rows==0){
echo '<tr>
<td colspan="7">
<br><br><br><br>
<center>
<img src="../img/notfound.svg" width="25%">
<br>
<p class="heading-main12" style="margin-left: 45px;font-size:20px;color:rgb(49, 49, 49)">We couldnt find anything related to your keywords !</p>
<a class="non-style-link" href="appointment.php"><button class="login-btn btn-primary-soft btn" style="display: flex;justify-content: center;align-items: center;margin-left:20px;"> Show all Appointments </font></button>
</a>
</center>
<br><br><br><br>
</td>
</tr>';
}
else{
for ( $x=0; $x<$result->num_rows;$x++){
$row=$result->fetch_assoc();
$apponum=$row["apponum"];
$pid=$row["pid"];
$pname=$row["pname"];
$ptel=$row["ptel"];
echo '<tr style="text-align:center;">
<td>
'.substr($pid,0,15).'
</td>
<td style="font-weight:600;padding:25px">'.
substr($pname,0,25)
.'</td >
<td style="text-align:center;font-size:23px;font-weight:500; color: var(--btnnicetext);">
'.$apponum.'
</td>
<td>
'.substr($ptel,0,25).'
</td>
</tr>';
}
}
echo '</tbody>
</table>
</div>
</center>
</td>
</tr>
</table>
</div>
</center>
<br><br>
</div>
</div>
';
}
}
?>
</div>
</body>
</html>
These are the basic modules we require to make our HMS Project , you can add some more exiting features using your own new idea as well.
Coding phase is the most important and time consuming phase after this phase we will be having a source code for our project and it will be through for testing phase.
Hospital Management System Project in Software Development
Hospital Management System (HMS) is one of the most common software development projects. In this article, we will make the Hospital Management System software development project, from scratch, for final-year students. We will cover all the steps you must do while developing this project.
Table of Content
- Step 1- Team Formation Phase: Creating a Dynamic Team
- Step 2- Topic Selection
- Step 3- Project Synopsys for Hospital Management System
- Step 4- Requirement Gathering (Creating SRS for Hospital Management System)
- Software Requirement Specification (SRS) Document | Hospital Management System
- 4.1 SRS (Hospital Management System) | Introduction:
- 4.2 SRS (Hospital Management System) | Overall Description:
- 4.2.3 Class Diagram of Library Management System:
- 4.3 SRS (Hospital Management System) | Designing Hospital Management System:
- 4.3.1 Use case Diagram for Hospital Management System:
- 4.3.2 ER Model of Hospital Management System:
- 4.3.3 Data Flow Diagram of Hospital Management System
- 4.3.4 Sequence Diagram of Hospital Management System
- 4.3.5 Activity Diagram of Hospital Management System
- 4.4 Functional Requirements | SRS (Hospital Management System)
- 4.5 Non Functional Requirements | SRS (Hospital Management System)
- 5. Coding or Implementation of Hospital Mangement System
- 5.1 Implementing Hospital Management System | Environment Creation:
- 5.2 Implementing Hospital Mangement System | Database Creation:
- 5.3 Implementing Hospital Mangement System | Frontend and Backend Development:
- 5.3.1 Step 1: Creation of Login & Signup page Module:
- 5.3.2 Step 2: Creating Patient Module:
- 5.3.3 Step 3: Creating Doctors Module:
- 5.3.4 Step 4: Creating Admin module
- Step 6- Testing Hospital Management System
- Step 7- Creating Project Presentation on Hospital Management System:
- Check Out Some Other CS Relate Projects down below:
Project Development is a multiphase process in which every process is equally important. Here in this post, we are also going to develop our Hospital Management System Project in multiple phases, such as:
- Team Formation
- Topic Selection
- Creating Project Synopsys
- Requirement Gathering
- Coding or Implementation
- Testing
- Project Presentation
Let us look into the steps one by one.
Contact Us