Very small code to get Age:

<?php
 $dob='1981-10-07';
 $diff = (date('Y') - date('Y',strtotime($dob)));
 echo $diff;
?>

//output 35

Got this script from net (thanks to coffeecupweb)

<?php
/**
 * Simple PHP age Calculator
 * 
 * Calculate and returns age based on the date provided by the user.
 * @param date of birth('Format:yyyy-mm-dd').
 * @return age based on date of birth
 */
function ageCalculator($dob)
 if(!empty($dob))
 $birthdate = new DateTime($dob);
 $today = new DateTime('today');
 $age = $birthdate->diff($today)->y;
 return $age;
 else
 return 0;
 

$dob = '1992-03-18';
echo ageCalculator($dob);
?>

Reference Link http://www.calculator.net/age-calculator.html

$hours_in_day = 24;
$minutes_in_hour= 60;
$seconds_in_mins= 60;

$birth_date = new DateTime("1988-07-31T00:00:00");
$current_date = new DateTime();

$diff = $birth_date->diff($current_date);

echo $years = $diff->y . " years " . $diff->m . " months " . $diff->d . " day(s)"; echo "<br/>";
echo $months = ($diff->y * 12) + $diff->m . " months " . $diff->d . " day(s)"; echo "<br/>";
echo $weeks = floor($diff->days/7) . " weeks " . $diff->d%7 . " day(s)"; echo "<br/>";
echo $days = $diff->days . " days"; echo "<br/>";
echo $hours = $diff->h + ($diff->days * $hours_in_day) . " hours"; echo "<br/>";
echo $mins = $diff->h + ($diff->days * $hours_in_day * $minutes_in_hour) . " minutest"; echo "<br/>";
echo $seconds = $diff->h + ($diff->days * $hours_in_day * $minutes_in_hour * $seconds_in_mins) . " seconds"; echo "<br/>";

For a birthday date with format Date/Month/Year

function age($birthday)
 list($day, $month, $year) = explode("/", $birthday);
 $year_diff = date("Y") - $year;
 $month_diff = date("m") - $month;
 $day_diff = date("d") - $day;
 if ($day_diff < 0 && $month_diff==0) $year_diff--;
 if ($day_diff < 0 && $month_diff < 0) $year_diff--;
 return $year_diff;

or the same function that accepts day, month, year as parameters :

function age($day, $month, $year)
 $year_diff = date("Y") - $year;
 $month_diff = date("m") - $month;
 $day_diff = date("d") - $day;
 if ($day_diff < 0 && $month_diff==0) $year_diff--;
 if ($day_diff < 0 && $month_diff < 0) $year_diff--;
 return $year_diff;

You can use it like this :

echo age("20/01/2000");

which will output the correct age (On 4 June, it's 14).

 $dob = $this->dateOfBirth; //Datetime 
 $currentDate = new DateTime();
 $dateDiff = $dob->diff($currentDate);
 $years = $dateDiff->y;
 $months = $dateDiff->m;
 $days = $dateDiff->d;
 $age = $years .' Year(s)';

 if($years === 0) 
 $age = $months .' Month(s)';
 if($months === 0) 
 $age = $days .' Day(s)';
 
 
 return $age;

declare @dateOfBirth date
select @dateOfBirth = '2000-01-01'

SELECT datediff(YEAR,@dateOfBirth,getdate()) as Age

To Calculate age from Date of birth.

$dob = '1991-09-30';
(((int) date("m",strtotime($dob)) >= (int) date('m')) && ((int) date("d",strtotime($dob)) >= (int) date('d'))) 

 ? 
 $age = (date('Y') - date('Y',strtotime($dob))) 
 : 
 $age = (date('Y') - date('Y',strtotime($dob)))-1;

OUTPUT: 26

I hope you will find this useful.

$query1="SELECT TIMESTAMPDIFF (YEAR, YOUR_DOB_COLUMN, CURDATE()) AS age FROM your_table WHERE id='$user_id'";
$res1=mysql_query($query1);
$row=mysql_fetch_array($res1);
echo $row['age'];

There is a simple way to find the date from any birthdate by using substr of PHP

$birth_date = '15.03.2014';
$date = substr($birth_date, 0, 2);
echo $date;

Which will just simply give you the output date of that birth date.

In this case, that will be 15.

See substr of PHP for more...