IPB

Welcome Guest ( Log In | Register )

Why Does Output From Php Have \'s In It?, I see \'s in SQL and HTMP output from PHP how do I remove it?
Martyn
post Jun 14 2006, 06:34 PM
Post #1


WSF Commander
*******

Group: Admin
Posts: 4,662
Joined: 26-August 05
Member No.: 10



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.
Go to the top of the page
 
+Quote Post
 
Start new topic
Replies
BobMateer
post May 13 2007, 01:50 PM
Post #2


WSF Professional
*****

Group: PM Unlimited
Posts: 927
Joined: 4-May 07
From: Phoenix, AZ
Member No.: 1,089
Exchanges:




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.


--------------------
Bob Mateer

If I've helped you in any way

Go to the top of the page
 
+Quote Post
Rich
post May 13 2007, 02:06 PM
Post #3


WSF Junkie
**

Group: Members
Posts: 104
Joined: 2-May 07
From: Australia
Member No.: 1,087



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 & Jeanne

OurTrafficPlace.com
Open for Business

Go to the top of the page
 
+Quote Post

Posts in this topic


Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



RSS Lo-Fi Version Time is now: 29th March 2024 - 12:57 PM