Skip to main content
C
Chris_Harris71
Participant
May 19, 2009
Question

Help with inserting Date into MySQL DB from registration form input

  • May 19, 2009
  • 2 replies
  • 707 views

I'm trying to automatically input the registration date of a customer into my MySQL DB. Nothing seems to work. I've tried timestamp in a table field, I've tried a hidden field in the form. Any suggestions?

This topic has been closed for replies.

2 replies

A
Anonymous
May 22, 2009

You can use NOW() in the insertion record code, it will display like a time stamp format (date + time). Otherwise u can use this if u just want to store the date, $today = date("j F Y "); . It will display like 21 May 2009. Further information about date() function you can get it HERE.

David_Powers
David_Powers
Inspiring
May 19, 2009

When defining your table in MySQL, use a TIMESTAMP column. MySQL stores all dates, including timestamps in the format YYYY-MM-DD HH:MM:SS. If you are trying to insert the date in any other format, MySQL won't accept it, and converts it to 0000-00-00 00:00:00

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices