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?

556 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
6287 posts

Uber Geek
+1 received by user: 373

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 »

Samsung introduces Galaxy Note8
Posted 24-Aug-2017 08:50

How Oppo shakes New Zealand’s phone market
Posted 22-Aug-2017 18:32

Recognition for top small business advisors
Posted 22-Aug-2017 17:23

OPPO R11 dual 20MP camera phone debuts in New Zealand
Posted 22-Aug-2017 15:45

Intel introduces new 8th Generation processors
Posted 21-Aug-2017 19:02

Trend Micro launches Home Network Security
Posted 21-Aug-2017 18:38

Avondale College students at top of Microsoft Office Specialist World Championship
Posted 21-Aug-2017 14:11

Garmin introduces inReach SE+ and inReach Explorer+
Posted 21-Aug-2017 14:05

Public Wi-Fi plus cloud file sharing
Posted 18-Aug-2017 11:20

D-Link NZ launches professional Wireless AC Wave 2 Access Point for businesses
Posted 17-Aug-2017 19:25

Garmin introduces the Rino 700 five-watt two-way handheld radio
Posted 17-Aug-2017 19:04

Garmin announces the Foretrex 601 and Foretrex 701 Ballistic Edition for outdoor and tactical use
Posted 17-Aug-2017 19:02

Brightstar announces new distribution partnership with Samsung Knox platform in Australia
Posted 17-Aug-2017 17:07

Free gig-enabled WiFi network extends across Dunedin
Posted 17-Aug-2017 17:04

Samsung expands with connect Gear S3 Frontier
Posted 17-Aug-2017 15:55


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.