在PHP中我应该使用今天的日期函数还是来自MySQL的curdate（）？

Question

I'm writing a PHP/MySQL program. I need to add the current date each time a new record to the TABLE is added. I have a field called DATE_ADDED. I'm confused how to use CURDATE() function from MySQL to write this to the TABLE. Or should I from PHP use a date function to get today's date and pass it as a variable to be written to the TABLE? I don't need a TIMESTAMP, just YYYY-MM-DD. Thanks!

Answer 1

You have to try with php like

$today = date("Y-m-d");

and then while adding data to your db give this value with the remaining