html tags in a mysql field

Anon

Question:

I have a MS Access file that contains a large text field. If I include html tags in this text.. will it take effect once it is put into mysql then taken back out? I want to store the data in mysql, then when it outputs to a browser, I want the html tags work like they do in a normal .html file. Can I do that?

ianholmes01

In short yes. I will probably be best to addslashes() to your data to make sure quotes and the like are take care of.

then of course stripslashes() when you echo it back out. I usually urlencode my entries as well just to be safe but it is not nessacary really.

Anon

So I actually use tags in the text field. For example, If I want mysql to output something like..

Hello, I want a line break

When this is displayed.

I would write in the Access db field...

Hello, I want a line break<br>
<br>
When this is displayed.

Yes? And then use the htmlspecialchars function?

ianholmes01

Yeah that is basically it.

you only need the speacial chars function if you plan to search the page for search engine for your site.