.-.-.-.-.-

<?php 
$title= "Dashboard";
include 'header.php';

$uid =$_SESSION['adminid'];
$result=mysqli_query($connection, "SELECT count(uid) as count FROM user");
$row=mysqli_fetch_object($result);
$paid_user=mysqli_fetch_object(mysqli_query($connection, "SELECT count(uid) as count FROM user where is_paid = 1 "))->count;
$unpaid_user=mysqli_fetch_object(mysqli_query($connection, "SELECT count(uid) as count FROM user where is_paid = 0 "))->count;

<h1><b> Welcome to Dashboard</b></h1>
    <section>
       
<div class="container-fluid">

<div class="row">
        <div class="col-sm-12">
            <div class="page-title-box">
                <h4 class="page-title">Dashboard</h4>
                <ol class="breadcrumb">
                    <li class="breadcrumb-item"><a href="javascript:void(0);">Home</a></li>
                    <li class="breadcrumb-item"><a href="javascript:void(0);">Index</a></li>

                </ol>

<div class="state-information d-none d-sm-block">
                                                        <div class="state-graph">
                                                            <div id="header-chart-1"></div>
                                                            <div class="info"><b>Total Paid User  :<?php echo $paid_user?></b></div>
                                                            
                                                            
                                                        </div>
                                                        <div class="state-graph">
                                                            <div id="header-chart-2"></div>
                                                            <div class="info"><b>Total Unpaid Users   :<?php echo $unpaid_user?></b></div>
                                                        </div>
                                                    </div>
            </div>
        </div>
    </div>
    <div class="row">
        <div class="col-lg-12">
            <div class="card m-b-20">
                <div class="card-body">

<table class="table mb-0 table-bordered table-striped">
                        <thead>
                            <tr>
                                <td>Total User</td>
                                  <td><?php echo $row->count ?></td>
                               
                            </tr>
                             <tr>
                           
                                <td>Total Paid User</td>
                                     <td><?php echo $paid_user ?></td>
                                
                            </tr>
                              <tr>
                           
                                <td>Total Give helps</td>
                                     <td><?php echo $total_give_helps = mysqli_fetch_object(mysqli_query($connection,"SELECT count(commit_id) as commit_id FROM commit"))->commit_id; ?></td>
                                
                            </tr>
                             <tr>
                         
                                <td>Total Canceled Give Helps</td>
                                     <td><?php echo $total_canceled_give_helps = mysqli_fetch_object(mysqli_query($connection,"SELECT count(commit_id) as commit_id FROM commit WHERE lock_status=1"))->commit_id;?></td>
                               
                            </tr>
                            <tr>
                         
                                <td>Total Give Help Amount</td>
                                     <td><?php echo $total_give_help_amount = mysqli_fetch_object(mysqli_query($connection,"SELECT SUM(amount) as amount FROM commit"))->amount;?></td>
                               
                            </tr>
                            <tr>
                         
                                <td>Total Received Helps</td>
                                     <td><?php echo $total_canceled_give_help_amount = mysqli_fetch_object(mysqli_query($connection,"SELECT SUM(amount) as amount FROM commit WHERE lock_status=1"))->amount;?></td>
                               
                            </tr>
                            <tr>
                         
                                <td>Total Received Help Amount</td>
                                     <td><?php echo $total_received_helps = mysqli_fetch_object(mysqli_query($connection,"SELECT count(help_id) as count FROM help WHERE confirm_status=1"))->count;?></td>
                               
                            </tr>
                            <tr>
                         
                                <td>Total Requests Completed By System</td>
                                     <td><?php echo $total_received_help_amount = mysqli_fetch_object(mysqli_query($connection,"SELECT SUM(amount) as amount FROM help WHERE confirm_status=1"))->amount;?></td>
                               
                            </tr>
                        </thead>
                        <tbody>
                           
                        </tbody>
                    </table>
                    <?php //echo $pager->renderFullNav();    ?>  
                </div>
            </div>
        </div>  
    </div>

</div>
      </section>
    
  
<?php include 'footer.php';?>

/home2/wtmwscom/public_html/livezila/../fonts/../admin/index.php