rich text with php and mysql

[mjh]

Hi,

 

Could anyone recommend a good way to intergrate rich text (blog, forum like text, like this!) into a php/mysql web app I am building?

 

Does a TEXT field handle the formatting (bold, font size, colours)? and what about storing links?  Or must it be pharsed in and out each time you edit?

 

A brief overview of how to do this would be wonderful,

 

Many thanks

Matt

 

[per1os]

tinymce is a good one javascript based  or fckeditor.

 

www.google.com  will help you on your way.

 

If you want to build your own, good luck man that is some tough stuff I would recommend using a pre-built one.

[TreeNode]

The textfield is only used to insert the data, not to output. The output is usually in a simple div/span element that can handle any text formatting desired. Common forums use BB-type of code, such as

Here is some [b]bolded text[/b] for you.

 

And the application parses that into the relevant HTML elements, and out when/if it is edited, so that it is not breaking any HTML rules when it is in a textfield. I would suggest looking for regex functions that handle this process, for example:

http://www.tutorio.com/tutorial/simple-and-complex-bbcode-with-php

[mjh]

Thanks,  tinymce looks great.

 

Out of interest, what about for storing the data?  Would a MySQL TEXT field type be able to store rich text?  Are there any example of this avaiable anywhere?

 

Matt

[per1os]

It should, I have not used the tinymce, but I am sure when the form submits it converts the text to html for storage. So long as there is html or BBCode in storage there shouldn't be a problem.