PHP to find age *SOLVED*

[MrLarkins.com]

ok, i
$bday_day //birthday day
$bday_month //birthday month
$bday_year //birthday year
$today = getdate();
previously defined from a mysql grab i've done (the birthday stuff is in the database in columns bday_day, bday_month, bday_year)

what i'd like to do is use this data to find out how old the person is and display it

[gmwebs]

A quick Google search found me this... Should do the trick?

[url=http://www.nbrandt.com/get-age-from-date.php]http://www.nbrandt.com/get-age-from-date.php[/url]

HTH

[MrLarkins.com]

yea, i saw that, but it finds the age if you input a specific date, not exactly what i'm need/wanting.

but i would use a function right?  i know diddly-squat about those.

[redbullmarky]

[quote author=MrLarkins.com link=topic=111422.msg451578#msg451578 date=1160764904]
but i would use a function right?  i know diddly-squat about those.
[/quote]
it's impossible to use PHP without some knowledge of functions. echo itself is a function. mysql_query is a function. the list goes on. i've written a function i often use for this purpose:

[code]
<?php
// returns a persons age given their date of birth
function getage($dob)
{
  $exp = explode('-', $dob); // we now have the year[0], month[1] and date[2]
  $current = getdate();

  // get an estimate of years
  $ret = $current['year'] - $exp[0];
 
  if ($ret > 110)
  {
      return 0; // too old - possible no date parameter was specified
  }

  // have we reached their birthday month?
  if ($current['mon'] <= $exp[1])
  {
      $ded = 1; // we arent gonna DEDuct a year yet
     
      // are we in their birthday month?
      if (($current['mon'] == $exp[1]) && ($current['mday'] >= $exp[2]))
      {
        $ded = 0;
      }

      $ret -= $ded; // deduct a year as this years birthmonth not arrived
  }
  return $ret;
}
?>
[/code]

all it needs is a date of birth (YYYY-MM-DD format) and it'll return the age. so:

[code]
$age = getage('1980-01-16');

echo $age; // 26
[/code]

[Barand]

A person born in 1986 is 20 this year, BUT, if the birthday is later in the year than today, they are still only 19, so, putting this logic into a function

[code]
<?php
function getAge ($bday, $bmon, $byr) {
    $ynow = date('Y');
   
    $age = $ynow - $byr;
        // format birth month and day as "0901"
    $bmd = sprintf ('%02d%02d', $bmon, $bday);
        // format today monthand day in same way
    $mdnow = date('md');
   
    if ($bmd > $mdnow) $age -= 1;  // sub 1 from age if not there yet
   
    return $age;
}

// call the function to get the age
$age = getAge ($bday_day, $bday_month, $bday_year);

echo $age;

?>
[/code]

[MrLarkins.com]

hey, that looks like a winner.  but it leaves me with two new problems


1]  my birthday data is from seperate columns in the database.  how would i merge them to make it the necessary formatting for your code?

2]  my birthday data is of the form YYYY for year, M for month, and D for day, when it needs to be (YYYY-MM-DD). i.e.  the 1st shows as '1' not '01' and August shows as '8' not '08'.  would i use a push to add the preceeding zeros? 

[Barand]

??? ???

1 ) my function passes the date as the 3 separate fields
2 ) it reformats month "1" as "01" and day as "01"

[MrLarkins.com]

lol, Barand my response was to the other guy, you posted while i was typing,lol

[redbullmarky]

and to be fair, the function I use is one I wrote ages back and whilst it's worked for me, it's a bit crusty. looking at the one provided by Barand, his is much simpler - I'll probably be switching very soon :)

[MrLarkins.com]

hmm, barand, should i modify the function getAge ([b]$bday, $bmon, $byr[/b]) to show bday_day,bday_month,bday_year?  i copied and pasted it straight into place and it gave me an error on that line

[Barand]

The variable names in the function definition are irrelevant, they could be $a, $b, $c.

It depends on what your code is to call the function.


@RedBull,

A problem with passing YYYY-MM-DD then using php datetime functions to convert  is that it doesn't work if the DOB is earlier than 1970 with older version of PHP. Later ones create -ve timestamp values for older dates.

PS a general observation, your explodes the "YYYY-MM-DD" date.

[MrLarkins.com]

ok, so why do i get the error?

[url=http://www.ice-squad.com/Memberslist.php]http://www.ice-squad.com/Memberslist.php[/url] <--see here

[Barand]

That error is telling you that the function is defined more than once in your code.

[MrLarkins.com]

hmm, i don't see where it is...you look...[code]<?php
//----------------------------
// Require
//----------------------------
require "forums/conf_global.php"; //because this file will not be located in the forums directory.

//-------------------------------
// Connect To MySQL
//-------------------------------
mysql_connect($INFO['sql_host'], $INFO['sql_user'], $INFO['sql_pass']) or die(mysql_error());
mysql_select_db($INFO['sql_database']) or die(mysql_error());


$define_country = array("u"=>"United States","e"=>"England","c"=>"Canada","m"=>"Mexico","a"=>"Aruba","o"=>"Other");
$define_state = array("AL"=>"Alabama","AK"=>"Alaska","AZ"=>"Arizona","AR"=>"Arkansas","CA"=>"California","CO"=>"Colorado","CT"=>"Connecticut","DE"=>"Delaware","DC"=>"District of Columbia","FL"=>"Florida","GA"=>"Georgia","HI"=>"Hawaii","ID"=>"Idaho","IL"=>"Illinois","IN"=>"Indiana","IA"=>"Iowa","KS"=>"Kansas","KY"=>"Kentucky","LA"=>"Louisiana","ME"=>"Maine","MH"=>"Marshall Islands","MD"=>"Maryland","MA"=>"Massachusetts","MI"=>"Michigan","MN"=>"Minnesota","MS"=>"Mississippi","MO"=>"Missouri","MT"=>"Montana","NE"=>"Nebraska","NV"=>"Nevada","NH"=>"New Hampshire","NJ"=>"New Jersey","NM"=>"New Mexico","NY"=>"New York","NC"=>"North Carolina","ND"=>"North Dakota","MP"=>"Northern Mariana Islands","OH"=>"Ohio","OK"=>"Oklahoma","OR"=>"Oregon","PA"=>"Pennsylvania","PR"=>"Puerto Rico","RI"=>"Rhode Island","SC"=>"South Carolina","SD"=>"South Dakota","TN"=>"Tennessee","TX"=>"Texas","UT"=>"Utah","VT"=>"Vermont","VI"=>"Virgin Islands","VA"=>"Virginia","WA"=>"Washington","WV"=>"West Virginia","WI"=>"Wisconsin","WY"=>"Wyoming","AB"=>"Alberta","BC"=>"British Columbia","MB"=>"Manitoba","NB"=>"New Brunswick","NL"=>"Newfoundland and Labrador","NT"=>"Northwest Territories","NS"=>"Nova Scotia","NU"=>"Nunavut","ON"=>"Ontario","PE"=>"Prince Edward Island","QC"=>"Quebec","SK"=>"Saskatchewan","YT"=>"Yukon","OO"=>"Other");
$define_character = array("m"=>"Medic","g"=>"Gunner","r"=>"Rifleman","s"=>"Sniper","e"=>"Engineer");

//Start HTML Table
print('<table cellspacing=0 cellpadding=0 width=100%>');
//-----------------------------------
//Get Info
//-----------------------------------
$main_result = mysql_query("SELECT m.id, m.name, m.email, m.joined, m.bday_day, m.bday_month,
    m.bday_year, x.icq_number, c.field_1, c.field_2, c.field_3, c.field_4
FROM ibf_members AS m
INNER JOIN ibf_member_extra AS x ON m.id = x.id
INNER JOIN ibf_pfields_content AS c ON m.id = c.member_id
WHERE mgroup=7
ORDER BY id");
while($main = mysql_fetch_array($main_result)) { //while you have records available from the SELECT query
    $id = $main['id'];
    $name = $main['name'];
    $email = $main['email'];
    $join_date = $main['joined'];
    $bday_day = $main['bday_day'];     
    $bday_month = $main['bday_month'];
    $bday_year = $main['bday_year'];   
    $icq = $main['icq_number'];
    $stats = $main['field_1'];
    $character = $main['field_2'];
    $country = $main['field_3'];
    $state = $main['field_4'];

function getAge ($bday, $bmon, $byr) {
    $ynow = date('Y');
   
    $age = $ynow - $byr;
        // format birth month and day as "0901"
    $bmd = sprintf ('%02d%02d', $bmon, $bday);
        // format today monthand day in same way
    $mdnow = date('md');
   
    if ($bmd > $mdnow) $age -= 1;  // sub 1 from age if not there yet
   
    return $age;
}

// call the function to get the age
$age = getAge ($bday_day, $bday_month, $bday_year);

echo $age;


echo ("<tr><td>$name </td><td>JOINED $join_date</td><td><img src='images/flags/$define_country[$country].gif' border=1 alt='$define_country[$country]'> <img src='images/flags/$define_state[$state].gif' border=1 alt='$define_state[$state]'></td><td><a href='http://web.icq.com/whitepages/add_me?uin=$icq_number&action=add'><font size='-1'>$icq_number</font></a></td><td><a href='mailto:$email'><font size='-1'>Email</font></a></td><td>AGE $age</td><td><a href='$stats'><font size=-1><b><u>JO Stats</u></b></a></td><td>$define_character[$character]</td></tr>");
}


//Finish the HTML table
print('</table>');

?>[/code]

[redbullmarky]

you've wrapped your function in your 'while' loop - meaning it'll get redeclared on each iteration.

move the function to the top of your script - underneath the

[code]
<?php
require "forums/conf_global.php"; //because this file will not be located in the forums directory.
?>
[/code]

will do the trick.

[MrLarkins.com]

argh, now i have extra numbers!

[MrLarkins.com]

lol, i'm such a bonehead sometimes...its all good, thanks for the help, this topic is done...