Need HELP with fckeditor for PHP.

Hi,

I have configured the editor to insert data into the DB, but how do you return the DB data back into the editor so I can update the existing data?

// SELECT TABLE AND SET VARIABLE WITH DB DATA

$SQL = "SELECT *
FROM postess_selfDescription
WHERE userID = ".$_SESSION['sesUserID']."";

$result = $conn->Execute($SQL);
db_check_result($result);

$selfIntro = $result->fields["selfIntro"];

// END OF SELECT TABLE AND SET VARIABLE WITH DB DATA

This is what I tried so far:

I tried putting the $selfIntro variable inside the editor value field.
$oFCKeditor->Value = ' $selfIntro ' ;

That didn't work.

I tried
$oFCKeditor->Value = ' echo "$selfIntro"; ' ;

That didn't work.

Please Post any solutions.
Thanks in advance.

Mon, 08/20/2007 - 08:44

wiktor

Joined: 16/07/2007

Posts: 1641

Re: Need HELP with fckeditor for PHP.

First of all, make sure that you set $oFCKeditor->Value before calling $oFCKeditor->Create();.

$oFCKeditor->Value = ' echo "$selfIntro"; ' ;

echo is not a function and it doesn't return anything, it simply displays one or more strings, so it can't work.

Here you are using single quotes:

$oFCKeditor->Value = ' $selfIntro ' ;

so PHP will not translate $selfIntro into its value, you have to use double quotes here, or better, no quotes at all:

$oFCKeditor->Value = $selfIntro;

If your problem isn't solved yet, add var_dump($selfIntro) before assigning value to FCKeditor:

print "Testing: ";
var_dump($selfIntro);
die();
$oFCKeditor->Value = $selfIntro;

and check whether $selfIntro actually contains anything.

Wiktor Walc
CTO, CKSource - http://cksource.com
--
Follow CKEditor on: Twitter | Facebook | Google+

Mon, 08/20/2007 - 22:10

xengvang

Joined: 17/08/2007

Posts: 7

Re: Need HELP with fckeditor for PHP.

Thanks so much. That solved my problem. I knew it was something simple, never thought about removing the single and double qoutes.

Thanks a lot. FCKeditor ROCKS!!! :mrgreen:

Mon, 08/20/2007 - 22:59

xengvang

Joined: 17/08/2007

Posts: 7

Re: Need HELP with fckeditor for PHP.

I have another problem now. I added an hyperlink and it inserts fine in the DB but when I display that URL, it appears like this:

http://www.postess.com/myprofile.php?us ... _Xeng_Vang

But the target path is this: http://www.postess.com/%22http://www.po ... _Xeng_Vang\"

Any reasons why it is doing this?

Thanks