Re: insert a special character

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



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/



[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux