<?php $query['duedate'] = '2019-02-25 08:33:45'; $query['duedate'] = '2019-02-25 08:41:52'; $query['duedate'] = '2019-02-25 09:04:43'; $dbDate = strtotime(date('Y-m-d H:i:s')); // Database date $endDate = strtotime("".$query['duedate'].""); // current time $diff = $endDate - $dbDate; /// diffrence $days = intval(intval($diff) / (3600*24)); $newDays = $days < 0 ? 'EXPIRED' : $days; echo "$days\n$newDays\n";
You have javascript disabled. You will not be able to edit any code.