D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home
/
u384067285
/
domains
/
cauldronsisterss.com
/
public_html
/
admin
/
Filename :
dashboard.php
back
Copy
<?php session_start(); error_reporting(0); include 'connection.php'; if (strlen($_SESSION['bpmsaid'] == 0)) { header("Location: logout.php"); } ?> <!DOCTYPE html> <html lang="en"> <head> <!-- Required meta tags --> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no"> <title>Cauldron Sisterss | Dashboard</title> <!-- plugins:css --> <link rel="stylesheet" href="vendors/feather/feather.css"> <link rel="stylesheet" href="vendors/mdi/css/materialdesignicons.min.css"> <link rel="stylesheet" href="vendors/ti-icons/css/themify-icons.css"> <link rel="stylesheet" href="vendors/typicons/typicons.css"> <link rel="stylesheet" href="vendors/simple-line-icons/css/simple-line-icons.css"> <link rel="stylesheet" href="vendors/css/vendor.bundle.base.css"> <!-- endinject --> <!-- Plugin css for this page --> <link rel="stylesheet" href="vendors/datatables.net-bs4/dataTables.bootstrap4.html"> <link rel="stylesheet" href="js/select.dataTables.min.css"> <!-- End plugin css for this page --> <!-- inject:css --> <link rel="stylesheet" href="css/vertical-layout-light/style.css"> <!-- endinject --> <?php include 'favicon.php'; ?> </head> <body> <div class="container-scroller"> <!-- partial:partials/_navbar.php --> <?php include 'header.php'; ?> <!-- partial --> <div class="container-fluid page-body-wrapper"> <!-- partial:partials/_sidebar.php --> <?php include 'sidebar.php'; ?> <!-- partial --> <div class="main-panel"> <div class="content-wrapper"> <div class="row"> <div class="col-sm-12"> <div class="home-tab"> <div class="d-sm-flex align-items-center justify-content-between border-bottom"> <ul class="nav nav-tabs" role="tablist"> <li class="nav-item"> <a class="nav-link active ps-0" id="home-tab" data-bs-toggle="tab" href="#overview" role="tab" aria-controls="overview" aria-selected="true">Overview</a> </li> <li class="nav-item"> <a class="nav-link" href="gallery.php">Gallery</a> </li> <!-- <li class="nav-item"> <a class="nav-link" href="blog.php">Blog</a> </li> --> <li class="nav-item"> <a class="nav-link" href="media.php">Media Coverage</a> </li> </ul> <div> <div class="btn-wrapper"> <a href="customers_contact.php" class="btn btn-otline-dark"> <i class="icon-user"></i> Customers</a> <a href="logout.php" class="btn btn-primary text-white me-0"> <i class="menu-icon mdi mdi-logout"></i> Logout</a> </div> </div> </div> <div class="tab-content tab-content-basic"> <div class="tab-pane fade show active" id="overview" role="tabpanel" aria-labelledby="overview"> <div class="row"> <div class="col-sm-12"> <div class="statistics-details d-flex align-items-center justify-content-between"> <div> <?php $query1 = mysqli_query($conn,"Select * from tblcontact"); $totalcontact = mysqli_num_rows($query1); ?> <p class="statistics-title">Total Customers</p> <h3 class="rate-percentage"> <?php echo $totalcontact; ?> </h3> <p class="text-danger d-flex"><i class="mdi mdi-account-multiple"></i></p> </div> <div> <?php $query1 = mysqli_query($conn,"Select * from tblmediacoverage"); $totalcat = mysqli_num_rows($query1); ?> <p class="statistics-title">Media Coverage</p> <h3 class="rate-percentage"> <?php echo $totalcat; ?> </h3> <p class="text-danger d-flex"><i class="mdi mdi-view-module"></i></p> </div> <div> <?php $query1 = mysqli_query($conn,"Select * from tblgallery"); $totalrec = mysqli_num_rows($query1); ?> <p class="statistics-title">Gallery</p> <h3 class="rate-percentage"> <?php echo $totalrec; ?> </h3> <p class="text-success d-flex"><i class="mdi mdi-food"></i></p> </div> <div class="d-none d-md-block"> <?php $query1 = mysqli_query($conn,"Select * from tblpost"); $totalbook = mysqli_num_rows($query1); ?> <p class="statistics-title">Total Blog Post</p> <h3 class="rate-percentage"> <?php echo $totalbook; ?> </h3> <p class="text-success d-flex"><i class="mdi mdi-book-open-page-variant"></i></p> </div> <div class="d-none d-md-block"> <p class="statistics-title">Current Date</p> <h3 class="rate-percentage"> <?php $today = date('Y-m-d'); echo $today; ?> </h3> <p class="text-danger d-flex"><i class="mdi mdi-watch"></i></p> </div> </div> </div> </div> <div class="row"> <div class="col-lg-12 d-flex flex-column"> <div class="row flex-grow"> <div class="col-12 grid-margin stretch-card"> <div class="card card-rounded"> <div class="card-body"> <div class="d-sm-flex justify-content-between align-items-start"> <div> <h4 class="card-title card-title-dash">Customers Requests</h4> <?php $query1 = mysqli_query($conn,"Select * from tblcontact"); $totalrec = mysqli_num_rows($query1); ?> <p class="card-subtitle card-subtitle-dash">You have <?php echo $totalrec; ?> Message</p> </div> <div> <a href = "gallery.php" class="btn btn-primary btn-lg text-white mb-0 me-0" type="button"> <i class="mdi mdi-food"></i>Upload Gallery Image</a> </div> </div> <div class="table-responsive mt-1"> <table class="table table-hover"> <thead> <tr> <th>#</th> <th>Customer Name</th> <th>Email</th> <th>Mobile</th> <th>Message</th> <th>Action</th> </tr> </thead> <tbody> <?php $sql = "SELECT * FROM tblcontact"; $result = $conn->query($sql); $cnt = 1; while ($row = mysqli_fetch_array($result)) { ?> <tr> <td><?php echo $cnt; ?></td> <td><?php echo $row['customer_name']; ?></td> <td><?php echo $row['customer_email']; ?></td> <td><?php echo $row['customer_mobile']; ?></td> <td><?php echo $row['customer_message']; ?></td> <td> <label class="badge badge-warning"> <a href = "edit_customers_contact.php?editid=<?php echo $row['customer_email']; ?>" style="text-decoration:none; color:black;">Edit</a> </label> <label class="badge badge-danger"> <a href = "delete_customers_contact.php?id=<?php echo $row['customer_email']; ?>" style="text-decoration:none; color:black;">Delete</a> </label> </td> </tr> <?php $cnt = $cnt +1; } ?> </tbody> </table> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> <!-- content-wrapper ends --> <!-- partial:partials/_footer.html --> <?php include 'footer.php'; ?> <!-- partial --> </div> <!-- main-panel ends --> </div> <!-- page-body-wrapper ends --> </div> <!-- container-scroller --> <!-- plugins:js --> <script src="vendors/js/vendor.bundle.base.js"></script> <!-- endinject --> <!-- Plugin js for this page --> <script src="vendors/chart.js/Chart.min.js"></script> <script src="vendors/bootstrap-datepicker/bootstrap-datepicker.min.js"></script> <script src="vendors/progressbar.js/progressbar.min.js"></script> <!-- End plugin js for this page --> <!-- inject:js --> <script src="js/off-canvas.js"></script> <script src="js/hoverable-collapse.js"></script> <script src="js/template.js"></script> <script src="js/settings.js"></script> <script src="js/todolist.js"></script> <!-- endinject --> <!-- Custom js for this page--> <script src="js/jquery.cookie.js" type="text/javascript"></script> <script src="js/dashboard.js"></script> <script src="js/Chart.roundedBarCharts.js"></script> <!-- End custom js for this page--> </body> </html>