index.php

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

$s = date('Y-m-d');
$query = "SELECT * from booking_registrasi where tgl_booking ='$s'";
$data = $db->prepare($query);
$data->execute();
$count=$data->rowCount();
$query1 = "SELECT * from booking_registrasi where nama_poli='Poli KIA' and tgl_booking ='$s'";
$data1 = $db->prepare($query1);
$data1->execute();
$count1=$data1->rowCount();
$query2 = "SELECT * from booking_registrasi where nama_poli='Poli Obgyn' and tgl_booking ='$s'";
$data2 = $db->prepare($query2);
$data2->execute();
$count2=$data2->rowCount();
// $query3 = "SELECT * from booking_registrasi where nama_poli='Imunisasi'";
// $data3 = $db->prepare($query3);
// $data3->execute();
// $count3=$data3->rowCount();

?>
  <section class="content">
      <div class="container-fluid">
        <!-- Small boxes (Stat box) -->
        <div class="row">
          <div class="col-lg-3 col-6">
            <!-- small box -->
            <div class="small-box bg-info">
              <div class="inner">
                <h3><?=$count1?></h3>

                <p>Antrian Poli KIA</p>
              </div>
              <div class="icon">
              <i class="ion ion-plus-round"></i>
              </div>
              
            </div>
          </div>
          <!-- ./col -->
          <div class="col-lg-3 col-6">
            <!-- small box -->
            <div class="small-box bg-success">
              <div class="inner">
                <h3><?= $count2?></h3>

                <p>Antrian Poli Obgyn</p>
              </div>
              <div class="icon">
                <i class="ion ion-android-person-add"></i>
              </div>
              
            </div>
          </div>
          <!-- ./col -->
          <!-- <div class="col-lg-3 col-6"> -->
            <!-- small box -->
            <!-- <div class="small-box bg-warning">
              <div class="inner">
                <h3><?= $count3?></h3>

                <p>Antrian Imunisasi</p>
              </div>
              <div class="icon">
                <i class="ion ion-android-happy"></i>
              </div>
            </div>
          </div> -->
          <!-- ./col -->
          <div class="col-lg-3 col-6">
            <!-- small box -->
            <div class="small-box bg-danger">
              <div class="inner">
                <h3><?= $count?></h3>

                <p>Total Antrian</p>
              </div>
              <div class="icon">
                <i class="ion ion-ios-people-outline"></i>
              </div>

            </div>
          </div>
          <!-- ./col -->
        </div>
</section>
</div>
<?php

include('./layout/footer.php');

?>