php wont update if content has a '

you cannot use the ' in your code when dealing with the fckeditor

So what options do i have?

use \"

remember this is in your code ppl can use ' in the fckeditor

dont really follow.

I find it hard ot believe that you couldt write the following in fckeditor.

today I can't find a html editor.

If so are there any alternatives?

Ive just gone onto the fckeditor site and done a test on their demo. It works fine.

                         <p>' &quot;</p>
<br />

So I can only assume its a php code error when inserting it into the database.

Hi,

It is simple issue,

you need to replace ' ..

after receiving the text from fckeditor, you have to use replace function to replace the ' to `

 

$fcktext = $_POST['fckeditor'];
 
$formatt_text = str_replace($fcktext, "'","`");

Select allOpen in new window

logudotcom:
not sure where to make this change.

I have my form page, then I have my processing page (insert)

you have to make in the processing page...

where you are receiving and insert?

if u can, post some code on the processing page, i will modify it?

one more suggestion,

even you can apply this function -->mysql_escape_string()

 instead of str_replace(),

<?php
$item = "Zak's Laptop";
$escaped_item = mysql_escape_string($item);
printf("Escaped string: %s\n", $escaped_item);
?>

Select allOpen in new window

Form page.

    <tr>
      <td valign="top"><div align="right" class="textstandard">
        <div align="left">Information<span class="textRecord"></span></div>
      </div>      </td>
     
      <td valign="top" class="textstandard"><img src="images/icon_circlearrow.gif" width="11" height="11" /></td>
      <td><textarea id="MyTextarea" name="ud_content"><? echo $row["content"]; ?></textarea></td>
    </tr>

------------------------------------------------------------------------

Processing page.
$query="UPDATE pages SET content='$ud_content' WHERE pageid='$ud_pageid'";

note I have other form fields but this is the fckeditor form.

I went into it and added a ' to the content and processed the code and came back to view an nothing had changed.

All ok recoded the page and it works great.

Thanks so much.

actually, mysql_escape_string() will help you to safer insert/update... it won't replace '

do u need any help again?

ok so if you think its better.

Do you want me to open up another question?


actually, mysql_escape_string() will help you to safer insert/update... it won't replace '

may be, you can open new question

done.