Re: addslashes()
| From: | tedd | Date: | Thu, 30 Mar 2006 03:52:55 +0000 |
| Subject: | Re: addslashes() | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-232883@lists.php.net to get a copy of this message | ||
Hi:
I just posted a solution I used recently. Here it is:
One way to turn off magic quotes is to place a ".htaccess" file in your root folder. It's simply a text file that contains:
php_value magic_quotes_gpc 0
php_value magic_quotes_sybase 0
php_value magic_quotes_runtime 0
It works for me.
tedd
It's at: http://www.weberforums.com/ftopic8718.html&highlight=
At 5:32 PM -0600 3/29/06, Chris Boget wrote:
I totally blew past that part with the sybase because we aren't using sybase. I guess I should have paid more attention. I'm curious why that directive affects general PHP code and not just the sybase functions. Oh, well. Thanks for the heads up. thnx, Chris ----- Original Message ----- From: "Jasper Bryant-Greene" <jasper@album.co.nz> To: "Chris Boget" <chris.boget@wild.net> Cc: "PHP General" <php-general@lists.php.net> Sent: Wednesday, March 29, 2006 5:29 PM Subject: Re: [PHP] addslashes()-- -------------------------------------------------------------------------------- http://sperling.comFrom http://php.net/addslashes : "Having the PHP directive magic_quotes_sybase set to on will mean ' is instead escaped with another '." Jasper Chris Boget wrote:-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.phpCan someone explain something to me: <script language="php"> $string = "Bob's carwash's door"; echo 'addslashes(): ' . addslashes( $string ) . '<br>'; echo 'mysql_escape_string(): ' . mysql_escape_string( $string ) . '<br>'; </script> Outputs: addslashes(): Bob''s carwash''s door mysql_escape_string(): Bob\'s carwash\'s door According to the documentation (http://us2.php.net/manual/en/function.addslashes.php), addslashes() should be doing exactly what mysql_escape_string is doing above (namely, add backslashes in front of each apostrophe). However, it's merely adding an additional apostrophe. Why? I'm running 4.3.11 on Windows NT 5.2 build 3790. thnx, Chris