Exteremly Urgent need some help

[vamsee]

Dear All,

I am using fck editor embedded php coding for my content management system.

Please see the code of the form page

<!-- FORM PAGE -->

$oFCKeditor = new FCKeditor('cmsTextEnglish') ;
							$oFCKeditor->BasePath = 'FCKeditor/';
							$oFCKeditor->Value = "$dataRow->cmsTextEnglish";
							$oFCKeditor->Create() ;

<!-- FORM PAGE -->

ACTION PAGE CODE

<!-- CODE -->

$cmsTextEnglish = $POST['cmsTextEnglish'] ;
$cmsTextGreek = $POST['cmsTextGreek'];
$title_en = $POST['title_en'];
$title_gr = $POST['title_gr'];
$lang = $POST['lang'];
$checkid = $POST['checkid'];

// update query for updating the content in to the content table
 $sql = "UPDATE cms
                SET 

englishTitle = '".$title_en."',
cmsTextEnglish = '".$cmsTextEnglish."',
latestUpdated = NOW()
WHERE
cmsID = '$checkid'";

mysql_query($sql);
<!-- CODE -->

My Problem is if the formatting or the text in the fckeditor field is big [large] then the text does not get updated. Do you think the the post variable is getting cutoff after passing the values or is it the problem of mysql database. I dont see any chnages even I submit the form in the database.

For more information I made cmsTextEnglish field name as text datatype in Mysql.

I would be very glad if some one could help me with this.

Thanks in Advance,
Vamsee Vanaparthy

[etully]

How big the Post string can be is (believe it or not) dependent on which browser you are using. I had to break a project up into multiple forms so that the client could post one large field per page. (It worked on my machine but was failing when they used their web browser). If the post is getting truncated, then yes, some important fields might be getting left out causing the UPDATE statement to fail.

You should print the $sql query before you execute it to see what's getting passed to MySQL. Then you should copy and paste that query to a command line and try executing it directly into MySQL instead of going through CGI.

These two techniques will help you determine if the $sql is valid (maybe there's an unescaped quote in there?) or if the post is too large for your browser.

[vamsee]

Dear etully,

Thank you for your response, but its quite ambigiuos for me to understand. I have local pacahe and php installed in my computer. I used internet explorer to insert large text in to the respective field with out any hassle but using the same browser on live website to insert the text doesnot seem to work. Can you recommend me any solution for this? How can I make the script that disables to truncate post variables while passing. I cannot pass it as different fields because its only one big field iam talking about. If this field is big none of the other fields are getting updated inclusive of this field. Especially Iam facing these problems when iam inserting table related formatting using FCK editor.

Thanks

[etully]

Before you can fix the problem, you need to know what the problem is.

It might be that your post is getting truncated and some fields aren't getting to the server. Or the problem might be that there is an error in your SQL statement. Either one of these problems would cause the Insert statement to fail.

The way to determine which problem you are having is to print out the $sql statement that you are trying to execute. This will show you whether some fields are truncated or if there is an error in your SQL. Once you know the problem, then we can talk about how to fix it.

If the problem is that it's being truncated, then you might not be able to use a textarea form field. You might have to try using a file upload technique or even FTP.

If the problem is an error in your SQL (like an unescaped quote, for example), then you will see it when you print out the command and try it on the MySQL command line.

[vamsee]

Hello,

Sorry eTully you were absolutely right. There was an error in the Sql Query it was bringing in single quote which was destroying the query. I did the string replace function to replace the single quote and everything works fine. 🙂 🙂

Thank you for your help,
Vamsee Vanaparthy

[bradgrafelman]

Don't forget to mark this thread resolved (it's under Thread Tools at the top).