Insert Text from Database

The editor is working for me quite well, so thx for that ;-) But i have still one problem, when i I want to edit a page, created by the editor.

Imagine the following situation: Once i've created (formated) the text, it is sored in a database. Then - for example - i see a spelling mistake and want to change it. Therefore i have an own page where i can edit the page itself. (simple Update in MySQL) The Problem is now, that i do not get the stored data of the database into the editor.

I've tried the following but it did not work.

<tr> <td class=\"rowB\" width=\"100%\">
<script type=\"text/javascript\">

var sBasePath =\"http://www.*****.com/abc/FCKeditor/\";

var oFCKeditor = new FCKeditor( 'FCKeditor1' ) ;
oFCKeditor.BasePath = sBasePath ;
oFCKeditor.Height = 300 ;
oFCKeditor.Value = '$text' ;
oFCKeditor.ToolbarSet = 'mine' ;
oFCKeditor.Create() ;
</script>
</td>
</tr>

where oFCKeditor.Value = '$text'; should be the data of the database. So this doesn't work. Has anyone an idea how i can solve thi problem?

thx in advance to everyone

Mon, 07/24/2006 - 02:09

ychaouche

Joined: 15/06/2007

Posts: 54

RE: Insert Text from Database

Hi,

oFCKeditor.Value = "some texte" works very fine for me. Please check the value of "$text" in a separate line like <?php echo $text ?> or something...

Y.Chaouche

Mon, 07/24/2006 - 02:19

the_goose

Joined: 24/07/2006

Posts: 6

RE: Insert Text from Database

I have done this already. It works well. But when i want to load it into the editor i see nothing (even the toolbars aren't here)

Could it be because i integrated the editor via JavaScript and not via php ? So that the Script doesn't know what it shall do with the php variable?

Mon, 07/24/2006 - 02:25

ychaouche

Joined: 15/06/2007

Posts: 54

RE: Insert Text from Database

I dont understand... I suppose your javascript code is within a php script. Is that right ? if so, it should be ok. Just be sure that the javascript code is generated properly. What is the generated javascript code ? can you paste it here ?

Y.Chaouche

Mon, 07/24/2006 - 02:40

the_goose

Joined: 24/07/2006

Posts: 6

RE: Insert Text from Database

i don't know exactly what you mean but here is the code of the page where i want to edit the text:

$result = mysql_query("SELECT * FROM editor WHERE editor_id = '$editor_id'");
$row = mysql_fetch_array($result);
$text=$row["text"];

--> to get the data out of the database

print "<table width=\"100%\" border=\"0\" cellpadding=\"7\" cellspacing=\"1\" class=\"tablehead\">
<tr>
<td class=\"rowA\" width=\"100%\"><strong>Text</strong></td>
</tr>
<tr>
<td class=\"rowB\" width=\"100%\">
<script type=\"text/javascript\">

var sBasePath = \"http://www.***.com/abc/FCKeditor/\";

var oFCKeditor = new FCKeditor( 'FCKeditor1' ) ;
oFCKeditor.BasePath = sBasePath ;
oFCKeditor.Height = 300 ;
oFCKeditor.Value = '$text' ;
oFCKeditor.ToolbarSet = 'mine' ;
oFCKeditor.Create() ;
</script>
</td>
</tr> </table>\n";

--> the Integration of the editor via JS in the php-file

is that what you wanted or do you need the whole JS code of the editor? cause there i havent changed anything.

Mon, 07/24/2006 - 02:51

ychaouche

Joined: 15/06/2007

Posts: 54

RE: Insert Text from Database

HI the_goose !

Well, actually i meant something like going to your browser and pointing to the editing page then doing something like "view source" and pasting the html code that is generated via your php script. Especially, we need to look at the javascript code generated via this php script. I hope i was clear now ...

Y.Chaouche

Mon, 07/24/2006 - 03:37

the_goose

Joined: 24/07/2006

Posts: 6

RE: Insert Text from Database

Here it is:

<html>
<head>
<title>Test | Edit</title>
<META HTTP-EQUIV="expires" CONTENT="0">
<META HTTP-EQUIV="Pragma" CONTENT="no-cache">

<link rel="stylesheet" type="text/css" href="style.css">
<script language="JavaScript" type="text/JavaScript" src="format.js"></script>


<script>
<!--
function wait(delay){
   string="pauseforalert("+delay+");";
   setTimeout(string,delay);
}

function pauseforalert(delay){
   this.window.close();
   opener.location='test_editor.php';
}
// -->
</script>


<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></head>

<body link="#FFFFFF" vlink="#FFFFFF" alink="#FFFFFF" >

<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
   <tr>
   <td class="poptop" height="15"><img src="images/spacer.gif" width="3" height="3"></td>
   </tr>
   <tr>
   <td class="hrz_line"><img src="images/spacer.gif" width="1" height="1"></td>
   </tr>
   <tr>
   <td style="background: #ffffff; padding: 5px" valign="middle"><h1 style="margin-top: 0; margin-bottom: 0">Test | Bearbeiten</h1></td>
   </tr>
   <tr>
   <td class="hrz_line"><img src="images/spacer.gif" width="1" height="1"></td>
   </tr>
   <tr>
   <td valign="top" style="padding: 1em" class="maincontent" height="295">
   
   <form action="/sec/test_editor_edit.php" method="post" name="formular" enctype="multipart/form-data">
<input type="hidden" name="yes" value="true">
<input type="hidden" name="editor_id" value="5">
<p>Hier können Sie die gewünschten Änderungen vornehmen.</p>
<table width="100%" border="0" cellpadding="7" cellspacing="1" class="tablehead">
                       <tr>
                           <td class="rowA"><strong>Titel</strong></td>
                                <td class="rowB"><input type="text" class="textfield" name="title" size="40" maxlength="53"value="Test"></td>
                            </tr>
                       <tr>
                           <td class="rowA"><strong>Untertitel</strong></td>
                                <td class="rowB"><input type="text" class="textfield" name="subtitle" size="40" value="Test"></td>
                            </tr>
                       </table>
<table width="100%" border="0" cellpadding="7" cellspacing="1" class="tablehead">
                       <tr>
                           <td class="rowA" width="100%"><strong>Text</strong></td>
                  </tr>
                  <tr>
                     <td class="rowB" width="100%">
      <script type="text/javascript">

var sBasePath = "..../***/FCKeditor/";

var oFCKeditor = new FCKeditor( 'FCKeditor1' ) ;
oFCKeditor.BasePath   = sBasePath ;
oFCKeditor.Height   = 300 ;
oFCKeditor.Value   = '<p>This is a <strong>Test</strong></p>' ;
oFCKeditor.ToolbarSet = 'SZSV' ;
oFCKeditor.Create() ;

      </script>

                     </td>
                        </tr>
                                         </table>
<table width="100%" border="0" cellpadding="7" cellspacing="1" class="tablehead">
                   <tr>
                           <td class="rowA" width="20%"><strong>Anzeigen</strong></td>
                            <td class="rowB"><select name="anzeigen" size="1" id="art">
                                             <option>News</option>
                                              <option>Archiv</option>
                                        </select> </td>
                         </tr>

                       </table>
<p>This is a <strong>Test</strong></p><br><input type="submit" name="submit" value="Veröffentlichen" class="submit"> <input type="submit" name="cancel" value="Verwerfen" class="submit" onclick="self.close()">

   
   </td>
   </tr>
   <tr>
   <td class="hrz_line"><img src="images/spacer.gif" width="1" height="1"></td>
   </tr>
   <tr>
   <td height="20" class="popbot"><a href="javascript:window.close()">Fenster schließen</a></td>
   </tr>
</table>
</body>
</html>

Mon, 07/24/2006 - 05:04

ychaouche

Joined: 15/06/2007

Posts: 54

RE: Insert Text from Database

I don't get it. Maybe it's about quotes ? did you try double quotes or something :
oFCKEditor.Value = 'text on
multiple
lines'

Changing it to :
oFCKEditor.Value="text on
multiple
lines"

I'm not sure it will change something. but who knows ?
Y.Chaouche