<?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"); ?>