mjh Posted June 1, 2007 Share Posted June 1, 2007 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 Quote Link to comment https://forums.phpfreaks.com/topic/53857-rich-text-with-php-and-mysql/ Share on other sites More sharing options...
per1os Posted June 1, 2007 Share Posted June 1, 2007 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. Quote Link to comment https://forums.phpfreaks.com/topic/53857-rich-text-with-php-and-mysql/#findComment-266293 Share on other sites More sharing options...
TreeNode Posted June 1, 2007 Share Posted June 1, 2007 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 Quote Link to comment https://forums.phpfreaks.com/topic/53857-rich-text-with-php-and-mysql/#findComment-266301 Share on other sites More sharing options...
mjh Posted June 4, 2007 Author Share Posted June 4, 2007 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 Quote Link to comment https://forums.phpfreaks.com/topic/53857-rich-text-with-php-and-mysql/#findComment-267570 Share on other sites More sharing options...
per1os Posted June 4, 2007 Share Posted June 4, 2007 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. Quote Link to comment https://forums.phpfreaks.com/topic/53857-rich-text-with-php-and-mysql/#findComment-267573 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.