FCK to MySQL

Add these lines to your script:

if (isset($_POST['newspost'])) {
echo '<pre>';
print_r($_POST);
echo '</pre>';

Dit you replace this line?

$postArray = &$_POST ;
by
$postArray = $_POST ;

Did you get this resolved? I am trying to accomplish the same thing so was wondering where you are at this point.

i'm having the same problem. any help is appreciated!

Quick question...

where did you place the code? In what directory? I ask because when I load everything up to my server, I notice that the FCKeditor is within an "iframe".

Thanks, you got me in the right direction and with a few modifications i have it working. But here is another question to see if you ran into this:

if I just enter plain text it all works great getting into my mySQL database. but when I try to add "bold" text, "colored" text, etc. I get this message "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'color: rgb(51, 102, 255);">what happens...

In researching it appears to be a common issue but I have been unable to find the solution. I followed the "...config.js suggestions" since I have a feeling this is a "config" issue but nothing has worked. Did you run into this?

The FCK works great just posting to a page and all of the features seem to work fine (bold, insert photo, color, etc.) but when posting to database there is the error glitch. Are you also posting your data to display? Or are you only posting to the database to later query?

The error is more due to Php. I think you don't escape the input of your query.
You're using double quotes to make your insert-query. When you also have a double quote in your input, mysql thinks this is the end of the query. The words after this "end" aren't commands of mysql, so it doesn't know what to do with it. Which results in an error.

That's why you have to make your input safe for mysql. This you can do by using the php-function mysql_real_escape_string().
If the server has safe_mode() to ON, it's recommended to use strip_tags() to.
So you will have something like this:

$text = "this is your input";
$stripped_text = strip_tags($text);
$mysql_text = mysql_real_escape_string($stripped_text);

Well, I appreciate your input. It seems I have it working and it is capturing the functions in to the database. I didn't change code at all. I first tried making any "quote" modifications only to get another parse error and then pasted my original back in and voila. Not asking why at this moment; all I know is it is working.

Question: now I want to capture at the same time as the FCKeditor input a topic column, title and description field but I keep getting a parse error. Any thoughts? When I fix one line then it points out another and it never gets corrected. Sort of frustrating...

Here is the code that got everything to input correctly into MySQL database with links, photos, etc.

<?php
$con = mysql_connect("yourlocalhost.com","username","password");
if(!$con)
{
die('Could not connect:'.mysql_error());
}

mysql_select_db("your_db_name",$con);

if(isset($_POST['post'])){

$postArray = $_POST['FCKeditor1'];

if(get_magic_quotes_gpc())
$postedValue = (addslashes($postArray));
$mysql_postArray = mysql_real_escape_string($stripped_postArray);

$query='INSERT INTO name_of_table(id_field, text_field)
VALUES("'.$_GET['id'].'","'.$postedValue.'")';

mysql_query($query) or die (mysql_error());
}
?>

Thanks for everyones assistance. Hope this helps.

is your code maybe being called twice somehow? Place a couple echo statements in there with a counter variable and see what is up. Maybe it's looping through.

The comment re looping must have been directed to one of the other respondents. The code I shared is working beautifully.