| Server IP : 147.93.80.58 / Your IP : 216.73.216.195 Web Server : LiteSpeed System : Linux id-dci-web1866.main-hosting.eu 5.14.0-503.38.1.el9_5.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Apr 18 08:52:10 EDT 2025 x86_64 User : u939086737 ( 939086737) PHP Version : 8.2.28 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 | Sudo : OFF | Pkexec : OFF Directory : /home/u939086737/domains/mishrahometutor.in/public_html/admin/ |
Upload File : |
<?php
ini_set('session.cookie_secure', '1'); // Send cookie only over HTTPS
ini_set('session.cookie_httponly', '1'); // Prevent JavaScript access to session cookie
ini_set('session.use_strict_mode', '1'); // Reject uninitialized session IDs
ini_set('session.cookie_samesite', 'Strict'); // Prevent cross-site request
session_start();
if (!isset($_SESSION['admin_id'])) {
header("Location: ./");
exit;
}
include '../action/config.php';
// Get today's date
$today = date('Y-m-d');
// Query for enquiries
$todayEnquiriesQuery = $pdo->prepare("SELECT COUNT(*) as count FROM enquiries WHERE DATE(enquiry_date) = :today");
$todayEnquiriesQuery->execute([':today' => $today]);
$todayEnquiries = $todayEnquiriesQuery->fetch()['count'];
$totalEnquiriesQuery = $pdo->query("SELECT COUNT(*) as count FROM enquiries");
$totalEnquiries = $totalEnquiriesQuery->fetch()['count'];
// Query for teachers
$todayTeachersQuery = $pdo->prepare("SELECT COUNT(*) as count FROM teachers WHERE DATE(created_at) = :today");
$todayTeachersQuery->execute([':today' => $today]);
$todayTeachers = $todayTeachersQuery->fetch()['count'];
$totalTeachersQuery = $pdo->query("SELECT COUNT(*) as count FROM teachers");
$totalTeachers = $totalTeachersQuery->fetch()['count'];
?>
<!doctype html>
<html lang="en" class="semi-dark">
<head>
<!-- Required meta tags -->
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<!--favicon-->
<link rel="icon" href="assets/images/favicon-32x32.png" type="image/png" />
<!--plugins-->
<link href="assets/plugins/notifications/css/lobibox.min.css" rel="stylesheet" />
<link href="assets/plugins/vectormap/jquery-jvectormap-2.0.2.css" rel="stylesheet" />
<link href="assets/plugins/simplebar/css/simplebar.css" rel="stylesheet" />
<link href="assets/plugins/perfect-scrollbar/css/perfect-scrollbar.css" rel="stylesheet" />
<link href="assets/plugins/metismenu/css/metisMenu.min.css" rel="stylesheet" />
<!-- loader-->
<link href="assets/css/pace.min.css" rel="stylesheet" />
<script src="assets/js/pace.min.js"></script>
<!-- Bootstrap CSS -->
<link href="assets/css/bootstrap.min.css" rel="stylesheet">
<link href="assets/css/bootstrap-extended.css" rel="stylesheet">
<link href="https://fonts.googleapis.com/css2?family=Roboto:wght@400;500&display=swap" rel="stylesheet">
<link href="assets/css/app.css" rel="stylesheet">
<link href="assets/css/icons.css" rel="stylesheet">
<!-- Theme Style CSS -->
<link rel="stylesheet" href="assets/css/dark-theme.css" />
<link rel="stylesheet" href="assets/css/semi-dark.css" />
<link rel="stylesheet" href="assets/css/header-colors.css" />
<title><?= $shop ?></title>
</head>
<body>
<!--wrapper-->
<div class="wrapper">
<?php include './header.php' ?>
<!--start page wrapper -->
<div class="page-wrapper">
<div class="page-content">
<div class="row row-cols-1 row-cols-md-2 row-cols-xl-2 row-cols-xxl-4">
<div class="col">
<div class="card radius-10 bg-gradient-cosmic">
<div class="card-body">
<div class="d-flex align-items-center">
<div class="me-auto">
<p class="mb-0 text-white">Today Enquiry</p>
<h4 class="my-1 text-white"><?= $todayEnquiries; ?></h4>
<p class="mb-0 font-13 text-white">Total Enquiries: <?= $totalEnquiries; ?></p>
</div>
<div><a href="./enquiry" style="font-size: 4rem;"><i class="bx bx-right-arrow-circle"></i></a></div>
</div>
</div>
</div>
</div>
<div class="col">
<div class="card radius-10 bg-gradient-ibiza">
<div class="card-body">
<div class="d-flex align-items-center">
<div class="me-auto">
<p class="mb-0 text-white">Today Tutors Enrollment</p>
<h4 class="my-1 text-white"><?= $todayTeachers; ?></h4>
<p class="mb-0 font-13 text-white">Total Teachers: <?= $totalTeachers; ?></p>
</div>
<div><a href="./tutors" style="font-size: 4rem; color: #800000;"><i class="bx bx-right-arrow-circle"></i></a></div>
</div>
</div>
</div>
</div>
<!-- <div class="col">
<div class="card radius-10 bg-gradient-ohhappiness">
<div class="card-body">
<div class="d-flex align-items-center">
<div class="me-auto">
<p class="mb-0 text-white">Bounce Rate</p>
<h4 class="my-1 text-white">34.6%</h4>
<p class="mb-0 font-13 text-white">-4.5% from last week</p>
</div>
</div>
</div>
</div>
</div>
<div class="col">
<div class="card radius-10 bg-gradient-kyoto">
<div class="card-body">
<div class="d-flex align-items-center">
<div class="me-auto">
<p class="mb-0 text-dark">Total Customers</p>
<h4 class="my-1 text-dark">8.4K</h4>
<p class="mb-0 font-13 text-dark">+8.4% from last week</p>
</div>
</div>
</div>
</div>
</div> -->
</div>
<!-- <div class="card radius-10">
<div class="card-header">
<div class="d-flex align-items-center">
<div>
<h6 class="mb-0">Recent Orders</h6>
</div>
<div class="dropdown ms-auto">
<a class="dropdown-toggle dropdown-toggle-nocaret" href="#" data-bs-toggle="dropdown"><i class='bx bx-dots-horizontal-rounded font-22 text-option'></i>
</a>
</div>
</div>
</div>
<div class="card-body">
<div class="table-responsive">
<table class="table align-middle mb-0">
<thead class="table-light">
<tr>
<th>Product</th>
<th>Photo</th>
<th>Product ID</th>
<th>Status</th>
<th>Amount</th>
<th>Date</th>
<th>Shipping</th>
</tr>
</thead>
<tbody>
<tr>
<td>Iphone 5</td>
<td><img src="assets/images/products/18.png" class="product-img-2" alt="product img"></td>
<td>#9405822</td>
<td><span class="badge bg-gradient-quepal text-white shadow-sm w-100">Paid</span></td>
<td>$1250.00</td>
<td>03 Feb 2020</td>
<td>
<div class="progress" style="height: 5px;">
<div class="progress-bar bg-gradient-quepal" role="progressbar" style="width: 100%"></div>
</div>
</td>
</tr>
<tr>
<td>Earphone GL</td>
<td><img src="assets/images/products/16.png" class="product-img-2" alt="product img"></td>
<td>#8304620</td>
<td><span class="badge bg-gradient-blooker text-white shadow-sm w-100">Pending</span></td>
<td>$1500.00</td>
<td>05 Feb 2020</td>
<td>
<div class="progress" style="height: 5px;">
<div class="progress-bar bg-gradient-blooker" role="progressbar" style="width: 60%"></div>
</div>
</td>
</tr>
<tr>
<td>HD Hand Camera</td>
<td><img src="assets/images/products/19.png" class="product-img-2" alt="product img"></td>
<td>#4736890</td>
<td><span class="badge bg-gradient-bloody text-white shadow-sm w-100">Failed</span></td>
<td>$1400.00</td>
<td>06 Feb 2020</td>
<td>
<div class="progress" style="height: 5px;">
<div class="progress-bar bg-gradient-bloody" role="progressbar" style="width: 70%"></div>
</div>
</td>
</tr>
<tr>
<td>Clasic Shoes</td>
<td><img src="assets/images/products/04.png" class="product-img-2" alt="product img"></td>
<td>#8543765</td>
<td><span class="badge bg-gradient-quepal text-white shadow-sm w-100">Paid</span></td>
<td>$1200.00</td>
<td>14 Feb 2020</td>
<td>
<div class="progress" style="height: 5px;">
<div class="progress-bar bg-gradient-quepal" role="progressbar" style="width: 100%"></div>
</div>
</td>
</tr>
<tr>
<td>Sitting Chair</td>
<td><img src="assets/images/products/11.png" class="product-img-2" alt="product img"></td>
<td>#9629240</td>
<td><span class="badge bg-gradient-blooker text-white shadow-sm w-100">Pending</span></td>
<td>$1500.00</td>
<td>18 Feb 2020</td>
<td>
<div class="progress" style="height: 5px;">
<div class="progress-bar bg-gradient-blooker" role="progressbar" style="width: 60%"></div>
</div>
</td>
</tr>
<tr>
<td>Hand Watch</td>
<td><img src="assets/images/products/17.png" class="product-img-2" alt="product img"></td>
<td>#8506790</td>
<td><span class="badge bg-gradient-bloody text-white shadow-sm w-100">Failed</span></td>
<td>$1800.00</td>
<td>21 Feb 2020</td>
<td>
<div class="progress" style="height: 5px;">
<div class="progress-bar bg-gradient-bloody" role="progressbar" style="width: 40%"></div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</div>
</div> -->
</div>
</div>
<?php include './footer.php' ?>
</div>
<!--end wrapper-->
<!-- Bootstrap JS -->
<script src="assets/js/bootstrap.bundle.min.js"></script>
<!--plugins-->
<script src="assets/js/jquery.min.js"></script>
<script src="assets/plugins/simplebar/js/simplebar.min.js"></script>
<script src="assets/plugins/metismenu/js/metisMenu.min.js"></script>
<script src="assets/plugins/perfect-scrollbar/js/perfect-scrollbar.js"></script>
<script src="assets/plugins/vectormap/jquery-jvectormap-2.0.2.min.js"></script>
<script src="assets/plugins/vectormap/jquery-jvectormap-world-mill-en.js"></script>
<script src="assets/plugins/chartjs/js/chart.js"></script>
<script src="assets/plugins/sparkline-charts/jquery.sparkline.min.js"></script>
<!--notification js -->
<script src="assets/plugins/notifications/js/lobibox.min.js"></script>
<script src="assets/plugins/notifications/js/notifications.min.js"></script>
<script src="assets/js/index3.js"></script>
<!--app JS-->
<script src="assets/js/app.js"></script>
</body>
</html>