当我重新加载页面时,我在将日期发布到我的数据库中遇到了问题。我希望它可以自动时间戳最后一个条目。
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8" />
<title>Location Tracker</title>
</head>
<body>
<hl> ACW Location Tracker </hl>
<?php
$server = 'SQL2008.net.dcs.hull.ac.uk';
$connectionInfo = array("Database"=>"rde_531545");
$conn = sqlsrv_connect($server,$connectionInfo);
$query='create table Location ';
$query .= '(Username int NOT NULL IDENTITY(500, 23), First_Name varchar(50) NOT NULL, Surname varchar(50) NOT NULL, Current_Location varchar(50) NOT NULL, Date datetime NOT NULL, PRIMARY KEY (Username))';
$result = sqlsrv_query($conn, $query);
if (!$result)
{
if( ($errors = sqlsrv_errors() ) != null)
{
foreach( $errors as $error ) {
echo "<p>Error: ".$error[ 'message']."</p>";
}
}
}
else {
echo "<p>DB successfully created</p>";
}
sqlsrv_close($conn);
$connectionInfo = array( "Database"=>"rde_531545");
$conn = sqlsrv_connect($server,$connectionInfo);
$insert_query = "INSERT INTO Location (First_Name, Surname, Current_Location, Date) VALUES (?, ?, ?,? )";
$params = array("John","Doe","Hull", Date);
$result = sqlsrv_query($conn,$insert_query,$params);
$params = array("Jane","Doe","Hull", Date);
$result = sqlsrv_query($conn,$insert_query,$params);
$LocationQuery='SELECT Username, First_Name, Surname, Current_Location, Date FROM Location';
$results = sqlsrv_query($conn, $LocationQuery);
if ($results) while($row = sqlsrv_fetch_array($results, SQLSRV_FETCH_ASSOC))
{
echo '<p>'.$row['Username'].' '.$row['First_Name'].' '.$row['Surname'].' '.$row['Current_Location'].' '.$row['Date'].'</p>';
}
?>
</body>
</html>
我遇到的错误是:
注意:使用未定义的常数日期 - 假定的"日期" c: rdeusers net net 531545 location.php on Line 44
警告:date_create()[function.date-reate]:依靠不安全 在系统的时区设置上。您是所需的 date.timezone设置或date_default_timezone_set()函数。在 案例您使用了
enter code here
这些方法,但您仍然是 获取此警告,您很可能拼错了时区 标识符。我们在C: rdeusers net net 531545 location.php上选择了" 0.0/no dstenter code here
"的"欧洲/伦敦"。可捕获的致命错误:类日期时间的对象无法转换 在C: rdeusers net 531545 location.php中的字符串51
您正在发送类Date
,而不是发送字符串'2017-02-03'。
错误在$params = array(....., Date);
在第二行中,从这个代码切片中:
$insert_query = "INSERT INTO Location (First_Name, Surname, Current_Location, Date) VALUES (?, ?, ?,? )";
$params = array("John","Doe","Hull", Date);
您需要创建一个日期对象$date = new DateTime();
在查询中,您需要从中提取字符串,并使用format
函数:
$dateStr = $date->format(''Y-m-d H:i:s'');
然后,在参数中使用$ datester: $params = array("John","Doe","Hull", $dateStr);
编辑1:
$date = new DateTime();
$dateStr = $date->format('Y-m-d H:i:s');
$params = array("John","Doe","Hull", $dateStr);