在调用DATE函数输入时间到数据库的时候出现问题!高手指导啊!
在调用DATE函数输入时间到数据库的时候出现问题!高手指导啊!
我的代码如下
<?
$date=date( "Y-m-d H:i:s ");
$conn=new mysqli( 'localhost ', 'root ', '123 ', 'time ');
if (mysqli_connect_errno()) {
echo '不能连接数据库。 ';
exit();
}
echo $date;
$query= "insert into time values(null,$date) ";
$re=$conn-> query($query);
if (!$re) {
echo '输入数据失败! ';
exit();
}
echo '成功 ';
$conn-> close();
?>
总是显示失败
出错信息是
调试 Strict(PHP 5):C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\timetest.php 行 2 - date() [ <a href= 'function.date '> function.date </a> ]: It is not safe to rely on the system 's timezone settings. Please use the date.timezone setting, the TZ environment variable or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'UTC ' for '8.0/no DST ' instead
谢谢指点!
[解决办法]
date_default_timezone_set( 'PRC ');
$date=date( "Y-m-d H:i:s ");
...
试试看