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.

[Rich]

Hi Martyn,
Thanks for your help. Now I have tried the .htaccess file once more with "php_flag magic_quotes_gpc off" added to the .htaccess file with no luck, I just get an internal server error plus a 500 error....
The \\\\\' have been in the files since I started day one but the disappearance of the ISB and the missing submit button happened quickly after I was playing around withe block editor and also I had a bit of a play around with the virtual page thingy. the ISB worked fine on both public and members pages before I played around with it.

I have installed the traffic exchange in another folder just to see if it works and it seems to , the only thing that doesn

[BobMateer]

Richard,

I have the same problem. I found a workaround that you can use. If you have phpMyAdmin on your site you can edit the block directly in the database.
After activating phpMyAdmin find the table vtp_blocks. You can edit out the \\\ directly from this table. Just delete them and then make sure the radio button marked Save is checked, and click the Go button. This will return your ISB block to the original.

[Rich]

G\\\'Day sunwest,
Thanks for the info I thought it must have been in the database, I'm about to give it a try.
will let you know how I go.

Richard
P.S. the \\\ in G'Day are just a joke...hehe

[Rich]

Thanks sunwest,
worked a treat and now the members are a happy bunch they can see all their stats.
Just have to sort out the emailer now.

Cheers
Rich

[alkaline]

I have some of them in my site, I have changed hosting but have a few of those signs left. Some of them are making the "Report Site" feature in the members area not to work. Where in the database can I find this button? If thats where it is located ;-).. That way I can manually remove the signs.

[Rich]

G'day alkaline,
That file is found in the same place and was very easy to fix just remove the \\\ in the small file and save(remove them from all the files) use sunwest's instructions.

I have the same problem. I found a workaround that you can use. If you have phpMyAdmin on your site you can edit the block directly in the database.
After activating phpMyAdmin find the table vtp_blocks. You can edit out the \\\ directly from this table. Just delete them and then make sure the radio button marked Save is checked, and click the Go button. This will return your ISB block to the original.

Rich

[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

[Ken Athas]

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

Hey Rich,

I'll give it a go. I tried changing the magic quote setting in BCP, that didn't do anything.

It's amazing how many times we use that little guy, isn't it?

LOL

Thanks!!

[Rich]

Hey Rich,

I'll give it a go. I tried changing the magic quote setting in BCP, that didn't do anything.

It's amazing how many times we use that little guy, isn't it?

LOL

Thanks!!

Hi Ken, Oh I forgot to tell you that I tried that on/off setting in the BCP and it made no differance either.
so from then on I`ve been using the little ` and if you need to do quote marks us two of them ``GREAT STUFF`` wouldn`t you say...lol

Rich

[Ken Athas]

Rich,

I do agree....

The .htaccess thing did it for me...

Now Ill try the other site.... here goes nothing...