Text Field Text

[Daveyz83]

Hi,
I am allowing the users to key in to a text field with multiple lines.
The thing is , I want to he user to be allowed to either set hyperlink or bold to the text when they enter, and once information are keyed in, they would be stored in a SQL database in the same format (with all the paragraphing and stuffs) and display again. Can anyone help me?

Thank you in adavance

[sarahk]

you need to use a text area and to use addslashes() when you save and stripslashes when you retrieve from the database.

[id10t]

You may also want to replace the real HTML code with something like *BBCode to limit what tags someone could use. Would suck mightily if someone put a img reference in for that goatse.cx site (don't go there... please. truly sick) and the Boss happened to check out your work.

[Daveyz83]

Originally posted by sarahk
you need to use a text area and to use addslashes() when you save and stripslashes when you retrieve from the database.

What if someone keyed in the slash in the text field for a specific purpose, wouldn't stripslashes remove them as well? =(

[diego25]

What if someone keyed in the slash in the text field for a specific purpose, wouldn't stripslashes remove them as well?

No, if you call addslashes before you store it in the database, as sarahk said.

Diego

[Daveyz1983]

Originally posted by diego25


No, if you call addslashes before you store it in the database, as sarahk said.

Diego

doesn' work when displaying.............how do i actually automatically add a <br/> html tag to every new line that i recieve from the single result?

For example, mysql return me the result as shown

this i sline one of the result
line 2
and this is line 3.

When display on a web page, it will display as whole line because its HTML. how do I add a <br/> tage? anyone help

[MeX]

hi Daveyz1983!

use nl2br() or use the <pre>-tag for displaying!!

hope that helps!!

ceeyaa.MeX

[Daveyz1983]

works great, thax.

at firsti was using explode("\n",$string) before using the implode with </br> to put them bac ktogether, which works just the same

thanks alot

[evo4ever]

You could define which HTML tags are allowable by using

$var = strip_tags($var, "<b><i>...").

Saves you coding a bbcode system or finding one.

[Daveyz1983]

Originally posted by evo4ever
You could define which HTML tags are allowable by using

$var = strip_tags($var, "<b><i>...").

Saves you coding a bbcode system or finding one.

excellent and useful function that I didn't discover! Beautiful. Thanks.