how to save special charecters in MYSQL?

[mshen]

1.I use PHP addslashes() to add "\" to the data from a form.

2. save it to DB.(which data??)

do I have to use PHP stripslashes() if I read the data from DB.

I confuse when I have to use addslashes() and when I have to use stripslashes() .

thanks

[estebanz]

You don't have to use addslashe. PHP automatically adds slashes to ['] character, the only wich is really problematic in mysql.

Just use stripslashes if you want to echo posted strings (to remove automatically generated '\').

Use nl2br function if you want your text to be displayed with new lines in html.