[SOLVED] Simple noob question: How to get days elapsed?

[paschim]

In my database i am storing the date1 using time() of php! Now how do i get the number of years and months that has passed since date1?

[genericnumber1]

<?php
$start = strtotime('5/21/1988'); // Start time, for instance, my birthday!
$end = time(); // End time, today.

$sDate = date('n/j/Y', $start);
$eDate = date('n/j/Y', $end);
list($eMonth, $eDay, $eYear) = explode('/', $eDate);
list($sMonth, $sDay, $sYear) = explode('/', $sDate);

$yearDiff = $eYear - $sYear;
$monthDiff = $eMonth - $sMonth;
$dayDiff = $eDay - $sDay;

if($dayDiff < 0) {
--$monthDiff;
$dayDiff = date('t', $sMonth) - $sDay + $eDay;
}

if($monthDiff < 0) {
--$yearDiff;
$monthDiff += 12;
}

echo "$yearDiff years $monthDiff months $dayDiff days";
?>

 

It's accurate to the day, if you want hours/minutes/seconds... go for it! Also, this could be a little more efficient (less repeated code, etc) but I didn't do that to keep it simple so it's easy for you to read if you want to break it up into functions, go for it.

 

EDIT: just a sec, messed something up let me fix it.

Another EDIT: okay, fixed the date calculation, it's 3 am, give me a break

[genericnumber1]

Okay, you wanted month/year, right? here you go.

 

<?php
$start = strtotime('2/28/1988'); // Start time, for instance, my birthday!
$end = strtotime('6/27/2008'); // End time, today.

$sDate = date('n/j/Y', $start);
$eDate = date('n/j/Y', $end);
list($eMonth, $eDay, $eYear) = explode('/', $eDate);
list($sMonth, $sDay, $sYear) = explode('/', $sDate);

$yearDiff = $eYear - $sYear;
$monthDiff = $eMonth - $sMonth;
$dayDiff = $eDay - $sDay;

if($dayDiff < 0) {
--$monthDiff;
}

if($monthDiff < 0) {
--$yearDiff;
$monthDiff += 12;
}

echo "$yearDiff years $monthDiff months";

 

doesn't work for day, but hey, you didn't say you wanted that working...

 

tell me when it isn't 3:30 am if you want me to fix it, it's just annoying because of the difference in numbers of days/month I'd have to rewrite half of it to get it working correctly

[paschim]

Thank you Guys!!

 

I used a different and simpler approach, i cooked up while experimenting! But your codes also taught me new things!