计算两个日期之间的日期差异

Question

I am trying to find difference between two dates. It simple does not display anything , empty page shown for the date difference.

below is the code that i am using.

<?

$sql = $Db1->query("SELECT * FROM table LIMIT 5");

while($row = $Db1->fetch_array($sql)) {

$datetime1 = date("m-d-Y",mktime(0,0,$row['rec'],1,1,1970));
$datetime2 = date("m-d-Y",mktime(0,0,$row['send'],1,1,1970));
echo "$datetime1";
echo "$datetime2";
$diff=date_diff($datetime1,$datetime2);
echo $diff->format("%R%a days");
echo "$diff";


}
?>

Answer 1

use this function

$date1 = $row['rec'];
$date2 = $row['send'];
$diff = abs(strtotime($date2) - strtotime($date1));
$years = floor($diff / (365*60*60*24));
$months = floor(($diff - $years * 365*60*60*24) / (30*60*60*24));
$days = floor(($diff - $years * 365*60*60*24 - $months*30*60*60*24)/ (60*60*24));
printf("%d years, %d months, %d days
", $years, $months, $days);