calculate age from birthday

[Anon]

Hello,

I am having trouble calculating the age of someone from a birthday. I can do it using mktime, but it doesnt work for anyone born before 1970, due to using the unix timestamp. Please help! Here is my code:

$date = explode("-", $date);
//now $date[0]=YYYY, $date[1]=MM, $date[2]=DD

// first get the current date
$nowdate = mktime(0,0,0,date("m"),date("d"),date("Y"));

// this is my birthday
$birthday = mktime(0,0,0,$date[1],$date[2],$date[0]);

[Anon]

jack,

Seems pretty simple. Just don't use mktime.

Just subtract the birth year from the current year. Compare current day and month to the birth day and month to determine if you need to subtract a year because they haven't had a birthday this year.

Ron

[Anon]

How do you subtract a "date" type?

[Anon]

Break the dates apart like you are doing already.

$total_years = $year_now - $year_born;

if ( $month_now < $month_born ) {
$total_years --;
}
elseif (($month_now == $month_born) && ( $day_now < $day_born )){
$total_years --;
}

echo $total_years;

The if statement will determine if the person's birthday has already passed or not and adjust accordingly.

[Anon]

Hi!

This is the MySQL function for doing this. Use date("Y"), date("m"), date("d") to simulate YEAR(NOW()), MONTH(NOW()) and DAYOFMONTH(NOW()), and mktime() to make a date that should be passed as the second parameter to the above functions to simulate
DAYOFMONTH($birthdate_col), etc.

/**
Short description: MySQL_AgeSQL($birthdate_col)
Returns SQL code that returns a person's age based on his/her birthdate.

@return string
@throws
*/
function MySQL_AgeSQL($birthdate_col)
{
return "IF(((MONTH(NOW()) = MONTH($birthdate_col) AND DAYOFMONTH(NOW()) < DAYOFMONTH($birthdate_col)) OR (MONTH(NOW()) < MONTH($birthdate_col))), YEAR(NOW()) - YEAR($birthdate_col) - 1, YEAR(NOW()) - YEAR($birthdate_col))";

} // end func

Best regards,
Stas