File manager - Edit - /home/custbahd/cornerstoneassetmanagers.com/admin/counter/get-count/index.php
Back
<?php session_start(); include_once "../db/config.php"; include_once('../db/count_db.php'); $output = ""; $sql = "SELECT * FROM checkout_admin WHERE seen=''"; $query = mysqli_query($conn, $sql); while($row = mysqli_fetch_assoc($query)){ //Time date_default_timezone_set('Africa/Kampala'); $start_count = date("Y-m-d H:i:s", strtotime($row['timestamp'] . "+1 days")); $today = date("Y-m-d H:i:s",time()); $start_diff = new DateTimeImmutable($row['timestamp']); $endd_diff = new DateTimeImmutable($today); $duration = $start_diff->diff($endd_diff); $today_diff = new DateTimeImmutable($today); $days_diff = $today_diff->diff($start_diff); //Notification Sound if ($days_diff->format('%s')==10 & $days_diff->format('%i')==0 & $days_diff->format('%h')==0 & $days_diff->format('%d')==0 & $days_diff->format('%m')==0 & $days_diff->format('%y')==0) { $audio = '<audio id="Audio" preload="auto" controls autoplay hidden> <source src="counter/noties/pop.wav" type="audio/mp3"> </audio>'; } else { $audio = ''; } } $sql = "SELECT count(*), order_code FROM checkout_admin WHERE seen=''"; $result = $conn->query($sql); // Display data on web page while($row = mysqli_fetch_array($result)) { if ($row['count(*)']==0) { $output .= 'No new orders'; } elseif ($row['count(*)']==1) { $output .= ''.$row['count(*)'].' new order '.$audio.' <a href="invoices/invoice/?i='.$row["order_code"].'"><i class="fa fa-caret-right text-success ml-1 float-bounce-right"></i>'; } else { $output .= ''.$row['count(*)'].' new orders '.$audio.' <a href="orders"><i class="fa fa-caret-right text-success ml-1 float-bounce-right"></i>'; } } echo "<span class='text-success fs-9'>".$output."</span>"; ?>
| ver. 1.4 |
Github
|
.
| PHP 8.1.33 | Generation time: 1.11 |
proxy
|
phpinfo
|
Settings