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

php mysql forms date-of-birth dob
AAA picture AAA · Jan 27, 2011 · Viewed 9.2k times · Source

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 tutorial i can be pointed to?

Thanks

Answer

JakeParis picture JakeParis · Jan 27, 2011

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

Related questions

MySQL Query Within JavaScript

I am working on a form whereby JavaScript is used to add another line item. The purpose is to add line items to an invoice. I have successfully got this to work ok when using text boxes in my form, …

Read More
Can MySQL automatically convert empty strings to NULL?

There is an excellent SO on MySQL empty strings versus NULL here, MySQL, better to insert NULL or empty string?, however it doesn't take in to account 'uniformity' - i.e. if you want to have just one choice in …

Read More
Get Contact Form 7 Form ID In PHP

I'm using contact form 7 to load two different forms into a page and then, in addition to sending the email, dynamically adding that information to a database. Unfortunately, because of the plugin, I can't simply just create all inputs with …

Read More