I have the same issue. Magic quotes is off. My result looks like: "I\'m both entrepreneur and..." The database row looks like this too: "I\'m both entrepreneur and..."
And to get the data I use $this->fetchAll()->toArray(); Then I need to use stripslashes. What I need to do to avoid this? Mark Steudel wrote: > > Have you looked to see if magic_quotes are on? > > On Wed, Feb 24, 2010 at 1:03 PM, Jurian Sluiman > <[email protected]> wrote: >> On Sunday 21 Feb 2010 21:43:04 troels knak-nielsen wrote: >>> If that's the case, then you have double escaping going on. The data >>> should not contain the slash once it's in the database. The point of >>> adding the slash is to "protect" the data when it's embedded in *the >>> query*. That is also why you don't have to (and indeed should not) >>> unescape anything when reading from the database. The slashes are >>> *only* there because you're embedding data in a query. >>> >>> Compare this with a string literal in php. Given the following: >>> >>> echo "A \"double\" quote"; >>> >>> Running this php code will output: >>> >>> A "double" quote >>> >>> That's because the *data* doesn't contain any slashes. The slashes are >>> there so that the php parser can read the literal string. Once they >>> have been read into memory, the slashes are gone. Same thing with sql. >> >> (sorry for my late reaction) >> >> So actually it isn't the data *retrieval* but rather the *insertion* if I >> understand you right? The things I do are 99% from the manual: >> >> * Database initialized by application resource (db params: host, >> username, >> passwd, db name, isDefault = true) >> * Data into model (My_Model_Name) and saves it into mapper >> (My_Model_NameMapper). >> * Mapper has DbTable obj, My_Model_DbTable_Name and extends >> Zend_Db_Table_Abstract >> * Data is saved through Zend_Db_Table_Abstract::insert() or >> Zend_Db_Table_Abstract::update() methods >> >> After calling the method the strings are in the database like I said (so >> _with_ quotes). What's are the things I can look after (php settings, >> mysql >> settings, system settings) to solve this problem? >> >> Thanks in advance, >> Jurian >> -- >> Jurian Sluiman >> CTO Soflomo V.O.F. >> http://soflomo.com >> > > > > -- > > ----------------------------------------- > Mark Steudel > P: 206.375.7244 > [email protected] > > . : Work : . > http://www.mindfulinteractive.com > > . : Play : . > http://www.steudel.org/blog > > -- View this message in context: http://n4.nabble.com/Escape-stripslashes-and-html-entities-tp1562340p1568393.html Sent from the Zend Framework mailing list archive at Nabble.com.
