我确信这是我遗漏的一些愚蠢的东西,但是谁能找出为什么下面的方法不起作用:
#sanitise variables
$player1 = GetSQLValueString($_POST['player1'], "text");
$battle = GetSQLValueString($_POST['battle'], "text");
$subject = "You Have Registered For ".$battle."";
$subject = GetSQLValueString($subject, "text");
$message = "You Have Registered For ".$battle."<br /><br />
Keep an eye on your PM's, it won't take long before your challenger appears!";
$message = GetSQLValueString($message, "text");
echo $player1;
echo "<br />";
echo $subject;
echo "<br />";
echo $message;
echo "<br />";
echo $time;
echo "<br />";
#insert alerts into private message databases
mysql_select_db($database_conn, $conn);
$query_rsSendAlert = "INSERT INTO site_private_messages
(sender, recipient, read_status, subject, message, `timestamp`)
VALUES ('Admin', $player1, 'n', $subject, $message, `$time`)";
mysql_query($query_rsSendAlert, $conn) or die(mysql_error());回声只是为了让我可以在插入之前看到变量(换句话说,是为了帮助发现问题。下面是它输出内容的一个示例:
'ferdia'
'You Have Registered For \'Fifa 11 Fracus!\''
'You Have Registered For \'Fifa 11 Fracus!\'
Keep an eye on your PMs, it won\'t take long before your challenger appears!'
1304866340表格格式如下:
CREATE TABLE `site_private_messages` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`sender` varchar(30) DEFAULT NULL,
`recipient` varchar(30) DEFAULT NULL,
`read_status` varchar(1) DEFAULT NULL,
`subject` varchar(200) DEFAULT NULL,
`message` text,
`timestamp` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=39 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;有什么建议吗?
发布于 2011-05-08 22:57:17
很有可能,您会发现您的列名时间戳是保留字。如果要使用保留字作为列名或表名,则必须将它们括在backticks中
但是回显实际的SQL语句,并进行错误处理,以确定您得到的确切错误消息。养成在使用SQL时使用错误处理的习惯,如果让PHP在发生MySQL错误时实际显示它们,将会省去很多麻烦。
发布于 2011-05-08 23:14:25
values部分应如下所示:
VALUES ('Admin', '$player1', 'n', '$subject', '$message', '$time')";发布于 2011-05-08 23:58:38
更改此设置:
$query_rsSendAlert = "INSERT INTO site_private_messages
(sender, recipient, read_status, subject, message, `timestamp`)
VALUES
('Admin', $player1, 'n', $subject, $message, `$time`)";
//Error, no ` allowed in values, use ' instead. ^ ^...into此命令:
$query_rsSendAlert = "INSERT INTO site_private_messages
(sender, recipient, read_status, subject, message)
VALUES
('Admin', $player1, 'n', $subject, $message)";MySQL会自动填写时间戳。
https://stackoverflow.com/questions/5928143
复制相似问题