PHP Set Now to format YYYY-MM-DD

Question

I need to set a variable to the current date in this format: eg: 2012-05-12 , I get that's YYYY-MM-DD ?

I've tried:

$date = date("yyyy-mm-dd", strtotime(now)); 

but this is not saving the date to mysql so it's coming out as 0000-00-00.

The field is set as type: date in the mysql db.

What am I doing wrong here?

Answer 1

Easy:

$date = date('Y-m-d');

see http://php.net/manual/en/function.date.php

Answer 2

Always check the documentation, and you’ll find the format you’ll need is:

<?php date('Y-m-d'); ?>

EDIT: Also, you don’t need to specify the time as the second parameter, as date() will use now by default. It should be noted that your syntax there is wrong too though, as it would be strtotime('now'), as “now“ is a string it needs to be quoted.