1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
| public function get_age($idpat)
{
// Années
$query = $this->db->query('SELECT TIMESTAMPDIFF(YEAR, date_age, NOW()) as annee FROM personnes WHERE id ="'.$id.'" ');
foreach($query->result() as $row)
{
$nb_annee = $row->annee;
}
$annee = $nb_annee == 0 ? '' : ($nb_annee > 1 ? $nb_annee.' Ans ' : $nb_annee.' An ');
// Mois
$query = $this->db->query('SELECT TIMESTAMPDIFF(MONTH, date_age, NOW()) as mois FROM personnes WHERE id ="'.$id.'" ');
foreach($query->result() as $row)
{
$nb_mois = $row->mois;
}
$nb_mois = $nb_mois - ($nb_annee*12);
$mois = $nb_mois == 0 ? '' : $nb_mois.' Mois ';
// Jours
$query = $this->db->query('SELECT TIMESTAMPDIFF(DAY, date_age, NOW()) as jour FROM personnes WHERE id ="'.$id.'" ');
foreach($query->result() as $row)
{
$nb_jour = $row->jour;
}
$nb_jour = $nb_jour - ($nb_annee*365 + $nb_mois*31);
$jour = $nb_jour == 0 ? '' : ($nb_jour > 1 ? ' '.$nb_jour.' Jours. ' : ' '.$nb_jour.' Jour.');
$age = $annee.$mois.$jour;
echo $age;
} |
Partager