Question

I have a php form where I have to manually input a date. When I type the date as Y/M/D I don t have any problem. But if I enter the date as d/m/y it is stored in my database as 0000-00-00

$TransactionDate= $row[ DealDate ];

TransactionDate = my field name DealDate = my column name

I need Help!

Answer 1

D. 守则

$date = mysql_real_escape_string($_POST[ DealDate ]);

如果贵的MySQL一栏为时标:

$date = date( Y-m-d , strtotime(str_replace( - ,  / , $date)));

如果贵的MySQL栏是DATETIME型:

$date = date( Y-m-d H:i:s , strtotime(str_replace( - ,  / , $date)));

如果时间序列为——你不能使用中途时间,因为它不会与干ash——分离者合作,那么它将努力进行减小。

在此情况下使用定期表达

$date = mysql_real_escape_string($_POST[ DealDate ]);
$date = preg_replace( #(d{2})/(d{2})/(d{4})s(.*)# ,  $3-$2-$1 $4 , $date);
echo $date;

Answer 2

唯一可接受的直接使用日期格式是<代码>。 YYYY-mm-dh:mm:s。插入其他内容几乎总是会增加1 000-00美元的违约日值。

If your date string is in some other format, you ll have to massage it into a MySQL-acceptable format first.

友情链接