File manager - Edit - /home/custbahd/irungikitchen.com/admin/counter/get-today/index.php
Back
<?php session_start(); include_once "../db/config.php"; include_once('../db/count_db.php'); //Today $sql = "SELECT name, month, image, SUM(subtotal), SUM(quantity), COUNT(*), COUNT(DISTINCT email) FROM checkout WHERE DAY(timestamp)=DAY(CURRENT_DATE) AND MONTH(timestamp)=MONTH(CURRENT_DATE) AND YEAR(timestamp)=YEAR(CURRENT_DATE)"; $result = $conn->query($sql); //display data on web page if($row = mysqli_fetch_array($result)){ $today_sales = $row["SUM(quantity)"]; $today_orders = $row["COUNT(*)"]; $today_clients = $row["COUNT(DISTINCT email)"]; $today_income = $row["SUM(subtotal)"]; } else { $today_sales = 0; $today_orders = 0; $today_clients = 0; $today_income = 0; } ?> <div class="card-footer pt-0 pb-0 text-center"> <div class="row"> <div class="col-4 pt-3 pb-3 border-right"> <?php echo '<h3 class="mb-1 fs-14">'.number_format($today_orders).'</h3>'; if ($today_orders==1) { echo '<span class="fs-14">Order</span>'; } else { echo '<span class="fs-14">Orders</span>'; } ?> </div> <div class="col-4 pt-3 pb-3 border-right"> <?php echo '<h3 class="mb-1 fs-14">'.number_format($today_sales).'</h3>'; if ($today_sales==1) { echo '<span class="fs-14">Item</span>'; } else { echo '<span class="fs-14">Items</span>'; } ?> </div> <div class="col-4 pt-3 pb-3"> <span class="fs-14">UGX</span><h3 class="mb-1 fs-14"><?php echo number_format($today_income); ?></h3> </div> </div> </div>
| ver. 1.4 |
Github
|
.
| PHP 8.1.33 | Generation time: 0.88 |
proxy
|
phpinfo
|
Settings