Step 3 Creating Doctors Module
Here are some features in the doctors module:
- View all appointments and also able to cancel the appointments
- View all sessions
- View all the patients
- Settings for doctors profile (Edit account settings, View account setting, Delete account )
Doctor’s dashboard (Homepage):
Appointments page:
Doctor’s sessions page:
Doctor’s my patients page:
Here is the code for doctors Module:
<?php
include("../connection.php");
if($_POST){
$result= $database->query("select * from webuser");
$name=$_POST['name'];
$oldemail=$_POST["oldemail"];
$nic=$_POST['nic'];
$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);
echo $sql1;
$error= '4';
}
}else{
$error='2';
}
}else{
$error='3';
}
header("location: settings.php?action=edit&error=".$error."&id=".$id);
?>
</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>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']!='d'){
header("location: ../login.php");
}else{
$useremail=$_SESSION["user"];
}
}else{
header("location: ../login.php");
}
//import database
include("../connection.php");
$userrow = $database->query("select * from doctor where docemail='$useremail'");
$userfetch=$userrow->fetch_assoc();
$userid= $userfetch["docid"];
$username=$userfetch["docname"];
?>
<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"><?php echo substr($username,0,13) ?>..</p>
<p class="profile-subtitle"><?php echo substr($useremail,0,22) ?></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-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">My Appointments</p></a></div>
</td>
</tr>
<tr class="menu-row" >
<td class="menu-btn menu-icon-session">
<a href="schedule.php" class="non-style-link-menu"><div><p class="menu-text">My Sessions</p></div></a>
</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">My Patients</p></a></div>
</td>
</tr>
<tr class="menu-row" >
<td class="menu-btn menu-icon-settings">
<a href="settings.php" class="non-style-link-menu"><div><p class="menu-text">Settings</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 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 doctor.docid=$userid ");
?>
</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)">My 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="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
$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 doctor.docid=$userid ";
if($_POST){
if(!empty($_POST["sheduledate"])){
$sheduledate=$_POST["sheduledate"];
$sqlmain.=" and schedule.scheduledate='$sheduledate' ";
};
}
?>
<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">
Session Title
</th>
<th class="table-headin" >
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($title,0,15).'
</td>
<td style="text-align:center;;">
'.substr($scheduledate,0,10).' @'.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"];
$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{
$useremail=$_SESSION["user"];
}
}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;");
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">
</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,.doctor-heade{
animation: transitionIn-Y-over 0.5s;
}
.filter-container{
animation: transitionIn-Y-bottom 0.5s;
}
.sub-table,#anim{
animation: transitionIn-Y-bottom 0.5s;
}
.doctor-heade{
animation: transitionIn-Y-over 0.5s;
}
</style>
</head>
<body>
<?php
session_start();
if(isset($_SESSION["user"])){
if(($_SESSION["user"])=="" or $_SESSION['usertype']!='d'){
header("location: ../login.php");
}else{
$useremail=$_SESSION["user"];
}
}else{
header("location: ../login.php");
}
include("../connection.php");
$userrow = $database->query("select * from doctor where docemail='$useremail'");
$userfetch=$userrow->fetch_assoc();
$userid= $userfetch["docid"];
$username=$userfetch["docname"];
?>
<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"><?php echo substr($username,0,13) ?>..</p>
<p class="profile-subtitle"><?php echo substr($useremail,0,22) ?></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-appoinment">
<a href="appointment.php" class="non-style-link-menu"><div><p class="menu-text">My Appointments</p></a></div>
</td>
</tr>
<tr class="menu-row" >
<td class="menu-btn menu-icon-session">
<a href="schedule.php" class="non-style-link-menu"><div><p class="menu-text">My Sessions</p></div></a>
</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">My Patients</p></a></div>
</td>
</tr>
<tr class="menu-row" >
<td class="menu-btn menu-icon-settings">
<a href="settings.php" class="non-style-link-menu"><div><p class="menu-text">Settings</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="1" class="nav-bar" >
<p style="font-size: 23px;padding-left:12px;font-weight: 600;margin-left:20px;"> Dashboard</p>
</td>
<td width="25%">
</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 doctor-header" style="border: none;width:95%" border="0" >
<tr>
<td >
<h3>Welcome!</h3>
<h1><?php echo $username ?>.</h1>
<p>Thanks for joinnig with us. We are always trying to get you a complete service<br>
You can view your dailly schedule, Reach Patients Appointment at home!<br><br>
</p>
<a href="appointment.php" class="non-style-link"><button class="btn-primary btn" style="width:30%">View My Appointments</button></a>
<br>
<br>
</td>
</tr>
</table>
</center>
</td>
</tr>
<tr>
<td colspan="4">
<table border="0" width="100%"">
<tr>
<td width="50%">
<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">
All 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">
All Patients
</div>
</div>
<div class="btn-icon-back dashboard-icons" style="background-image: url('../img/icons/patients-hover.svg');"></div>
</div>
</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 $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:21px;padding-bottom:21px;">
<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>
<td>
<p id="anim" style="font-size: 20px;font-weight:600;padding-left: 40px;">Your Up Coming Sessions until Next week</p>
<center>
<div class="abc scroll" style="height: 250px;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">
Sheduled Date
</th>
<th class="table-headin">
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 style="padding:20px;font-size:13px;">
'.substr($scheduledate,0,10).'
</td>
<td style="text-align:center;">
'.substr($scheduletime,0,5).'
</td>
</tr>';
}
}
?>
</tbody>
</table>
</div>
</center>
</td>
</tr>
</table>
</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>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']!='d'){
header("location: ../login.php");
}else{
$useremail=$_SESSION["user"];
}
}else{
header("location: ../login.php");
}
//import database
include("../connection.php");
$userrow = $database->query("select * from doctor where docemail='$useremail'");
$userfetch=$userrow->fetch_assoc();
$userid= $userfetch["docid"];
$username=$userfetch["docname"];
?>
<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"><?php echo substr($username,0,13) ?>..</p>
<p class="profile-subtitle"><?php echo substr($useremail,0,22) ?></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-appoinment">
<a href="appointment.php" class="non-style-link-menu"><div><p class="menu-text">My Appointments</p></a></div>
</td>
</tr>
<tr class="menu-row" >
<td class="menu-btn menu-icon-session">
<a href="schedule.php" class="non-style-link-menu"><div><p class="menu-text">My Sessions</p></div></a>
</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">My Patients</p></a></div>
</td>
</tr>
<tr class="menu-row" >
<td class="menu-btn menu-icon-settings ">
<a href="settings.php" class="non-style-link-menu"><div><p class="menu-text">Settings</p></a></div>
</td>
</tr>
</table>
</div>
<?php
$selecttype="My";
$current="My patients Only";
if($_POST){
if(isset($_POST["search"])){
$keyword=$_POST["search12"];
$sqlmain= "select * from patient where pemail='$keyword' or pname='$keyword' or pname like '$keyword%' or pname like '%$keyword' or pname like '%$keyword%' ";
$selecttype="my";
}
if(isset($_POST["filter"])){
if($_POST["showonly"]=='all'){
$sqlmain= "select * from patient";
$selecttype="All";
$current="All patients";
}else{
$sqlmain= "select * from appointment inner join patient on patient.pid=appointment.pid inner join schedule on schedule.scheduleid=appointment.scheduleid where schedule.docid=$userid;";
$selecttype="My";
$current="My patients Only";
}
}
}else{
$sqlmain= "select * from appointment inner join patient on patient.pid=appointment.pid inner join schedule on schedule.scheduleid=appointment.scheduleid where schedule.docid=$userid;";
$selecttype="My";
}
?>
<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="search12" class="input-text header-searchbar" placeholder="Search Patient name or Email" list="patient">
<?php
echo '<datalist id="patient">';
$list11 = $database->query($sqlmain);
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" name="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)"><?php echo $selecttype." Patients (".$list11->num_rows.")"; ?></p>
</td>
</tr>
<tr>
<td colspan="4" style="padding-top:0px;width: 100%;" >
<center>
<table class="filter-container" border="0" >
<form action="" method="post">
<td style="text-align: right;">
Show Details About :
</td>
<td width="30%">
<select name="showonly" id="" class="box filter-container-items" style="width:90% ;height: 37px;margin: 0;" >
<option value="" disabled selected hidden><?php echo $current ?></option><br/>
<option value="my">My Patients Only</option><br/>
<option value="all">All Patients</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>
<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>
<!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']!='d'){
header("location: ../login.php");
}else{
$useremail=$_SESSION["user"];
}
}else{
header("location: ../login.php");
}
include("../connection.php");
$userrow = $database->query("select * from doctor where docemail='$useremail'");
$userfetch=$userrow->fetch_assoc();
$userid= $userfetch["docid"];
$username=$userfetch["docname"];
?>
<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"><?php echo substr($username,0,13) ?>..</p>
<p class="profile-subtitle"><?php echo substr($useremail,0,22) ?></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-appoinment ">
<a href="appointment.php" class="non-style-link-menu"><div><p class="menu-text">My Appointments</p></a></div>
</td>
</tr>
<tr class="menu-row" >
<td class="menu-btn menu-icon-session menu-active menu-icon-session-active">
<a href="schedule.php" class="non-style-link-menu non-style-link-menu-active"><div><p class="menu-text">My Sessions</p></div></a>
</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">My Patients</p></a></div>
</td>
</tr>
<tr class="menu-row" >
<td class="menu-btn menu-icon-settings">
<a href="settings.php" class="non-style-link-menu"><div><p class="menu-text">Settings</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;">My Sessions</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 where docid=$userid;");
?>
</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)">My 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="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
$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 doctor.docid=$userid ";
if($_POST){
//print_r($_POST);
$sqlpt1="";
if(!empty($_POST["sheduledate"])){
$sheduledate=$_POST["sheduledate"];
$sqlmain.=" and schedule.scheduledate='$sheduledate' ";
}
}
?>
<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">
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 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">Cancel Session</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="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>
<!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>Settings</title>
<style>
.dashbord-tables{
animation: transitionIn-Y-over 0.5s;
}
.filter-container{
animation: transitionIn-X 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']!='d'){
header("location: ../login.php");
}else{
$useremail=$_SESSION["user"];
}
}else{
header("location: ../login.php");
}
include("../connection.php");
$userrow = $database->query("select * from doctor where docemail='$useremail'");
$userfetch=$userrow->fetch_assoc();
$userid= $userfetch["docid"];
$username=$userfetch["docname"];
?>
<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"><?php echo substr($username,0,13) ?>..</p>
<p class="profile-subtitle"><?php echo substr($useremail,0,22) ?></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-appoinment">
<a href="appointment.php" class="non-style-link-menu"><div><p class="menu-text">My Appointments</p></a></div>
</td>
</tr>
<tr class="menu-row" >
<td class="menu-btn menu-icon-session">
<a href="schedule.php" class="non-style-link-menu"><div><p class="menu-text">My Sessions</p></div></a>
</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">My Patients</p></a></div>
</td>
</tr>
<tr class="menu-row" >
<td class="menu-btn menu-icon-settings menu-active menu-icon-settings-active">
<a href="settings.php" class="non-style-link-menu non-style-link-menu-active"><div><p class="menu-text">Settings</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 width="13%" >
<a href="settings.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;">Settings</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;
$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"> </p>
</td>
</tr>
<tr>
<td style="width: 25%;">
<a href="?action=edit&id=<?php echo $userid ?>&error=0" class="non-style-link">
<div class="dashboard-items setting-tabs" style="padding:20px;margin:auto;width:95%;display: flex">
<div class="btn-icon-back dashboard-icons-setting" style="background-image: url('../img/icons/doctors-hover.svg');"></div>
<div>
<div class="h1-dashboard">
Account Settings
</div><br>
<div class="h3-dashboard" style="font-size: 15px;">
Edit your Account Details & Change Password
</div>
</div>
</div>
</a>
</td>
</tr>
<tr>
<td colspan="4">
<p style="font-size: 5px"> </p>
</td>
</tr>
<tr>
<td style="width: 25%;">
<a href="?action=view&id=<?php echo $userid ?>" class="non-style-link">
<div class="dashboard-items setting-tabs" style="padding:20px;margin:auto;width:95%;display: flex;">
<div class="btn-icon-back dashboard-icons-setting " style="background-image: url('../img/icons/view-iceblue.svg');"></div>
<div>
<div class="h1-dashboard" >
View Account Details
</div><br>
<div class="h3-dashboard" style="font-size: 15px;">
View Personal information About Your Account
</div>
</div>
</div>
</a>
</td>
</tr>
<tr>
<td colspan="4">
<p style="font-size: 5px"> </p>
</td>
</tr>
<tr>
<td style="width: 25%;">
<a href="?action=drop&id=<?php echo $userid.'&name='.$username ?>" class="non-style-link">
<div class="dashboard-items setting-tabs" style="padding:20px;margin:auto;width:95%;display: flex;">
<div class="btn-icon-back dashboard-icons-setting" style="background-image: url('../img/icons/patients-hover.svg');"></div>
<div>
<div class="h1-dashboard" style="color: #ff5050;">
Delete Account
</div><br>
<div class="h3-dashboard" style="font-size: 15px;">
Will Permanently Remove your Account
</div>
</div>
</div>
</a>
</td>
</tr>
</table>
</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="settings.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="settings.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="settings.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="settings.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=='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="settings.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">
</td>
</tr>
<tr>
<td class="label-td" colspan="2">
<input type="hidden" name="oldemail" value="'.$email.'" >
<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="settings.php">×</a>
<div class="content">
If You change your email also Please logout and login again with your new email
</div>
<div style="display: flex;justify-content: center;">
<a href="settings.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>
<a href="../logout.php" class="non-style-link"><button class="btn-primary-soft btn" style="display: flex;justify-content: center;align-items: center;margin:10px;padding:10px;"><font class="tn-in-text"> Log out </font></button></a>
</div>
<br><br>
</center>
</div>
</div>
';
}; }
}
?>
</body>
</html>
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.