replacing backslash string in php
I need to replace \b with \\b in php in order to insert into mysql table.
Therefore \bhello\b becomes \\bhello\\b then inserted into mysql where it is converted back to \bhello\b开发者_JS百科.
But I can't seem to figure out how. Tried preg_replace and str_replace and I always end up with an error or what I started with.
Sounds like you need to use the correct escaping mechanism for your database.
For the record, this is definitely not addslashes()
.
If using mysql_*()
, then use mysql_real_escape_string()
.
If using PDO, use bound parameters with prepared statements.
精彩评论