How to collect Date of birth from php form and insert into mysql?

I am new to programming, have done a few things but i have no idea how to collect dob information. How do i collect it from a form and how do i insert it? Do i use three fields: month/day/year and then in the db also have three columns?

Is there a开发者_StackOverflow tutorial i can be pointed to?

Thanks

Depending on what you're going to do with the data (if it's not going to be too complex), you could simply reformat the submitted form:

$bday = date('Y-m-d',strtotime($_POST['userSubmittedBDay']));

and insert that into the database as a string. The above example would give you the format 2011-01-26

Sorry if this is a cheeky response, but with a little Google-ing this answer can be found rather easily.

1. Create a form
2. Collect data from that form
3. Sanitize that input
4. Insert into database