<?php

include("connection.php");
include("header.php");

?>
<div class="main-content">

    <div class="page-content">
        <div class="container-fluid">

            <!-- start 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">

                <div class="col-xl-12">
                    <div class="row">
                        <!-- slider -->
                        <?php
                        $result = mysqli_query($con, "SELECT COUNT(*) as total FROM slider");
                        $row = mysqli_fetch_assoc($result);
                        $total_sliders = $row['total'];
                        ?>
                        <!-- end slider -->
                        <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"><?php echo $total_sliders; ?></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 font-size-24"></i>
                                                </span>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>

                        <!-- video -->
                        <?php
                        $result = mysqli_query($con, "SELECT COUNT(*) as total FROM media");
                        $row = mysqli_fetch_assoc($result);
                        $total_video = $row['total'];
                        ?>
                        <!-- end video -->
                        <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">Galley/Video</p>
                                                <h4 class="mb-0"><?php echo $total_video; ?></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="dripicons-photo-group font-size-24"></i>
                                                </span>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <!-- Blog -->
                        <?php
                        $result = mysqli_query($con, "SELECT COUNT(*) as total FROM blog");
                        $row = mysqli_fetch_assoc($result);
                        $total_blog = $row['total'];
                        ?>
                        <!-- end blog -->
                        <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"><?php echo $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>
                        <!--  -->
                        <!-- Blog -->
                        <?php
                        $result = mysqli_query($con, "SELECT COUNT(*) as total FROM industries");
                        $row = mysqli_fetch_assoc($result);
                        $total_blog = $row['total'];
                        ?>
                        <!-- end blog -->
                        <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_Industries.php">
                                                <p class="text-muted fw-medium">Industries</p>
                                                <h4 class="mb-0"><?php echo $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-industry font-size-24"></i>
                                                </span>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <!-- service -->
                        <?php
                        $result = mysqli_query($con, "SELECT COUNT(*) as total FROM tbl_top_category");
                        $row = mysqli_fetch_assoc($result);
                        $total_service = $row['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">service top category</p>
                                                <h4 class="mb-0"><?php echo $total_service; ?></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>
                        <!-- End Services -->
                        <!-- service -->
                        <?php
                        $result = mysqli_query($con, "SELECT COUNT(*) as total FROM product");
                        $row = mysqli_fetch_assoc($result);
                        $total_service = $row['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_product.php">
                                                <p class="text-muted fw-medium">Product</p>
                                                <h4 class="mb-0"><?php echo $total_service; ?></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 font-size-24"></i>
                                                </span>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <!-- End Services -->

                        <!-- service -->
                        <?php
                        $result = mysqli_query($con, "SELECT COUNT(*) as total FROM certificate");
                        $row = mysqli_fetch_assoc($result);
                        $total_service = $row['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"><?php echo $total_service; ?></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>
                        <!-- End Services -->
                        <!-- service -->
                        <?php
                        $result = mysqli_query($con, "SELECT COUNT(*) as total FROM project");
                        $row = mysqli_fetch_assoc($result);
                        $total_service = $row['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="viewproject.php">
                                                <p class="text-muted fw-medium">Project</p>
                                                <h4 class="mb-0"><?php echo $total_service; ?></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-project-diagram font-size-24"></i>
                                                </span>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <!-- End Services -->
                        <!-- Testimonial -->
                        <?php
                        $result = mysqli_query($con, "SELECT COUNT(*) as total FROM testimonial");
                        $row = mysqli_fetch_assoc($result);
                        $total_testimon = $row['total'];
                        ?>
                        <!-- end Testimonial -->
                        <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"><?php echo $total_testimon; ?></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-comment-dots font-size-24"></i>
                                                </span>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <!-- team -->
                        <?php
                        $result = mysqli_query($con, "SELECT COUNT(*) as total FROM team");
                        $row = mysqli_fetch_assoc($result);
                        $total_testimon = $row['total'];
                        ?>
                        <!-- end Testimonial -->
                        <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">Team</p>
                                                <h4 class="mb-0"><?php echo $total_testimon; ?></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-users font-size-24"></i>
                                                </span>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <!-- end Team -->
                        <!-- team -->
                        <?php
                        $result = mysqli_query($con, "SELECT COUNT(*) as total FROM locations");
                        $row = mysqli_fetch_assoc($result);
                        $total_testimon = $row['total'];
                        ?>
                        <!-- end Testimonial -->
                        <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_location.php">
                                                <p class="text-muted fw-medium">Location</p>
                                                <h4 class="mb-0"><?php echo $total_testimon; ?></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-map-marker-alt font-size-24"></i>
                                                </span>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <!-- end Team -->
                        <!-- team -->
                        <?php
                        $result = mysqli_query($con, "SELECT COUNT(*) as total FROM package");
                        $row = mysqli_fetch_assoc($result);
                        $total_testimon = $row['total'];
                        ?>
                        <!-- end Testimonial -->
                        <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="viewpackages.php">
                                                <p class="text-muted fw-medium">Packages</p>
                                                <h4 class="mb-0"><?php echo $total_testimon; ?></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>
                        <!-- end Team -->

                    </div>
                    <!-- end row -->



                </div>
            </div>
            <!-- end row -->



            <!-- end row -->
        </div>
        <!-- container-fluid -->
    </div>
    <!-- End Page-content -->


    <!-- end modal -->




    <?php
    include("footer.php");


    ?>