When I run the following query it sometimes works and sometimes it doesn't. The problem is that sometimes the $EncryptedString contains characters like this: ')')
which causes syntax errors. The $EncryptedString contains binary data, how can I go about this issue?
推荐答案
转义你的加密字符串
mysql-real-escape-string
mysql_real_escape_string() 调用 MySQL 的库函数mysql_real_escape_string，将反斜杠添加到以下内容字符:x00、
、
、、'、" 和 x1a.
mysql_real_escape_string() calls MySQL's library function
mysql_real_escape_string, which prepends backslashes to the following
characters: x00,
,
, , ', " and x1a.
