在调用DATE函数输入时间到数据库的时候出现有关问题!高手指导啊
程序员文章站
2022-06-15 16:22:11
...
在调用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() [ function.date ]: 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 ");
...
试试看
在调用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() [ function.date ]: 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 ");
...
试试看
相关文章
相关视频