Replace ' with \' help - urgent please

[invision2]

How do I do this with PHP?

Is it just $text = str_replace("'","\'", $text); ?


Many thanks for any help.

[krzyk]

Have you tried it?
It works on my php.

[AnthonySterling]

Wouldn't the native addslashes and stripslashes be more appropriate?

<?php
$sString = addslashes("'''''''"); 
echo $sString; #\'\'\'\'\'\'\'
$sString = stripslashes($sString);
echo $sString; #'''''''
?>

[invision2]

Aaaah. Thanks guys.

Basically I'm using the TinyMCE editor to insert text in <textarea>'s and if my text was:

Hi, I'm Michael

then it would still try to enter Hi, I'm Michael into the db, rather than making it Hi, I\'m Michael.

So should I try $descr = addslashes($descr); to fix this ?

I'm escaping all my data and it works great, except those using the TinyMCE editor.

[invision2]

Heh, my first one did work. How about that
Yep, it definitely works. I'm chuffed.

I've got a few questions I might try to get answered in the next few days, to get my head around slashes and such.