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

#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

1377 posts

Uber Geek
+1 received by user: 17

#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

738 posts

Ultimate Geek
+1 received by user: 190

#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

6473 posts

Uber Geek
+1 received by user: 458

Retired Mod

Trusted

Lifetime subscriber

#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

#449009 16-Mar-2011 19:13

done it : solved, thanks folks :)