为什么存储在MySQL中的日期都错了？

Question

I am building a PHP to MySQL webpage and I didn't notice it until now. My date from form field which is posted to PHP script is sent to MySQL table for storage. Even though in the date field within the form is being displayed correctly and POST date value is verified to be exact, it is not going into my MySQL table correctly. For some odd reason, the year is 2006 not 2012. However, the time is correct.

Here is my Form date field:

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

Date Column in my MySQL table is of TYPE DATE.

I did check the date stored in my table and it has wrong date not year 2012 but 2006.

Any Idea,

Answer 1

MySQL's only acceptable date input format is YYYY-MM-DD HH:MM:SS. The date you're generating in PHP will look like (for today) 06/12/12 which MySQL will try to parse, but see as 12th December, 2006, and not the actual June 12/2012.

As well, note that your code is gaping wide open for SQL injection attacks. Read up and learn how to prevent those before you go ANY FARTHER with this code. Otherwise your server is going to get pwn3d.