How to store HTML like content in forums?

[vikram8jp]

Hello all,

 

I am developing a small Q&A forum for my website. I was wondering how do you generally store HTML content in mysql with application developed in PHP.

Like for the forums which allow the rich-text formatting tools like the one I am typing my question in right now ( bless phpfreaks), how do you store HTML in database?

 

1. I guess they use the BBCode most of the times.

 

2. If we store the BBCoded data in database as it is. Like for example I enter the text like for example,

 

[html]hello[/html]

 

If this is stored as it is, and then I want to implement a search functionality and I enter the word "html", it will display this post. But it shouldn't, right?

 

What's your opinion guys.... it would be very helpful if I get to know the techniques used generally.

 

Thanks and Regards

Vikram