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
1348 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?

545 posts

Ultimate Geek
+1 received by user: 60


  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

 
 
 
 


I'm @nate
6271 posts

Uber Geek
+1 received by user: 366

Moderator
Trusted
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.





Custom software development | Mt Eden Cafe | Cafe Owner



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 »

Red Hat unveils production-ready open source hyperconverged infrastructure
Posted 23-Jun-2017 22:10

Whatever ailed Vodafone broadband … seems to be fixed
Posted 23-Jun-2017 14:10

VMware NSX Meets Stringent Government Security Standards with Common Criteria Certification
Posted 22-Jun-2017 19:05

Brother launches next-generation colour laser printers and all-in- ones for business
Posted 22-Jun-2017 18:56

Intel and IOC announce partnership
Posted 22-Jun-2017 18:50

Samsung Galaxy Tab S3: Best Android tablet
Posted 21-Jun-2017 12:05

Wellington-based company helping secure Microsoft browsers
Posted 20-Jun-2017 20:51

Endace delivers high performance with new 1/10/40 Gbps packet capture card
Posted 20-Jun-2017 20:50

You can now integrate SMX security into Microsoft Office 365, Google and other cloud email platforms
Posted 20-Jun-2017 20:47

Ravensdown launches new decision-making tool HawkEye
Posted 19-Jun-2017 15:38

Spark planning to take on direct management of all consumer stores
Posted 19-Jun-2017 10:03

Qrious acquires Ubiquity
Posted 14-Jun-2017 12:21

Spark New Zealand prepares for 5G with Nokia
Posted 14-Jun-2017 12:16

The future-proof 10.5-inch iPad Pro
Posted 13-Jun-2017 18:16

Mandatory data breach reporting in Australia
Posted 13-Jun-2017 11:30


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.