invisio v2.0

<?php
    session_start();
    include('../../../config/main_function.php');
    $secure = "cAh3DrJACzw4RbU";
    $connection = connectDB($secure);

if ($connection) {
        // 0 = ผู้เยี่ยมชม ,g9k1s = ทั่วไป , kki22 = วิสามัญ , x9fkq = สามัญ
        $sql_viewer = "SELECT COUNT(*) AS total_viewer FROM tbl_member WHERE member_code IS NULL  ";
        $res_viewer = mysqli_query($connection, $sql_viewer)  or die($connection->error);
        $viewer = mysqli_fetch_assoc($res_viewer);

$sql_normal = "SELECT COUNT(*) AS g9k1s FROM tbl_member WHERE member_code IS NOT NULL AND register_level = 'g9k1s' AND register_status = '1'";
        $res_normal = mysqli_query($connection, $sql_normal)  or die($connection->error);
        $normal = mysqli_fetch_assoc($res_normal);

$sql_extra = "SELECT COUNT(*) AS kki22 FROM tbl_member WHERE member_code IS NOT NULL AND register_level = 'kki22' AND register_status = '1' ";
        $res_extra = mysqli_query($connection, $sql_extra)  or die($connection->error);
        $extra = mysqli_fetch_assoc($res_extra);

$sql_ordinary = "SELECT COUNT(*) AS x9fkq FROM tbl_member WHERE member_code IS NOT NULL AND register_level = 'x9fkq' AND register_status = '1' ";
        $res_ordinary = mysqli_query($connection, $sql_ordinary)  or die($connection->error);
        $ordinary = mysqli_fetch_assoc($res_ordinary);

$sql_member = "SELECT COUNT(*) AS total_member FROM tbl_member WHERE member_code IS NOT NULL AND register_status = '1' ";
        $res_member = mysqli_query($connection, $sql_member)  or die($connection->error);
        $member = mysqli_fetch_assoc($res_member);
    } else {
        $arr['result'] = 9;
    }

?>
 <div class="row">
     <div class="col">
         <div class="ibox shadow-sm rounded">
             <div class="ibox-title">
                 
                 <h5>สมาชิกสมาคม</h5>
             </div>
             <div class="ibox-content">
                 <h1 class="no-margins"><?php echo $member['total_member'] ?></h1>

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

<div class="col">
         <div class="ibox shadow-sm rounded">
             <div class="ibox-title">
                 
                 <h5>สมาชิกสามัญ</h5>
             </div>
             <div class="ibox-content">
                 <h1 class="no-margins"><?php echo $ordinary['x9fkq'] ?></h1>
                 
             </div>
         </div>
     </div>
     <div class="col">
         <div class="ibox shadow-sm rounded">
             <div class="ibox-title">
                 
                 <h5>สมาชิกวิสามัญ</h5>
             </div>
             <div class="ibox-content">
                 <h1 class="no-margins"><?php echo $extra['kki22'] ?></h1>

</div>
         </div>
     </div>
     <div class="col">
         <div class="ibox shadow-sm rounded">
             <div class="ibox-title">
                 
                 <h5>สมาชิกทั่วไป</h5>
             </div>
             <div class="ibox-content">
                 <h1 class="no-margins"><?php echo $normal['g9k1s'] ?></h1>
                 
             </div>
         </div>
     </div>
     <div class="col">
         <div class="ibox shadow-sm rounded">
             <div class="ibox-title">
                 
                 <h5>ผู้เยี่มชม</h5>
             </div>
             <div class="ibox-content">
                 <h1 class="no-margins"><?php echo $viewer['total_viewer'] ?></h1>
                 
             </div>
         </div>
     </div>

</div>