replacing backslash string in php

Question

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.

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.

I am seeing the same as in "I need to replace x with x", seems the editor ate a few chars?. edit seems you corrected it. — derp
– derp, Commented Sep 22, 2011 at 23:11
Am I missing something, or are you trying to replace a string with the exact same string? A good way to do this is $result = '\bhello\b';. Magic. — adlawson
– adlawson, Commented Sep 22, 2011 at 23:13

Community · Accepted Answer · 2023-11-14 22:25:35Z

6

Sounds like you need to use the correct escaping mechanism for your database.

If using PDO, use bound parameters with prepared statements.

CommunityBot

11 silver badge

answered Sep 22, 2011 at 23:12

alex

492k205 gold badges890 silver badges992 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1