LynneM Posted January 14, 2004 Share Posted January 14, 2004 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 Quote Link to comment https://forums.phpfreaks.com/topic/1614-getting-now-date-to-show-up-in-database/ Share on other sites More sharing options...
Pidde Posted January 15, 2004 Share Posted January 15, 2004 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 Quote Link to comment https://forums.phpfreaks.com/topic/1614-getting-now-date-to-show-up-in-database/#findComment-5300 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.