Data is not pulling from mysql db into php app - textarea field issue - maybe?
Posted on 2012-03-20
I have an issue that I originally blamed on tinyMCE [and part of it was related to tinyMCE], but now after much research, I 'think' this new issues has something to do with Textarea field limits, db field limits, something...
I have a php web form, in addition to the other fields, there are three text area fields, that allow the user to enter comments that will display at the top of the form, end of form and on thank page. TinyMCE is attached to these fields, so user can format their text. After resolving the funky chars that were appearing in my db because of Word copy/pasting, the issue I now face is that after the text has been submitted to the db, if it is very long amount of text, it will not pull/display on the php page.
For example, I enter a 100 word paragraph, save it to the db, open the web page, I see the text. Now if I add 1K words, 2K words of text, nothing appears on the web page, not even the div border that I have set to encase this text. It's like nothing is in the db field, but if I go to the db, to that field, I see all the text. Then if I remove 90%, 80%, etc of the text, update the db, open the web page, the text is then viewable.
I have changed field type from "text" to "mediumText", increased column in the textarea field to 40 from 16. Nothing is working. What else do I need to consider, do, try, etc?