|
Server IP : 153.92.220.142 / Your IP : 3.148.239.85 Web Server : LiteSpeed System : Linux nl-srv-web516.main-hosting.eu 4.18.0-513.9.1.lve.el7h.x86_64 #1 SMP Mon Dec 4 13:57:13 UTC 2023 x86_64 User : u444427800 ( 444427800) PHP Version : 8.1.27 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF Directory (0755) : /home/u444427800/domains/aaryashdermajoint.com/public_html/admin/gallery/../ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include "connect.php";
if (empty($_SESSION['admin'])) {
?>
<script>
location.replace('./index.php')
</script>
<?php
}
?>
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-EVSTQN3/azprG1Anm3QDgpJLIm9Nao0Yz1ztcQTwFspd3yD65VohhpuuCOmLASjC" crossorigin="anonymous">
<link rel="icon" href="../image/LIVGASTRO Logo.png">
<title>Admin Panel</title>
</head>
<body>
<?php include("menu.php");?>
<div class="container alert-warning p-4 border rounded">
<h2 class="text-center mt-3 mb-2 text-warning">Offline Consultation</h2>
<div class="d-flex justify-content-end">
<button id="printTable" class="btn btn-success mb-2 btn-sm">Export Table</button>
</div>
<table class="table table-bordered table-warning table-striped" id="table" >
<thead>
<tr>
<th>Sr No.</th>
<th>Name</th>
<th>Email</th>
<th>Moblie</th>
<th>Doctor</th>
<th>Disease</th>
<th>Time</th>
<th>Date</th>
<th>Mode of Consultation</th>
</tr>
</thead>
<tbody>
<?php
$result = $conn->query("SELECT * FROM `bookappointment_query` ");
$i = 1;
if ($result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
?>
<tr>
<td>
<?php echo $i ?>
</td>
<td>
<?php echo $row['person_name'] ?>
</td>
<td>
<?php echo $row['email'] ?>
</td>
<td>
<?php echo $row['mobile'] ?>
</td>
<td>
<?php echo $row['doctor_name'] ?>
</td>
<td>
<?php echo $row['disease'] ?>
</td>
<td>
<?php echo $row['time_slot'] ?>
</td>
<td>
<?php echo date(" d M Y",strtotime($row['date'])) ?>
</td>
<td>
<?php echo $row['doctor_consultation'] ?>
</td>
</tr>
<?php
$i++;
}
} else {
?>
<tr>
<td colspan="10" class="text-center">
<img src="./Assets/noData.jpg" alt="" style="width: 300px;">
</td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.bundle.min.js" integrity="sha384-MrcW6ZMFYlzcLA8Nl+NtUVF0sA7MsXsP1UyJoMp4YLEuNSfAP+JcXn/tWtIaxVXM" crossorigin="anonymous"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.7.0/jquery.min.js" integrity="sha512-3gJwYpMe3QewGELv8k/BX9vcqhryRdzRMxVfq6ngyWXwo03GFEzjsUm8Q7RZcHPHksttq7/GFoxjCVUjkjvPdw==" crossorigin="anonymous" referrerpolicy="no-referrer"></script>
<script src="//cdn.rawgit.com/rainabba/jquery-table2excel/1.1.0/dist/jquery.table2excel.min.js">
</script>
<script src="https://cdn.jsdelivr.net/npm/sweetalert2@11"></script>
<script>
document.getElementById('logout').addEventListener('click', (e) => {
e.preventDefault()
Swal.fire({
title: "Are you sure ?",
text: "You want to logout",
icon: "warning",
confirmButtonColor: "#3085d6",
cancelButtonColor: "#d33",
confirmButtonText: "OK",
showCancelButton: true,
}).then((result) => {
if (result.isConfirmed) {
location.replace('./logout.php');
}
});
})
document.getElementById('printTable').addEventListener('click', (e) => {
$("#table").table2excel({
filename: "contact_users.xls"
});
})
// popup from
const openCloseModal = (show, opacity) => {
document.getElementById("modalFormParent").style.visibility = show;
document.getElementById("modalFormParent").style.opacity = opacity;
};
document.getElementById("open-popup").addEventListener("click", function (e) {
e.preventDefault();
openCloseModal("visible", 1);
document.addEventListener("click", (events) => {
// if(document.getElementById("open-popup").contains(events.target))
if (
!document.getElementById("open-popup").contains(events.target) &&
!document
.getElementById("modalFormParent")
.querySelector(".modalForm")
.contains(events.target)
) {
openCloseModal("hidden", 0);
}
});
document
.getElementById("modalFormParent")
.querySelector(".modalFormClose")
.addEventListener("click", () => {
openCloseModal("hidden", 0);
});
});
</script>
</body>
</html>