Re: insert a special character

Hi,

> I have a string with ' this symbol in the middle of the text
> example:-
> " that book belong to rahul's sister"
>
> this string is to be stored in the variable "$strexp"
> when I am inserting this variable in database table
> following error apperes
>
>
> " parse error at or near "s" "
>
> How can I read the string and store in a variable and insert the same
>into the database table ?

Use the addslashes function.

Basically:
$newstring = addslashes($oldstring);
or
$newstring = addslashes("this is some sampl''e text''");

See http://www.php.net/addslashes for more details.

Then, when you get it out of the database you need to stripslash the
string. (Does the above in reverse).

HTH,

-----------------
Chris Smith
http://www.squiz.net/