row type to keep formatting

[strauss]

I am writing an app for our school newspaper to be posted online. I want to store everything in my MySQL db, but also want to keep the formatting when we put the articles in the DB. What should the row type be for this in order to keep the formatting (paragraphs mainly). Text puts it all together...

Basically articles will be copied out of word into a <textarea> field and I would like to eliminate the need to build in a WYSIWYG editor if possible...

Please help me out
Thanks in advance -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[blakey]

Hi mate

You mean the column type? I'd use one of the TEXT types, and choose the proper size depending on how large you expect the articles to get. Don't forget to properly filter the input, or someone can insert CSRF or XSS into your data, and cause you and your users alot of trouble!! If you really want to allow simple formatting like <p>, then create a whitelist of the most basic formatting tags you want to allow, filter based on that. Disallow everything else.

Good Luck -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --