[SOLVED] Magic quotes problem with html links saved in database

[dwest]

Hi,

I think this is a magic quotes problem but I'm not certain.

 

On the backend of a site,

I have a form used to save some default content to a database.  The form has a textarea among other fields.  When a link is embedded in the textarea content like so,

<a href="http://thelink.com/link/" >The Link</a>

 

the link is saved in the database as,

<a href=\"http://thelink.com/link/\" >The Link</a>

I think this is due to magic quotes being on. (and no the host won't turn it off.)

 

On the frontend of the site,

The same default content is pulled into a user form which is used for emailing that content to others.  It can be edited by the user prior to mailing if desired.  For instance the user could add more links in the textarea as html.

 

I would like any links in the default content to be formatted correctly in the frontend user form when it is called.  I would also like those links, and any the user adds, to remain properly formatted when the email form is submitted.

 

What can I do to achieve this?

 

Thanks!

 

 

 

[fert]

http://us2.php.net/manual/en/function.stripslashes.php

[dwest]

Thanks fert.  I'm aware of stripslashes but I'm not sure where to do the stripping.

 

Should I strip before saving to the database and be done with it there?

Or should I strip it as it is called from the database and leave the data storage alone?

[JasonLewis]

well if you want to display it normally, then strip it when you pull it from the database.

[dwest]

Thanks ProjectFear.

Now what about when it's emailed from the user form.  Is there something I need to so in the email processing code to keep it formatted correctly?

[dwest]

Never mind.  I realize now after tinkering I just need to strip slashes each time I process the data.

 

Thanks for the help!