revealability

Back Back Up Advanced Editor

<?php
session_start();
include "../assets/constant/config.php";

try {
   $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
   $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
   echo "Connection failed: " . $e->getMessage();
}
?>
<?php include('include/sidebar.php'); ?>

<?php include('include/header.php'); ?>
<div id="myAlert" class="alert alert-success alert-dismissible fade show" role="alert">

<strong>Welcome!</strong> Login Successfully.
</div>
<div class="page-content-wrapper ">
   <div class="container-fluid">
      <div class="row">
         <div class="col-sm-12">
            <div class="page-title-box">
               <div class="btn-group float-right">
                  <ol class="breadcrumb hide-phone p-0 m-0">
                     <li class="breadcrumb-item active"></li>
                  </ol>
               </div>
               <h4 class="page-title">Dashboard</h4>
            </div>
         </div>
         <div class="clearfix"></div>
      </div>
      
      <div class="row dashboard">
         <div class="col-lg-4">
            <div class="card bg-success">
               <div class="card-body py-4">
                  <div class="d-flex flex-row">
                     <div class="col-3 align-self-center">
                        <div class="round">
                           <i data-feather="tool"></i>
                        </div>
                     </div>
                     <div class="col-9 align-self-center text-right">
                        <div class="m-l-10">
                           <h3 class="mt-0 text-white">
                              <?php
                              $stmt = $conn->prepare("SELECT count(*) as cnt_name from service WHERE delete_status='0' ");
                              $stmt->execute();
                              $record = $stmt->fetch(PDO::FETCH_ASSOC); ?>
                              <?PHP echo $record['cnt_name'];
                              $name = $record['cnt_name']; ?>
                           </h3>
                           <p class="mb-0 text-white">Total Services

</p>
                        </div>
                     </div>
                  </div>

</div>
               
            </div>

</div>

<div class="col-lg-4">
            <div class="card bg-primary">
               <div class="card-body py-4">
                  <div class="d-flex flex-row">
                     <div class="col-3 align-self-center">
                        <div class="round">
                           <i data-feather="list"></i>
                        </div>
                     </div>
                     <div class="col-9 align-self-center text-right">
                        <div class="m-l-10">
                           <h3 class="mt-0 text-white">
                              <?php
                              $stmt = $conn->prepare("SELECT count(*) as cnt_name from events WHERE delete_status='0' ");
                              $stmt->execute();
                              $record = $stmt->fetch(PDO::FETCH_ASSOC); ?>
                              <?PHP echo $record['cnt_name'];
                              $name = $record['cnt_name']; ?>
                           </h3>
                           <p class="mb-0 text-white">Total Events

</p>
                        </div>
                     </div>
                  </div>

</div>
               
            </div>

</div>

<div class="col-lg-4">
            <div class="card bg-secondary">
               <div class="card-body py-4">
                  <div class="d-flex flex-row">
                     <div class="col-3 align-self-center">
                        <div class="round">
                           <i data-feather="users"></i>
                        </div>
                     </div>
                     <div class="col-9 align-self-center text-right">
                        <div class="m-l-10">
                           <h3 class="mt-0 text-white">
                              <?php
                              $stmt = $conn->prepare("SELECT count(*) as cnt_name from testimonial where delete_status= 0  ");
                              $stmt->execute();
                              $record = $stmt->fetch(PDO::FETCH_ASSOC); ?>
                              <?PHP echo $record['cnt_name'];
                              $name = $record['cnt_name']; ?>
                           </h3>
                           <p class="mb-0 text-white">Total Testimonial

</p>
                        </div>
                     </div>
                  </div>

</div>
               
            </div>

</div>

<div class="col-lg-4">
            <div class="card bg-danger">
               <div class="card-body py-4">
                  <div class="d-flex flex-row">
                     <div class="col-3 align-self-center">
                        <div class="round">
                           <i data-feather="user"></i>
                        </div>
                     </div>
                     <div class="col-9 align-self-center text-right">
                        <div class="m-l-10">
                           <h3 class="mt-0 text-white">
                              <?php
                              $stmt = $conn->prepare("SELECT count(*) as cnt_name from team WHERE delete_status='0' ");
                              $stmt->execute();
                              $record = $stmt->fetch(PDO::FETCH_ASSOC); ?>
                              <?PHP echo $record['cnt_name'];
                              $name = $record['cnt_name']; ?>
                           </h3>
                           <p class="mb-0 text-white">Total Team

</p>
                        </div>
                     </div>
                  </div>

</div>
               
            </div>

</div>
         
                  <div class="col-lg-4">
            <div class="card bg-danger">
               <div class="card-body py-4">
                  <div class="d-flex flex-row">
                     <div class="col-3 align-self-center">
                        <div class="round">
                           <i data-feather="user"></i>
                        </div>
                     </div>
                     <div class="col-9 align-self-center text-right">
                        <div class="m-l-10">
                           <h3 class="mt-0 text-white">
                              <?php
                              $stmt = $conn->prepare("SELECT count(*) as cnt_name from subscribe  ");
                              $stmt->execute();
                              $record = $stmt->fetch(PDO::FETCH_ASSOC); ?>
                              <?PHP echo $record['cnt_name'];
                              $name = $record['cnt_name']; ?>
                           </h3>
                           <p class="mb-0 text-white">Total Subscribers

</p>
                        </div>
                     </div>
                  </div>

</div>
               
            </div>

</div>

<div class="col-lg-4">
            <div class="card bg-warning">
               <div class="card-body py-4">
                  <div class="d-flex flex-row">
                     <div class="col-3 align-self-center">
                        <div class="round">
                           <i data-feather="search"></i>
                        </div>
                     </div>
                     <div class="col-9 align-self-center text-right">
                        <div class="m-l-10">
                           <h3 class="mt-0 text-white">
                              <?php
                              $stmt = $conn->prepare("SELECT count(*) as cnt_name from join_member  ");
                              $stmt->execute();
                              $record = $stmt->fetch(PDO::FETCH_ASSOC); ?>
                              <?PHP echo $record['cnt_name'];
                              $name = $record['cnt_name']; ?>
                           </h3>
                           <p class="mb-0 text-white">Total Member

</p>
                        </div>
                     </div>
                  </div>

</div>
               
            </div>

</div>

</div>

</div>
   
</div>

<?php include('include/footer.php'); ?>