Help with outputs!

Hello..

so i have now created my personalized toolbar with ckeditor running correctly.. i write some text into the box, for example this following text:
1) Hello, i am Simon
and i hit Submit..

this loads my sample_postdata which i edited so that i will display the last added messages and at the same time add into my database into a text field called articolo the $postedValue so i receive the following output into the sample_postedata:

Field Name Value
editor1 Hello, i am Simon

i also check into mysql database and inside my table under the articolo text field i have this:
 Hello, i am Simon

and when i try to post onto a new page with a query the field articolo i receive this message:
 Hello, i am Simon

how can i make it so that i can receive a formatted test like shown on 1)?

Thu, 01/14/2010 - 11:08

alfonsoml

Joined: 31/12/2006

Posts: 3737

Re: Help with outputs!

You must have your system ready before trying to use CKEditor. If you use a textarea you'll get the same problem, so follow the steps outlined here: http://alfonsoml.blogspot.com/2009/08/u ... sites.html

Thu, 01/14/2010 - 11:23

mstation

Joined: 14/01/2010

Posts: 4

Re: Help with outputs!

Hello again..

thanks for the reply and sorry for my english but i'm italian..

if i add the code you wrote on your website:
This is some sample text.
You are using <a href="http://www.fckeditor.net/">CKEditor</a>.
<form method="post" name="test"><textarea name="area"></textarea></form>
Final <> quote '

into my <td></td> where i am trying to print the mysql saved $postedValue i have this result:
(attachment image)

which is exactly what i'm trying to obtain which means that i don't have server side issues..

my problem is trying to understand why when i save the $postedValue into mysql it changes values for example:
 nuova prova cazzo
becomes
 nuova prova cazzo

Attachments:

Attachment	Size
immagine_1.jpg	15.46 KB

Thu, 01/14/2010 - 12:12

alfonsoml

Joined: 31/12/2006

Posts: 3737

Re: Help with outputs!

My post says that you must remove CKEditor and work only with a textarea. Do that test, don't try to put the HTML directly in the PHP. Use your CMS but with a plain textarea instead of CKEditor.

Fri, 01/15/2010 - 17:21

avangelist

Joined: 15/01/2010

Posts: 3

Re: Help with outputs!

If you alert what you have submitted before it goes into the database what do you get?

You should get non-html markup for markup syntax.

IE you should see:

Hello World

If you confirm this, then it is what you are doing in your script that is converting the html entities?

Fri, 01/15/2010 - 19:13

charlieachds

Joined: 14/01/2010

Posts: 1

Re: Help with outputs!

I have the exact same problem. See code below.

When I echo the data ($postedValue), I get the proper output, but not in the database.

<?php

if ( isset( $_POST ) )
   $postArray = &$_POST ;         // 4.1.0 or later, use $_POST
else
   $postArray = &$HTTP_POST_VARS ;   // prior to 4.1.0, use HTTP_POST_VARS

foreach ( $postArray as $sForm => $value )
{
   if ( get_magic_quotes_gpc() )
      $postedValue = htmlspecialchars( stripslashes( $value ) ) ;
   else
      $postedValue = htmlspecialchars( $value ) ;

?>
      <tr>
         <th style="vertical-align: top"><?php echo $sForm?></th>
         <td><pre><?php echo $postedValue?></pre></td>
      </tr>
   <?php
$id = Trim(stripslashes($_POST['id']));
// echo "ID:" . $id;

// Connection to the DB
$dbhost = 'localhost';
$dbuser = 'usernamel';
$dbpass = 'password';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
$dbname = 'dbname';
mysql_select_db($dbname);

// Insert into the DB
// $query = "INSERT INTO fck_data (data) VALUES ('$postedValue')";
$query = "UPDATE sub SET `code` = '$postedValue' WHERE `id` = '$id'";
mysql_query($query) or die("Couldn't update: ".mysql_error());

exit;

}
?>