php - 尝试在文本编辑器中保存更改时出现 Mysql 错误 1064

Question

我正在运行这个website .

当我在(所见即所得)文本编辑器中保存更改时，出现 mysql 错误 1064

这是第一个错误

Database error: Invalid SQL: UPDATE page_master SET page_title = 'Help', page_content = '

MySQL Error: 1064 (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's bid online. We do charge tradesmen a small fee for each quote they send. Howev' at line 1) Session halted.

这是第二个错误

Database error: Invalid SQL: UPDATE page_master SET page_title = 'Terms and Conditions and use', page_content = '

MySQL Error: 1064 (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's web site is available only to individuals who can form legally binding contrac' at line 1) Session halted.

这是我的 SQL 表。

http://pastebin.com/F15P91TM

Answer 1

正如您确认我上面的评论一样，您必须转义要存储在数据库中的字符串。

只需使用real_escape_string函数，请参阅手册:http://www.php.net/manual/en/mysqli.real-escape-string.php

如果您仍在使用已弃用的 mysql_* 函数，则必须使用:http://php.net/manual/de/function.mysql-escape-string.php 。但同样，mysql_* 的使用已被弃用，不应再使用!