插入CKEditor HTML到数据库

Question

Upload Error: 
UPDATE pages set page_title = 'Test Update', page_description = 'Test Update', page_content = '
This is content! Update!
rn' WHERE id = 
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 '' at line 1

当我提交表单更新记录时，我如何克服这个错误?

Answer 1

您必须以某种方式对数据进行编码。并在检索时解码。