[RESOLVED] Age with month

[Ali_baba]

Hi all,

I am trying to determine the age with month e.g, 63.5 years old.
The age will be calculated by : age = form fill date - birth date.

Visiting patients are usually over 50 years old.

Both of these dates are in database:

Here is my code:

$filldatestamp = mktime(0, 0, 0, $fill_month, $fill_day, $fill_year);
$birthstamp = mktime(0, 0, 0, $birth_month, $birth_day, $birth_year);
$diff = $visitstamp - $birthstamp;
$age = $diff / 31556926;

However, I am unable to get what I would like to see 🙁

Any help? Suggestion?

[kakki]

you are using a timestamp to calculate the age ....
the problem is that these timestamps start with 1.1.1970
( birth of pcs )....
your patients are over 50, so thats before 1970 ...
maybe another formula will work better:

$filldatestamp = mktime(0, 0, 0, $fill_month, $fill_day, 1970);
$birthstamp = mktime(0, 0, 0, $birth_month, $birth_day, 1970); 
$minusOne=false;
if ( $birthstamp < $filldatestamp )
{
         $birthstamp = mktime(0, 0, 0, $birth_month, $birth_day, 1971); 
         $minusOne = true;
}
$age = $fill_year -  $birth_year;
if ( $minusOne )
{
         $age--;
}
$age += date_format( '%m', $filldatestamp - $birthstamp )/12;

[Ali_baba]

Thanks kaikki for your help.

I tried to use your code like this, just for testing:

<?

$fill_month = 11;
$fill_day = 22;
$fill_year = 2007;

$birth_month = 12;
$birth_day = 22;
$birth_year = 1947;

$filldatestamp = mktime(0, 0, 0, $fill_month, $fill_day, 1970);
$birthstamp = mktime(0, 0, 0, $birth_month, $birth_day, 1970); 
$minusOne=false;
if ( $birthstamp < $filldatestamp )
{
         $birthstamp = mktime(0, 0, 0, $birth_month, $birth_day, 1971); 
         $minusOne = true;
}
$age = $fill_year - $birth_year;
if ( $minusOne )
{
         $age--;
}
$age+= date_format( '%m', $filldatestamp - $birthstamp )/12;

echo $age;
?>

However, I got this error:

Warning: date_format() expects parameter 1 to be DateTime, string given in /home/muamshai/public_html/ing/as.php on line 24

I am exactly unable to understand this error 🙂

[kakki]

oops ....
i mixed up the parameters....

$age+= date_format( '%m', $filldatestamp - $birthstamp )/12; 

should be

$age+= date_format( $filldatestamp - $birthstamp, '%m' )/12; 

btw, pls use <?php instead of <?
because your web-server will behave strange, when some other languages are installed on
your apache( <? is used for .asp normally )

[Ali_baba]

Thanks kakki for your help 🙂