Translating date to age

Question

Hello forum buddies.I am trying to translate a date of birth in php. I collect a users date of birth and insert it into a php database as 30 character VARCHAR. I would like to query the date of birth and translate them into an age number how could I do this. The date of birth is collected using select menus like day month year and inserted as a varchar. How could I then translate that to a age number.Thank you.

David_Powers · Accepted Answer

Thanks again for the replyJust for verification does the code below then give a single number age of the user i.e 25.<?Php/*The translation code then results*/$userage=$row['age'];echo $userage;?>Thanks again I will check out the cookbook when I can.Tony404 wrote:Just for verification does the code below then give a single number age of the user i.e 25.Yes.

bregent · Answer

>I collect a users date of birth and>insert it into a php database as>30 character VARCHAR.It's generally a bad idea to store date data as anything other than date datatypes. The way the user interface works here is irrelevent. Take the user input, convert and store in the DBMS as a date.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded