x10 Elder
PHP / MySQL - Unescaping strings?
HI,
I have a slight problem in that everytime I use the PEAR DB place-holder function (an automantic mysql_real_escape_string) When I next use SELECT to retrieve the data froim the Database The content looks like: "It\'s escaped". Is there an easy way to unescape the strings either through standard php / MySQL or the PEAR DB API?
Thanks
lambada
Lambada - the former Account Manager (before I resigned)
Retired
php - stripslashes($var);
I would love to change the world, but they won't give me the source code
x10 Elder
Worked like a charm.
It's amazing how much stuff a 'through' book can miss out - that being just one example.
Thanks
lambada
Lambada - the former Account Manager (before I resigned)
Retired
np it was nothing for me. the sad thing is i actually had to remember that code. i was like what is that function...
I would love to change the world, but they won't give me the source code
x10Hosting Member
What if the data you are putting/pulling from the Database has HTML code in it?
Just removing slashes could be a bad idea.
Anybody know of a function that unescapes intelligently in that regard?
I hate the idea of writing one when someone ha likely done it. ;)
Abuse Compliance Officer
Still shouldn't matter, html uses / slashes, whereas escaped strings use \Originally Posted by dougyitbos
So <body>it\'s working</body> should still only lose the \, so it'd become <body>it's working</body>.
Should it happen to cut that slash out, you could just use one of the string replace functions (can't remember which right now) and replace "\" with an empty string
TOS breakers will be suspended regardless of race, creed, national origin, hair color, or favorite food. Thanks for your understanding!
x10Hosting Member
ah...
Duh!
I was thinking that the strip slashes was non specific and removed both.
Very nice.
Thanks!
Abuse Compliance Officer
I'm not positive that it only removes one either though; I'm just guessing that it wouldn't since escaped strings use \, and in normal text / doesn't do anything special.
I'll see if I can test that later this evening and see what it does.
TOS breakers will be suspended regardless of race, creed, national origin, hair color, or favorite food. Thanks for your understanding!
Retired
it only removes \
I would love to change the world, but they won't give me the source code
Abuse Compliance Officer
There you go. Thanks for saving me on that too - XAMPP just decided to go chest-up right as I was ready to test it >_<
TOS breakers will be suspended regardless of race, creed, national origin, hair color, or favorite food. Thanks for your understanding!
Posting Permissions
LinkBack URL
About LinkBacks
Reply With Quote