File manager - Edit - /home/custbahd/irungikitchen.com/admin/counter/get-noties/index.php
Back
<?php session_start(); include_once "../db/config.php"; include_once('../db/count_db.php'); $sql = "SELECT * FROM secure WHERE channel='Notifications' ORDER BY id DESC"; $result = $conn->query($sql); //display data on web page while($row = mysqli_fetch_array($result)){ 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) { echo '<audio id="Audio" preload="auto" autoplay hidden> <source src="counter/noties/pop.wav" type="audio/mp3"> </audio>'; } echo '<li>'; echo '<div class="timeline-panel">'; echo '<div class="media mr-2">'; if ($row["handler"]=='Admin') { echo '<img width="50" src="../img/il.png" alt="thumbnail">'; } else { echo '<i class="icon fa fa-user"></i>'; } echo '</div>'; echo '<div class="media-body">'; echo '<h6 class="mb-1 fs-12">'; echo '<a href="'.$row["link"].'" target="_blank">'.$row["summary"].'</a>'; echo '</h6>'; echo '<small class="d-block fs-11">'; if ($days_diff->format('%s')<30 & $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) { echo "Just Now"; } elseif ($days_diff->format('%i')>=0 & $days_diff->format('%h')>=0 & $days_diff->format('%d')>=0 & $days_diff->format('%m')>=0 & $days_diff->format('%y')==1) { echo "Last Year - ".date("D, jS M", strtotime($row['timestamp'])).""; } elseif ($days_diff->format('%i')>=0 & $days_diff->format('%h')>=0 & $days_diff->format('%d')>=0 & $days_diff->format('%m')>=0 & $days_diff->format('%y')>=1) { echo "".$days_diff->format("%y years")." ago on ".date("D, jS M", strtotime($row['timestamp'])).""; } elseif ($days_diff->format('%s')>30 & $days_diff->format('%i')==0 & $days_diff->format('%h')==0 & $days_diff->format('%d')==0) { echo "".$days_diff->format("%s seconds")." ago"; } elseif ($days_diff->format('%i')==1 & $days_diff->format('%h')==0 & $days_diff->format('%d')==0) { echo "".$days_diff->format("%i minute")." ago"; } elseif ($days_diff->format('%i')>=0 & $days_diff->format('%h')==0 & $days_diff->format('%d')==0) { echo "".$days_diff->format("%i minutes")." ago"; } elseif ($days_diff->format('%h')==1 & $days_diff->format('%d')==0 & $days_diff->format('%m')==0) { echo "".$days_diff->format("%h hour")." ago"; } elseif ($days_diff->format('%h')>=0 & $days_diff->format('%d')==0 & $days_diff->format('%m')==0) { echo "".$days_diff->format("%h hours")." ago"; } elseif ($days_diff->format('%d')==1) { echo "Yesterday - ".date("h:ia", strtotime($row['timestamp'])).""; } elseif ($days_diff->format('%m')==0) { echo "".date("D, jS M - h:ia", strtotime($row['timestamp'])).""; } elseif ($days_diff->format('%m')==1) { echo "Last Month on ".date("jS D", strtotime($row['timestamp'])).""; } elseif ($days_diff->format('%m')>=1) { echo "".date("D, jS M Y", strtotime($row['timestamp'])).""; } echo '</small>'; echo '</div>'; echo '</div>'; echo '</li>'; } ?>
| ver. 1.4 |
Github
|
.
| PHP 8.1.33 | Generation time: 1.3 |
proxy
|
phpinfo
|
Settings