speical characters stored in mySQL table

adavis

Does anyone have a good, repliable script for handling special characters in a form text box that would be stored in a mySQL table, then displayed back out either in html or with the R&OS pdf class (http://ros.co/nz/pdf?) (can't get sysadim to install pdflib on my server)? I seem to have a problem converting them to ascii and then back again. The main ones I'm thinking I need to be concerned with about are the quote, the apostrophe, less than, greater than, and ampersand. If I need to not worry about some of there, or be concerned about other, please let me know.

steve8557

Hi,
I use:

$my_form_field=addslashes($my_form_field);

on the way into the db and

$my_output = stripslashes($my_output);

on the way out to the page

These will "escape" special chars for you like this on the way in

\"Here\'s my apostope\"

Hope that helps

Regards
Steve

adavis

Thanks Steve,

That's a lot easier and much less hassle that what I'm trying to do which is to convert the say " to ". The pdf class doesn't recognize those characters, so I have to convert the back before I print to the pdf.

Thanks,
Alisa