Timestamp difference in php Tuesday, February 26, 2013

A project need to get difference between two mysql timestamp. This code hep to get the difference of times in second. In generally we can get difference if the work start-end time is in 24 hours but it is quite impossible to get the time difference it the work start time is be in 11:55:00 PM. Bu this code provide the solution. It is very easy to use this function.

Code:
//Input time type as 2013-02-25 19:59:19 function timestampToInt($time){ $year = date("Y", strtotime($time)); $month = date("m", strtotime($time)); $day = date("d", strtotime($time)); $hour = date("H", strtotime($time)); $min = date("i", strtotime($time)); $sec = date("s", strtotime($time)); $totalSec = ($year * 12*30*24*60*60 ) + ($month *30*24*60*60) + ($day * 24*60*60) + ($hour*60*60) + ($min*60) + $sec ; return $totalSec; } //Uses example $timeStart = "2013-02-25 23:50:19"; $timeEnd = "2013-02-26 19:59:19"; $timeDifference = timestampToInt($timeEnd) - timestampToInt($timeStart); echo "Total time: ".$timeDifference."Sec";