mysql_calc_age.php

来自「php源码 php源码参考」· PHP 代码 · 共 17 行

<?php
 // set date for calculation
 $day = 18;
 $month = 9;
 $year = 1972;

 // format birthday as an ISO 8601 date
 $bdayISO = date("c", mktime ('', '', '', $month, $day, $year));

 // use mysql query to calculate an age in days
 $db = mysqli_connect('localhost', 'user', 'pass');
 $res = mysqli_query($db, "select datediff(now(), '$bdayISO')");
 $age = mysqli_fetch_array($res);

 // convert age in days to age in years (approximately)
 echo "Age is ".floor($age[0]/365.25);
?>