Please what do you think is wrong here, when I copy a long post from somewhere and paste it into my textarea then submit, it will cut the post into half sometime not even up to half of the post I submitted will be inserted into the db. Have checked and rechecked my codes but don't seem to know what is wrong I aslo noticed it doesn't behave like that on a particular laptop I use, but when i tried other browsers and laptops but it's still behaving like that

Adewasco2k slyrox onyengbu

cbrass:
Please what do you think is wrong here, when I copy a long post from somewhere and paste it into my textarea then submit, it will cut the post into half sometime not even up to half of the post I submitted will be inserted into the db. Have checked and rechecked my codes but don't seem to know what is wrong I aslo noticed it doesn't behave like that on a particular laptop I use, but when i tried other browsers and laptops but it's still behaving like that

Adewasco2k slyrox onyengbu

let me guess, the form submission is being done via ajax/ajax jquery call?

onyengbu:

let me guess, the form submission is being done via ajax/ajax jquery call?

Yes bro

Log text before database insert

I am guessing your column is varchar and of course has a limit

spikesC:
Log text before database insert

I am guessing your column is varchar and of course has a limit

No it's TEXT

cbrass:


Yes bro

I have been into that problem before. It is not database table settings. It is being caused by improper escaping . It is quite a strange occurence then but if you check the text being truncated you will discover that the point of trunctiom has a single quote or apostrophe or some hidden characters.
The solution is to use javascript escaping methods (google itcos I cant do that now) and escape the js variable on the jquery side of your script before it gets to php. PHP escaping methods wont help because the text gets truncated before it gets to the server..
If JS escaping method didnt help, use a form submissbon library like form.malsup.com. Even if your textarea is in a loop, you are still fine because you bind each form submit to a class which you create from the ids of your loop.

Best regards

onyengbu:

I have been into that problem before. It is not database table settings. It is being caused by improper escaping . It is quite a strange occurence then but if you check the text being truncated you will discover that the point of trunctiom has a single quote or apostrophe or some hidden characters.
The solution is to use javascript escaping methods (google itcos I cant do that now) and escape the js variable on the jquery side of your script before it gets to php. PHP escaping methods wont help because the text gets truncated before it gets to the server..
If JS escaping method didnt help, use a form submissbon library like form.malsup.com. Even if your textarea is in a loop, you are still fine because you bind each form submit to a class which you create from the ids of your loop.

Best regards

Thanks bro I used encodeURIComponent() to escape the characters before the ajax call and it's working perfectly now

Once again thank you

cbrass:



Thanks bro I used encodeURIComponent() to escape the characters before the ajax call and it's working perfectly now

Once again thank you

Thats exactly what I used back when I had that problem but its been a long time and I can hardly locate which project I used it on.

You are welcome.