Importing Text from SQL

Hi all,

FCK is loading up great for me, but I have one problem:

How do I have the editor load up text from SQL, while keeping all the formatting?

Right now, I am successfully loading text into the editor using this in PHP:

$oFCKeditor->Value = $newstext;

$newstext being the variable where my text is stored. The problem is, when it shows up in the editor you can see all of the <span> tags, etc...

Am I doing something wrong?

Thanks!!!

Tim

Wed, 12/15/2004 - 16:28

deskpro

Joined: 08/12/2004

Posts: 24

RE: Importing Text from SQL

Sounds like a problem with the data itself, did you htmlspecialchars() the data before putting it in the database?

Wed, 12/15/2004 - 16:29

xenden

Joined: 08/04/2006

Posts: 321

RE: Importing Text from SQL

You are probably encoding things in HTML, which turns the > into > and less than (<) to <

You can 'fix' it by putting it 'straight' into the database, or transforming it when you pull it out.

Remember the XSS vulnerabilities... If you have this somewhere public you'll probably want to parse the input/output so as to be sure things are 'safe'. Someone posted some excellent resources in the XSS thread, you might look at that...

Wed, 12/15/2004 - 16:43

deskpro

Joined: 08/12/2004

Posts: 24

RE: Importing Text from SQL

Xenden, do you mean this thread?

https://sourceforge.net/forum/message.p ... id=2887747

Or another one?