[Resolved] Can i get age from date?

mikawhat

is there a script that can give me the age of a person according to his date of birth in my database?

planetsim

There isnt a straight out way to do it but yes you can with a bit of work, why not do a search for age calculator or age script there was on the Code Critique.

jansky

here is a simple codes maybe you can play this around to computer the right age
$mybirthday=$datefield
echo computeage($mybirthday);
function computeage($mybirthday)
{
$datenow=date("Y");

	$birthday=explode("-",$mybirthday);
	$myyear=$birthday[0];
	//$birthday=strftime("%Y",strtotime($mybirthday));
	$agenow=$datenow-$myyear;

return $agenow;
}

TheDefender

jansky and mikawhat, be cuatious about the use of the strtotime and strtftime functions. They will not work with dates prior to January 1, 1970 on Windows and certain other OS's (See Note Below). Follow planetsim's suggestion to search these forums, and once you find some scripts, post back for help implementing them. (Also, how are you storing the date in your DB? It makes a difference in how you'd prepare to do the actual calculations.)

From the PHP Manual for strtotime
Note: The valid range of a timestamp is typically from Fri, 13 Dec 1901 20:45:54 GMT to Tue, 19 Jan 2038 03:14:07 GMT. (These are the dates that correspond to the minimum and maximum values for a 32-bit signed integer.) Additionally, not all platforms support negative timestamps, therefore your date range may be limited to no earlier than the Unix epoch. This means that e.g. dates prior to Jan 1, 1970 will not work on Windows, some Linux distributions, and a few other operating systems.

mikawhat

ok, i got this piece of code from a web site.

Hi, my name is Dave and I'm <?php $birthdate = "19840310"; echo intval((date("Ymd",mktime()) - $birthdate)/10000); ?> Years Old

it is working like that, but i guess i'll have to get date of birth from database and use it instead of 19840310.

i'm working on it at the moment.

mikawhat

done!

$query = "select person_id, DATE_FORMAT(dob, '%Y%m%d') as dr from myTable where person_id = {$_GET['nid']}";
$result = mysql_query ($query);
$row = mysql_fetch_array ($result, MYSQL_ASSOC);
mysql_close();
$birthdate = $row["dr"];
echo "<tr>
<td><b>Age:</b></td>
<td ><b>" . intval((date("Ymd",mktime()) - $birthdate)/10000) . "</b></td>
</tr> \n";

thanx for your posts guys.

BIOSTALL

Hey.. i know this is an old thread but i'm also trying to find out someones age from there date of birth. Can i just ask why 'mikawhat' divided by 10000?? I cant work out why this number was used.

Thanks, BIOSTALL

mrhappiness

date("Ymd") returns 20050815 for today

dividing 20050815 by 10000 results in 2005.0815

intval converts that to 2005

BIOSTALL

A-ha... thank you mrhappiness 🙂