Problems with '

My editor works great until someone attempts to use a ' in their text. If they do, the data is not saved. For example if I use the word can not, it saves, if I use the word can't it will not save. Is this a problem with the editor or my database type?

Thu, 03/15/2007 - 08:27

snefit

Joined: 24/01/2007

Posts: 12

RE: Problems with '

you'll have to 'escape' text before sending it to the database.

Thu, 03/15/2007 - 09:28

evick

Joined: 15/03/2007

Posts: 2

RE: Problems with '

Thanks for the solution, I used mysql_real_escape_string() and it works like a charm!

Mon, 03/19/2007 - 07:54

bill99

Joined: 19/03/2007

Posts: 1

RE: Problems with '

I'm having the same problem I think. When people enter a single quote in text our database is rejecting it. What I was wondering though is whether I can make this substitution in the fckeditor_php4.php file? This file contains a function:

function EncodeConfig( $valueToEncode )
{
$chars = array(
'&' => '%26',
'=' => '%3D',
'"' => '%22' ) ;

return strtr( $valueToEncode, $chars ) ;
}

I tried modifying this file as follows:
function EncodeConfig( $valueToEncode )
{
$chars = array(
'&' => '%26',
'=' => '%3D',
'\'' => '%29',
'"' => '%22' ) ;

return strtr( $valueToEncode, $chars ) ;
}

but it didn't seem to work. Should this work and I'm jut doing ti wrong or is this not the place to try and do it?

Any suggestions much appreciated.

Bill