将日期和时间插入到Mysql中 [英] Insert date and time into Mysql
本文介绍了将日期和时间插入到Mysql中的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我的代码。
//日期值为05/25 / 2010
//时间值为10:00
$ date = $ _ POST ['date'];
$ time = $ _ POST ['time'];
$ datetime = $ date。$ time
如果我插入$ datetime进入mysql,日期似乎是0000-00-00:00:00:00
如果有任何人可以帮助我,我感激一下。谢谢。
解决方案
$ datetime = $ _POST ['date']。 。 $ _POST ['time']。 ':00';
$ datetime = mysql_real_escape_string($ datetime);
$ query =INSERT INTO table(timestamp)VALUES('$ datetime');
可以处理更多格式的替代解决方案:
$ datetime = $ _POST ['date']。 。 $ _POST ['time'];
$ datetime = mysql_real_escape_string($ datetime);
$ datetime = strtotime($ datetime);
$ datetime = date('Y-m-d H:i:s',$ datetime);
$ query =INSERT INTO table(timestamp)VALUES('$ datetime');
I am trying to insert date and time into mysql datetime field. When a user select a date and time, it will generate two POST variables. I have searched internet but still not sure how to do it.
My code.
//date value is 05/25/2010
//time value is 10:00
$date=$_POST['date'];
$time=$_POST['time'];
$datetime=$date.$time
If I insert $datetime into mysql, the date appears to be 0000-00-00:00:00:00
I appreciate it if anyone could help me about this. Thanks.
解决方案
$datetime = $_POST['date'] . ' ' . $_POST['time'] . ':00';
$datetime = mysql_real_escape_string($datetime);
$query = "INSERT INTO table(timestamp) VALUES ('$datetime')";
alternative solution that can handle more formats:
$datetime = $_POST['date'] . ' ' . $_POST['time'];
$datetime = mysql_real_escape_string($datetime);
$datetime = strtotime($datetime);
$datetime = date('Y-m-d H:i:s',$datetime);
$query = "INSERT INTO table(timestamp) VALUES ('$datetime')";
这篇关于将日期和时间插入到Mysql中的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文