tags:

views:

109

answers:

1
Q: 

Quotes and double quotes always escaped when retrieve from table? How can I fix this?

Hi guys, I'm using the Zend framework here - I've noticed that for some reason the information is automatically escaped when it goes into the database - it doesn't do so on my localhost but it escapes automatically on my host. And when data is retrieved its not unescaped so something like 'Chris O'Donnel' goes in as Christ O\' Donnel and comes out the same way?

How can I control this?

+2  A: 

Probably the magic_quotes_gpc option is enabled. It can't be changed at runtime, so you need to get it fixed in the PHP configuration on server.

Lukáš Lalinský  2009-10-03 11:27:49
If thats the case so.. is there a workaround for that which I can do in code? asides unescaping everything I retrieve from the database
Ali  2009-10-03 11:33:35
If you want to work it around, unescape things *before* you put them into the database (see get_magic_quotes_gpc() for whether it's enabled or not).
Lukáš Lalinský  2009-10-03 11:35:21
I believe magic quotes can be disabled using htaccess (assuming you are using Apache and mod_php), so this would be the simplest solution. Add:php_flag magic_quotes_gpc offto the .htaccess file in your public directory.
Tim Fountain  2009-10-03 13:07:08
Would this be anyway a security hazard or so? The though just crossed my mind btw...
Ali  2009-10-04 08:01:57
Disabling magic_quotes_gpc? No. I'd say having code that depends on magic_quotes_gpc being enabled is a much larger problem.
Lukáš Lalinský  2009-10-04 08:43:02

related questions

What language do you use for Postgresql triggers and stored procedures?
Are Multiple DataContext classes ever appropriate?
Which tools do people use to create Data Dictionaries?
Any experiences with Protocol Buffers?
Mechanisms for tracking DB schema changes
How big can a MySQL database get before performance starts to degrade.
How do I index a database field
How does database indexing work?
How do I connect to a database and loop over a recordset in C#?
Editing database records by multiple users
Object Oriented vs Relational Databases
VFP .NET OLEdb provider does not work in Win 64-Bits. Help
Embedded Database for .net that can run off a network
Connect PHP to an AS/400
Swap unique indexed column values in database.
cx_Oracle - what is the best way to iterate over a result set?
cx_Oracle - How do I access Oracle from Python?
.NET Migrations Engine
Is there a version control system for database structure changes?
SQLite and XSD
How do I version my MS SQL database in SVN?
XSD DataSets and ignoring foreign keys
Flat File Databases in PHP
Throw Error In MySQL Trigger
Binary Data in MySQL