How do I turn off 'Magic Quotes' in MySQL

Forums › IT Pro and developers › How do I turn off 'Magic Quotes' in MySQL

turnin

509 posts

Ultimate Geek
+1 received by user: 155
Inactive user

Topic # 79269 15-Mar-2011 15:40

I'm new to php 5 databases, I'm trying to turn off "Magic Quotes"
Can anyone help provide the script that I need to use to do this, and where do I run the script ? In the index.php file ?
Thanks folks

jbard

1366 posts

Uber Geek
+1 received by user: 16

Reply # 448605 15-Mar-2011 15:58

It is a setting in the php.ini file - are you running a server or using shared hosting?

Kraven

597 posts

Ultimate Geek
+1 received by user: 98

Reply # 448606 15-Mar-2011 15:58

Magic Quotes is a PHP feature, so it cannot be turned off in MySQL.

This page has the details on disabling in the server config or disabling at runtime:

http://php.net/manual/en/security.magicquotes.disabling.php

nate

6328 posts

Uber Geek
+1 received by user: 391

Moderator

Trusted

Lifetime subscriber

Reply # 448615 15-Mar-2011 16:19

jbard: It is a setting in the php.ini file - are you running a server or using shared hosting?

If it's shared hosting, you can disable it using a .htaccess file. Google for more info.

turnin

509 posts

Ultimate Geek
+1 received by user: 155
Inactive user

Reply # 449009 16-Mar-2011 19:13

done it : solved, thanks folks :)