📁 File Manager
Editing:
/home/wedigitalindia/www/jaybalajiassociates.com/admin/index.php
<?php include("connection.php"); include("header.php"); ?> <div class="main-content"> <div class="page-content"> <div class="container-fluid"> <!-- Page Title --> <div class="row"> <div class="col-12"> <div class="page-title-box d-sm-flex align-items-center justify-content-between"> <h4 class="mb-sm-0 font-size-18">Dashboard</h4> </div> </div> </div> <!-- End Page Title --> <div class="row"> <!-- SLIDER --> <?php $total_slider = mysqli_fetch_assoc(mysqli_query($con, "SELECT COUNT(*) AS total FROM slider"))['total']; ?> <div class="col-md-3"> <div class="card mini-stats-wid"> <div class="card-body"> <div class="d-flex"> <div class="flex-grow-1"> <a href="viewslider.php"> <p class="text-muted fw-medium">Slider</p> <h4 class="mb-0"><?= $total_slider; ?></h4> </a> </div> <div class="flex-shrink-0 align-self-center"> <div class="avatar-sm rounded-circle mini-stat-icon"> <span class="avatar-title rounded-circle"> <i class="fas fa-sliders-h font-size-24"></i> </span> </div> </div> </div> </div> </div> </div> <!-- TOP CATEGORIES --> <?php $total_topcat = mysqli_fetch_assoc(mysqli_query($con, "SELECT COUNT(*) AS total FROM top_categories"))['total']; ?> <div class="col-md-3"> <div class="card mini-stats-wid"> <div class="card-body"> <div class="d-flex"> <div class="flex-grow-1"> <a href="view_top_categories.php"> <p class="text-muted fw-medium">Top Categories</p> <h4 class="mb-0"><?= $total_topcat; ?></h4> </a> </div> <div class="flex-shrink-0 align-self-center"> <div class="avatar-sm rounded-circle mini-stat-icon"> <span class="avatar-title rounded-circle"> <i class="fas fa-layer-group font-size-24"></i> </span> </div> </div> </div> </div> </div> </div> <!-- PRODUCTS --> <?php $total_products = mysqli_fetch_assoc(mysqli_query($con, "SELECT COUNT(*) AS total FROM products"))['total']; ?> <div class="col-md-3"> <div class="card mini-stats-wid"> <div class="card-body"> <div class="d-flex"> <div class="flex-grow-1"> <a href="viewproducts.php"> <p class="text-muted fw-medium">Product</p> <h4 class="mb-0"><?= $total_products; ?></h4> </a> </div> <div class="flex-shrink-0 align-self-center"> <div class="avatar-sm rounded-circle mini-stat-icon"> <span class="avatar-title rounded-circle"> <i class="fas fa-box-open font-size-24"></i> </span> </div> </div> </div> </div> </div> </div> <!-- CERTIFICATE --> <?php $total_certificate = mysqli_fetch_assoc(mysqli_query($con, "SELECT COUNT(*) AS total FROM certificate"))['total']; ?> <div class="col-md-3"> <div class="card mini-stats-wid"> <div class="card-body"> <div class="d-flex"> <div class="flex-grow-1"> <a href="viewcertificate.php"> <p class="text-muted fw-medium">Certificate</p> <h4 class="mb-0"><?= $total_certificate; ?></h4> </a> </div> <div class="flex-shrink-0 align-self-center"> <div class="avatar-sm rounded-circle mini-stat-icon"> <span class="avatar-title rounded-circle"> <i class="fas fa-certificate font-size-24"></i> </span> </div> </div> </div> </div> </div> </div> <!-- IMAGES / VIDEO (MEDIA) --> <?php $total_media = mysqli_fetch_assoc(mysqli_query($con, "SELECT COUNT(*) AS total FROM media"))['total']; ?> <div class="col-md-3"> <div class="card mini-stats-wid"> <div class="card-body"> <div class="d-flex"> <div class="flex-grow-1"> <a href="viewgallery.php"> <p class="text-muted fw-medium">Images / Video</p> <h4 class="mb-0"><?= $total_media; ?></h4> </a> </div> <div class="flex-shrink-0 align-self-center"> <div class="avatar-sm rounded-circle mini-stat-icon"> <span class="avatar-title rounded-circle"> <i class="fas fa-photo-video font-size-24"></i> </span> </div> </div> </div> </div> </div> </div> <!-- TESTIMONIAL --> <?php $total_testimonial = mysqli_fetch_assoc(mysqli_query($con, "SELECT COUNT(*) AS total FROM testimonial"))['total']; ?> <div class="col-md-3"> <div class="card mini-stats-wid"> <div class="card-body"> <div class="d-flex"> <div class="flex-grow-1"> <a href="viewtestimonial.php"> <p class="text-muted fw-medium">Testimonial</p> <h4 class="mb-0"><?= $total_testimonial; ?></h4> </a> </div> <div class="flex-shrink-0 align-self-center"> <div class="avatar-sm rounded-circle mini-stat-icon"> <span class="avatar-title rounded-circle"> <i class="fas fa-comments font-size-24"></i> </span> </div> </div> </div> </div> </div> </div> <!-- BLOG --> <?php $total_blog = mysqli_fetch_assoc(mysqli_query($con, "SELECT COUNT(*) AS total FROM blog"))['total']; ?> <div class="col-md-3"> <div class="card mini-stats-wid"> <div class="card-body"> <div class="d-flex"> <div class="flex-grow-1"> <a href="viewblog.php"> <p class="text-muted fw-medium">Blog</p> <h4 class="mb-0"><?= $total_blog; ?></h4> </a> </div> <div class="flex-shrink-0 align-self-center"> <div class="avatar-sm rounded-circle mini-stat-icon"> <span class="avatar-title rounded-circle"> <i class="fas fa-blog font-size-24"></i> </span> </div> </div> </div> </div> </div> </div> <!-- META TAG --> <?php $total_meta = mysqli_fetch_assoc(mysqli_query($con, "SELECT COUNT(*) AS total FROM meta_tag"))['total']; ?> <div class="col-md-3"> <div class="card mini-stats-wid"> <div class="card-body"> <div class="d-flex"> <div class="flex-grow-1"> <a href="viewmetatag.php"> <p class="text-muted fw-medium">Meta Tag</p> <h4 class="mb-0"><?= $total_meta; ?></h4> </a> </div> <div class="flex-shrink-0 align-self-center"> <div class="avatar-sm rounded-circle mini-stat-icon"> <span class="avatar-title rounded-circle"> <i class="fas fa-tags font-size-24"></i> </span> </div> </div> </div> </div> </div> </div> </div> <!-- end row --> </div> <!-- container-fluid --> </div> <!-- page-content --> </div> <!-- main-content --> <?php include("footer.php"); ?>
Save
Cancel