php echo语句输入字段错误

Question

I get this error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''05/12/13)' at line 2

Because of this code:

<input type="text" name="submitdate" value="<?php echo date('d/m/y'); ?>" readonly>

Any help is appreciated, thanks.

Answer 1

MySQL expects dates to be formatted like "YYYY-MM-DD" rather than "d/m/y".

This will format the date appropriately:

date('Y-m-d');

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