mysql - Return the difference between two (dates and time ) PHP

Question

i tried most of what is available on stack overflow but none seem to work.

any way i am trying to compare two (date and time formats). and calculate whether their difference is within 5 seconds of each other

the first date is the current date:

$today   = date("Y-m-d H:i:s");

the second date is taken from mysql database:

$result = mysql_query("SELECT * FROM BUS_DATA where BusRegID = 'bus'") or die(mysql_error());
$row     = mysql_fetch_array($result);
$update_date  = $row["update_date"];

the answer should be segmented into years , month , days , hours , minutes ,and seconds portions.

I am running PHP Version 5.3.3

Edit: most answers give result in time frame only , I want to check whether the date matches , then compare if the time of the day is within 5 seconds , than you guys in advance :)

Answer 1

Try this
function getTimes($t1, $t2)
{
$timeFirst  = strtotime($t1);
$timeSecond = strtotime($t2);
$differenceInSeconds = $timeSecond - $timeFirst;
$h=0;
$m  = floor($differenceInSeconds / 60);
$s  = $differenceInSeconds % 60;
if ($m>=60)
{
  $h = floor($m / 60);
  $m = $m % 60;
}
$tim = $h.':'.$m.':'.$s;
return $tim;
}
it will return difference time in hours:min:sec