Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.
Forums › IT Pro and developers › How do I turn off 'Magic Quotes' in MySQL


509 posts

Ultimate Geek
+1 received by user: 155
Inactive user


Topic # 79269 15-Mar-2011 15:40
Send private message

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 

Create new topic
1364 posts

Uber Geek
+1 received by user: 15


  Reply # 448605 15-Mar-2011 15:58
Send private message

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

588 posts

Ultimate Geek
+1 received by user: 93


  Reply # 448606 15-Mar-2011 15:58
Send private message

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

6319 posts

Uber Geek
+1 received by user: 382

Moderator
Trusted
Lifetime subscriber

  Reply # 448615 15-Mar-2011 16:19
Send private message

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.



509 posts

Ultimate Geek
+1 received by user: 155
Inactive user


  Reply # 449009 16-Mar-2011 19:13
Send private message

done it : solved, thanks folks :)

Create new topic

Twitter »

Follow us to receive Twitter updates when new discussions are posted in our forums:



Follow us to receive Twitter updates when news items and blogs are posted in our frontpage:



Follow us to receive Twitter updates when tech item prices are listed in our price comparison site:





News »

Intel introduces new NUC kits and NUC mini PCs
Posted 16-Aug-2018 11:03

The Warehouse leaps into the AI future with Google
Posted 15-Aug-2018 17:56

Targus set sights on enterprise and consumer growth in New Zealand
Posted 13-Aug-2018 13:47

Huawei to distribute nova 3i in New Zealand
Posted 9-Aug-2018 16:23

Home robot Vector to be available in New Zealand stores
Posted 9-Aug-2018 14:47

Panasonic announces new 2018 OLED TV line up
Posted 7-Aug-2018 16:38

Kordia completes first live 4K TV broadcast
Posted 1-Aug-2018 13:00

Schools get safer and smarter internet with Managed Network Upgrade
Posted 30-Jul-2018 20:01

DNC wants a safer .nz in the coming year
Posted 26-Jul-2018 16:08

Auldhouse becomes an AWS Authorised Training Delivery Partner in New Zealand
Posted 26-Jul-2018 15:55

Rakuten Kobo launches Kobo Clara HD entry level reader
Posted 26-Jul-2018 15:44

Kiwi team reaches semi-finals at the Microsoft Imagine Cup
Posted 26-Jul-2018 15:38

KidsCan App to Help Kiwi Children in Need
Posted 26-Jul-2018 15:32

FUJIFILM announces new high-performance lenses
Posted 24-Jul-2018 14:57

New FUJIFILM XF10 introduces square mode for Instagram sharing
Posted 24-Jul-2018 14:44


Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.


Updates »

Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.

Alternatively, you can receive a daily email with Geekzone updates.