php+mysql+fckeditor

Are you saying that the text you want to edit isn't visible or the editor itself isn't visible?

Yes I have this same problem (or similar)

Hi hunmeridian

I've had this problem before.

I simply stripslashes() when selecting on the edit page.

IE You stripslashes() for the display page. Also use this methodology for the edit page.

Cheers

Richard

I am doing this:
=============
<TABLE width=80% border=0 cellpadding=2>
<FORM method=POST enctype='multipart/form-data'>
<INPUT type=hidden name=mode value="update">

<? if ($header_content_result) {
    while ($row = mysql_fetch_array ($header_content_result)) {
?>

<INPUT type=hidden name=header_content_id value="<? echo $row["header_content_id"]; ?>">

<TR>
<TD bgcolor=DDDDDD><b>Content Name : </b></TD>

    <TD bgcolor=EEEEEE><INPUT type=text size=24 name=header_content_name value="<? echo $row["header_content_name"]; ?>"></TD>

</TR>
<TR>
<TD bgcolor=DDDDDD valign=top><b>Content : </b></TD>
<TD bgcolor=EEEEEE>

    <?php
    function prepTextForEditor($in) 
    { 
    $out = str_replace(chr(10), "", $in);  
    $out = str_replace(chr(13), "", $out);  
    return str_replace("'", "\'", $out); 
    } 

     $strTEXT = $row["header_content"];
    ?>

<script type="text/javascript">
var oFCKeditor = new FCKeditor( 'header_content' ) ;
oFCKeditor.Height = 300 ; // 400 pixels
oFCKeditor.Width = "100%" ; // 250 pixels

       oFCKeditor.Value =  "<?php echo prepTextForEditor($strTEXT);?>" ;

oFCKeditor.Create() ;
</script>
</TD>
</TR>
<TR>
<TD bgcolor=DDDDDD valign=top><b>Active : </b></TD>

     <TD bgcolor=EEEEEE><INPUT type=checkbox name=header_content_active value="Y"<? if ($row["header_content_active"] == "Y") echo " checked"; ?>></TD>

</TR>
<TR>
<TD colspan=2><INPUT type=submit value="Update Content">&nbsp;&nbsp;&nbsp;<INPUT type=button value="Cancel" onClick="self.location='header_content.php'"></TD>
</TR>
</FORM>

<?
   }
  }
?>

</TABLE>
=============
and still crashes, what am I missing????

It appears to me that javascript wants the content which you get from your database as one single line. So for example when there is a ; in your content it will complain about a missing quote and FCK wont show up.

Because i was too lazy too add '\r\n' at the content i finaly called FCK whith the PHP-way.
Like this:

<?php
$oFCKeditor = new FCKeditor('header_content') ;
$oFCKeditor->BasePath = '/cms/FCKeditor/';
$oFCKeditor->Value = prepTextForEditor($strTEXT);
$oFCKeditor->Width = "100%" ;
$oFCKeditor->Height = "300" ;
$oFCKeditor->Create() ;
?>

Good luck!

This WORKED!!! What the!?!?!?!


function prepTextForEditor($in)
{
$out = str_replace(chr(10), "", $in);
$out = str_replace(chr(13), "", $out);
$out = str_replace(chr(34), "'", $out);
return str_replace("'", "\'", $out);
}

$strTEXT = $row["header_content"];
?>
<script type="text/javascript">
var oFCKeditor = new FCKeditor( 'header_content' ) ;
oFCKeditor.Height = 300 ; // 400 pixels
oFCKeditor.Width = "100%" ; // 250 pixels

       oFCKeditor.Value =  "<?php echo prepTextForEditor($strTEXT);?>" ;

oFCKeditor.Create() ;
</script>


$out = str_replace(chr(34), "'", $out); was the key

The html was crashing the editor... somewhat ironic with something that was supposed to be CREATING html?