<?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 class="page-title-right">
                            <ol class="breadcrumb m-0">
                                <li class="breadcrumb-item"><a href="javascript: void(0);">Dashboards</a></li>
                                <li class="breadcrumb-item active">Dashboard</li>
                            </ol>
                        </div> -->

                    </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-lightbulb 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-wrench font-size-24"></i>
                                                </span>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <!-- End Services -->
                         <!-- service -->
                        <?php
                        $result = mysqli_query($con, "SELECT COUNT(*) as total FROM mid_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_mid_Categories.php">
                                            <p class="text-muted fw-medium">service Mid 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-wrench 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-quote-left 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-quote-left 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 -->

    <!-- subscribeModal 
    <div class="modal fade" id="subscribeModal" tabindex="-1" aria-labelledby="subscribeModalLabel" aria-hidden="true">
        <div class="modal-dialog modal-dialog-centered">
            <div class="modal-content">
                <div class="modal-header border-bottom-0">
                    <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                </div>
                <div class="modal-body">
                    <div class="text-center mb-4">
                        <div class="avatar-md mx-auto mb-4">
                            <div class="  text-primary h1">
                                
                                 <img src="./assets/images/icon/namaste.png" alt="" height="100px">
                            </div>
                        </div>

                        <div class="row justify-content-center">
                            <div class="col-xl-10">
                                <h4 class="text-primary">WELCOME TO Zarifa Cloths</h4>
                                <p class="text-muted font-size-14 mb-4">Attractive clothes enhance confidence and leave a 
                                    lasting impression. Well-fitted outfits in appealing colors and trendy designs highlight 
                                    personal style.</p>

                               

                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
     -->



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


    ?>