我在查询时遇到问题。此查询适用于 phpMyAdmin,但是当 PHP 执行此查询时,我遇到了错误。可能是什么原因?
我的PHP代码是:
var_dump($sql);
query($sql);
当我调试时:
这是查询字符串:
UPDATE searchcolumnsets SET name = "Project X",jsonfields = "[{'"name'":'"cm:contentPropertyName'",'"title'":'"Thumbnailed Content Property Name'",'"description'":'"'",'"datatype'":'"'"},{'"name'":'"cm:defaultHomeFolderPath'",'"title'":'"Percorso cartella homepage'",'"description'":'"'",'"datatype'":'"'"},{'"name'":'"trx:enabled'",'"title'":'"Abilitato'",'"description'":'"'",'"datatype'":'"'"},{'"name'":'"cm:identifier'",'"title'":'"Identificativo'",'"description'":'"'",'"datatype'":'"'"},{'"name'":'"cm:expiryDate'",'"title'":'"Data di scadenza'",'"description'":'"Data di scadenza'",'"datatype'":'"d:date'"},{'"name'":'"cm:hits'",'"title'":'"Conteggio'",'"description'":'"Conteggio'",'"datatype'":'"d:int'"}]" WHERE id = 50
这是错误:
您的 SQL 语法有错误;请查看与您的 MySQL 服务器版本对应的手册,了解在"name":"cm:contentPropertyName"、"title":"缩略图内容属性名称"、"desc"旁边的正确语法
你可以改用单个qoute。试试这个
UPDATE searchcolumnsets SET name = 'Project X',jsonfields = '[{'"name'":'"cm:contentPropertyName'",'"title'":'"Thumbnailed Content Property Name'",'"description'":'"'",'"datatype'":'"'"},{'"name'":'"cm:defaultHomeFolderPath'",'"title'":'"Percorso cartella homepage'",'"description'":'"'",'"datatype'":'"'"},{'"name'":'"trx:enabled'",'"title'":'"Abilitato'",'"description'":'"'",'"datatype'":'"'"},{'"name'":'"cm:identifier'",'"title'":'"Identificativo'",'"description'":'"'",'"datatype'":'"'"},{'"name'":'"cm:expiryDate'",'"title'":'"Data di scadenza'",'"description'":'"Data di scadenza'",'"datatype'":'"d:date'"},{'"name'":'"cm:hits'",'"title'":'"Conteggio'",'"description'":'"Conteggio'",'"datatype'":'"d:int'"}]' WHERE id = 50