bnmbertsurheoppopopooooooooooooooopoopopdf'tdfg

hjkhghoppoopppooppoppoppoopoirh bnmbertsurheoppopopooooooooooooooopoopopdf'tdfg

<?php 
  include('include/header.php');
  include('include/sidebar.php');

$sql = "select count(*) as total_trekking from trekking";
if ($result = $conn->query($sql))  {
    $trekking = $result->fetch_assoc();
}
  $sql = "select count(*) as total_tour from tour_packages";
if ($result = $conn->query($sql))  {
    $tour = $result->fetch_assoc();
}
  $sql = "select count(*) as total_gallery from gallery";
if ($result = $conn->query($sql))  {
    $gallery = $result->fetch_assoc();
}
  $sql = "select count(*) as total_bike from bike_rental";
if ($result = $conn->query($sql))  {
    $bike = $result->fetch_assoc();
}

$sql = "select count(*) as total_service from services where parent_id=0";
if ($result = $conn->query($sql))  {
    $service = $result->fetch_assoc();
}

$sql = "select count(*) as total_local_place from local_famous_places";
if ($result = $conn->query($sql))  {
    $local_place = $result->fetch_assoc();
}

$sql = "select count(*) as total_slider from slider";
if ($result = $conn->query($sql))  {
    $slider = $result->fetch_assoc();
}
  $sql = "select count(*) as total_video from video";
if ($result = $conn->query($sql))  {
    $video = $result->fetch_assoc();
}
 ?>

<main class="page-content">
              
            <div class="row row-cols-1 row-cols-md-2 row-cols-lg-2 row-cols-xl-4">
              <div class="col">
                <div class="card radius-10">
                  <div class="card-body">
                      <div class="d-flex align-items-center">
                          <div>
                              <p class="mb-0 text-secondary">Total Trekking</p>
                              <h4 class="my-1"><?=$trekking['total_trekking']; ?></h4>
                              
                          </div>
                          <div class="widget-icon-large bg-gradient-purple text-white ms-auto"><i class="fa-solid fa-person-hiking"></i>
                          </div>
                      </div>
                  </div>
                </div>
               </div>
               <div class="col">
                  <div class="card radius-10">
                    <div class="card-body">
                        <div class="d-flex align-items-center">
                            <div>
                                <p class="mb-0 text-secondary">Total Tour Package</p>
                                <h4 class="my-1"><?=$tour['total_tour']; ?></h4>
                                
                            </div>
                            <div class="widget-icon-large bg-gradient-success text-white ms-auto"><i class="lni lni-package"></i>
                            </div>
                        </div>
                    </div>
                </div>
               </div>
               <div class="col">
                <div class="card radius-10">
                  <div class="card-body">
                      <div class="d-flex align-items-center">
                          <div>
                              <p class="mb-0 text-secondary">Total Gallery Image</p>
                              <h4 class="my-1"><?=$gallery['total_gallery']; ?></h4>
                              
                          </div>
                          <div class="widget-icon-large bg-gradient-danger text-white ms-auto"><i class="bi bi-image"></i>
                          </div>
                      </div>
                  </div>
               </div>
               </div>
               <div class="col">
                <div class="card radius-10">
                  <div class="card-body">
                      <div class="d-flex align-items-center">
                          <div>
                              <p class="mb-0 text-secondary">Total Bike</p>
                              <h4 class="my-1"><?=$bike['total_bike']; ?></h4>
                              
                          </div>
                          <div class="widget-icon-large bg-gradient-info text-white ms-auto"><i class="fa-solid fa-motorcycle"></i>
                          </div>
                      </div>
                  </div>
                </div>
               </div>
            </div>
            <div class="row row-cols-1 row-cols-md-2 row-cols-lg-2 row-cols-xl-4">
              <div class="col">
                <div class="card radius-10">
                  <div class="card-body">
                      <div class="d-flex align-items-center">
                          <div>
                              <p class="mb-0 text-secondary">Total Service</p>
                              <h4 class="my-1"><?=$service['total_service']; ?></h4>
                              
                          </div>
                          <div class="widget-icon-large bg-gradient-purple text-white ms-auto"><i class="lni lni-list"></i>
                          </div>
                      </div>
                  </div>
                </div>
               </div>
               <div class="col">
                  <div class="card radius-10">
                    <div class="card-body">
                        <div class="d-flex align-items-center">
                            <div>
                                <p class="mb-0 text-secondary">Total Local Famous Places</p>
                                <h4 class="my-1"><?=$local_place['total_local_place']; ?></h4>
                                
                            </div>
                            <div class="widget-icon-large bg-gradient-success text-white ms-auto"><i class="lni lni-map-marker"></i>
                            </div>
                        </div>
                    </div>
                </div>
               </div>
               <div class="col">
                <div class="card radius-10">
                  <div class="card-body">
                      <div class="d-flex align-items-center">
                          <div>
                              <p class="mb-0 text-secondary">Total Slider</p>
                              <h4 class="my-1"><?=$slider['total_slider']; ?></h4>
                              
                          </div>
                          <div class="widget-icon-large bg-gradient-danger text-white ms-auto"><i class="bx bx-slider"></i>
                          </div>
                      </div>
                  </div>
               </div>
               </div>
               <div class="col">
                <div class="card radius-10">
                  <div class="card-body">
                      <div class="d-flex align-items-center">
                          <div>
                              <p class="mb-0 text-secondary">Total Video</p>
                              <h4 class="my-1"><?=$video['total_video']; ?></h4>
                              
                          </div>
                          <div class="widget-icon-large bg-gradient-warning text-white ms-auto"><i class="lni lni-video"></i>
                          </div>
                      </div>
                  </div>
                </div>
               </div>
            </div>  
          </main>
       
<?php include('include/footer.php');?>