Viewing file:  doctors.php (8.77 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
include('conn.php');
require_once "auth.php";
$doc = mysqli_query($con,"SELECT * FROM doctor ORDER BY id DESC");
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title><?php include('title.php') ?></title>
<!-- Fav Icon Link -->
<link rel="shortcut icon" type="image/png" href="images/fav.png">
<!-- Bootstrap core CSS -->
<link rel="stylesheet" href="css/bootstrap.min.css">
<!-- themify icons CSS -->
<link rel="stylesheet" href="css/themify-icons.css">
<!-- Animations CSS -->
<link rel="stylesheet" href="css/animate.css">
<!-- Main CSS -->
<link rel="stylesheet" href="css/styles.css">
<link rel="stylesheet" href="css/red.css" id="style_theme">
<link rel="stylesheet" href="css/responsive.css">
<!-- morris charts -->
<link rel="stylesheet" href="charts/css/morris.css">
<!-- jvectormap -->
<link rel="stylesheet" href="css/jquery-jvectormap.css">
<link rel="stylesheet" href="datatable/dataTables.bootstrap4.min.css">
<script src="js/modernizr.min.js"></script>
</head>
<body>
<!-- Color Changer -->
<div class="theme-settings" id="switcher">
<span class="theme-click">
<span class="ti-settings"></span>
</span>
<span class="theme-color theme-default theme-active" data-color="green"></span>
<span class="theme-color theme-blue" data-color="blue"></span>
<span class="theme-color theme-red" data-color="red"></span>
<span class="theme-color theme-violet" data-color="violet"></span>
<span class="theme-color theme-yellow" data-color="yellow"></span>
</div>
<!-- /Color Changer -->
<div class="wrapper">
<!-- Sidebar -->
<?php include('sidebar.php'); ?>
<!-- /Sidebar -->
<!-- Page Content -->
<div id="content">
<!-- Top Navigation -->
<?php include('topbar.php'); ?>
<!-- /Top Navigation -->
<!-- Breadcrumb -->
<!-- Page Title -->
<div class="row no-margin-padding">
<div class="col-md-6">
<h3 class="block-title">Doctors</h3>
</div>
<div class="col-md-6">
<ol class="breadcrumb">
<li class="breadcrumb-item">
<a href="index.php">
<span class="ti-home"></span>
</a>
</li>
<li class="breadcrumb-item">Doctors</li>
<li class="breadcrumb-item active">All Doctors</li>
</ol>
</div>
</div>
<!-- /Page Title -->
<?php
$_GET['delete_id'];
if(isset($_GET['delete_id']))
{
$del = $_GET['delete_id'];
$selectdelete = mysqli_query($con,"SELECT * FROM doctor where id=".$del."");
$selectimg = mysqli_fetch_array($selectdelete);
$path = 'images/doctors/';
$now_delete = unlink($path.$selectimg['img']);
if($now_delete){
$query_delete="DELETE FROM doctor WHERE id='".$_GET['delete_id']."'";
$p = mysqli_query($con, $query_delete);
echo "<script>alert('Deleted Successfully');</script>
<script>window.location.href = 'doctors.php'</script>";
}else{
$query_delete="DELETE FROM doctor WHERE id='".$_GET['delete_id']."'";
$p = mysqli_query($con, $query_delete);
echo "<script>alert('Deleted Successfully');</script>
<script>window.location.href = 'doctors.php'</script>";
}
}
?>
<!-- /Breadcrumb -->
<!-- Main Content -->
<div class="container-fluid">
<div class="row">
<!-- Widget Item -->
<div class="col-md-12">
<div class="widget-area-2 proclinic-box-shadow">
<h3 class="widget-title">Doctors List</h3>
<div class="table-responsive mb-3">
<table class="table table-bordered table-striped">
<thead>
<tr>
<th class="no-sort">
Details
</th>
<th>Doctor ID</th>
<th>Doctor Name</th>
<th>Experience <small>(in Years)</small></th>
<th>Phone</th>
<th>Specialization</th>
</tr>
</thead>
<tbody>
<?php
while($roww = mysqli_fetch_array($doc)) {
$doctorID = $roww['id'];
?>
<tr>
<td>
<button class="btn btn-outline-success" id="expandButton_<?php echo $doctorID; ?>">See Details</button>
<div id="expandedSection_<?php echo $doctorID; ?>" style="display: none;">
<div class="container-fluid">
<div class="row">
<div class="col-md-20" style="width:900px;">
<div class="widget-area-2 proclinic-box-shadow">
<h3 class="widget-title">Doctor Details</h3>
<div class="row no-mp">
<div class="col-md-4">
<div class="card mb-4">
<img class="card-img-top" src="images/doctors/<?php echo $roww['img']; ?>" alt="Card image">
<div class="card-body">
<h4 class="card-title"><?php echo $roww['name']; ?></h4>
<p class="card-text"><?php echo $roww['biography']; ?></p>
<a href="edit_doctor.php?id=<?php echo $roww["id"]; ?>" onclick="return confirm('Are you sure?')" class="btn btn-success mb-2"><i class="fas fa-edit">Edite Doctor</i></a>
<a href="doctors.php?delete_id=<?php echo $roww["id"]; ?>" onclick="return confirm('Are you sure?')" class="btn btn-danger"><i class="fas fa-trash">Delete doctor</i></a>
</div>
</div>
</div>
<div class="col-md-8">
<div class="table-responsive">
<table class="table table-bordered table-striped">
<tbody>
<tr>
<td><strong>Specialization</strong></td>
<td><?php echo $roww['speciallity']; ?></td>
</tr>
<tr>
<td><strong>Experience</strong></td>
<td><?php echo $roww['experience']; ?></td>
</tr>
<tr>
<td><strong>Address</strong></td>
<td><?php echo $roww['address']; ?></td>
</tr>
<tr>
<td><strong>Phone</strong> </td>
<td><?php echo $roww['phone']; ?></td>
</tr>
<tr>
<td><strong>Email</strong></td>
<td><?php echo $roww['email']; ?></td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
<!-- /Widget Item -->
</div>
</div>
</div>
</td>
<td><?php echo $roww['id']; ?></td>
<td><?php echo $roww['name']; ?></td>
<td><?php echo $roww['experience']; ?></td>
<td><?php echo $roww['phone']; ?></td>
<td><?php echo $roww['speciallity']; ?></td>
</tr>
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script>
$(document).ready(function() {
$("#expandButton_<?php echo $doctorID; ?>").click(function() {
$("#expandedSection_<?php echo $doctorID; ?>").toggle();
});
});
</script>
<?php } ?>
</tbody>
</table>
</div>
</div>
</div>
<!-- /Widget Item -->
</div>
</div>
<!-- /Main Content -->
</div>
<!-- /Page Content -->
</div>
<!-- Back to Top -->
<a id="back-to-top" href="#" class="back-to-top">
<span class="ti-angle-up"></span>
</a>
<!-- /Back to Top -->
<!-- Jquery Library-->
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script src="js/jquery-3.2.1.min.js"></script>
<!-- Popper Library-->
<script src="js/popper.min.js"></script>
<!-- Bootstrap Library-->
<script src="js/bootstrap.min.js"></script>
<!-- Datatable -->
<script src="datatable/jquery.dataTables.min.js"></script>
<script src="datatable/dataTables.bootstrap4.min.js"></script>
<!-- Custom Script-->
<script src="js/custom.js"></script>
<script src="js/custom-datatables.js"></script>
</body>
</html>
|