Why Does Output From Php Have \'s In It?, I see \'s in SQL and HTMP output from PHP how do I remove it? Options

[Martyn]

SYMPTOMS

I see \'s in SQL and HTMP output from PHP and it causes the SQL to error and the HTML to display incorrectly.

CAUSE

Your host has turned on "magic quotes". This is a feature of little value and only causes confusion. Consequently most hosting companies do not switch this feature on.

SOLUTION

There are three solutions:

1. Turn it off by adding the following to your .htaccess file:

CODE

php_flag magic_quotes_gpc off

2. Ask your host to switch it off in the PHP.ini file.

3. If your host blocks the use of .htaccess files (very few do) and will not change the PHP.ini so that magic quotes are NOT used then the only option is to switch hosting companies.

[Ken Athas]

I am having the\\\\ issue in my emails.

Should magic quotes be on or off in the BCP?

[Rich]

I am having the\\\\ issue in my emails.

Should magic quotes be on or off in the BCP?

Hi Ken, once you fix up the database and if you server won't turn off the magic quotes(chances they won't) I have found a few small work arrounds to overcome the \\\\\ problem.
1. use ` instead of ' (that's the one just left of the number one key) works a treat.
2. remove all ' and " from any html you write (very easy just use the replace function in your html editor) what I do is replace the" just with a space and bingo it all works fine.

Hope this helps

Rich