Jump to content

Getting now() date to show up in database


Recommended Posts

Usine DreamweaverMX, MySQL, PHPadmin.

 

What is the PHP code that I place the now() in, so that the current date will show up in my DB once a web form has been submitted?

 

My DB field is "submit_date", the type is "DATE". It adds the default 0000-00-00. But in all my tests I still get the "0000-00-00" with every entry.

 

Is there some code I need to place on the page using the now()? I thought that the DB would auto fill in a date on submit?

 

Thanks!

Lynne

Link to comment
Share on other sites

Hi man,

 

Now() will get you a result like: 0000-00-00 00:00:00. Otherwise you could change the column to a datetime.

 

If you want the date only, then use the date() function in PHP.

 

date('Y-m-d')

 

This will return:

2004-01-18

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.