Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › MySQLi Server Behaviors › MySQLI Server Behaviors General / Announcements › Submitting to mysql, quotes aren't showing up with addslashes, now they are " and screwing up things

Submitting to mysql, quotes aren't showing up with addslashes, now they are " and screwing up things

Thread began 10/15/2018 11:47 am by James | Last modified 10/18/2018 10:07 am by Ray Borduin | 522 views | 3 replies |

10/15/2018 11:47 am | #1 James

Submitting to mysql, quotes aren't showing up with addslashes, now they are " and screwing up things

HI, I used andMySqli for a couple years.
I just upgrade to the Data Assitst and now when I normally would have submitted a string to the database that had quotes it would addslashes to the string if quotes were there. Now it puts in in as " and this isn't good for me.
Is this something that can be fixed?

10/15/2018 12:03 pm | #2 James

Actually. It looks to saving to the DB correctly, it looks like when I am pulling the Record from the db that it is converting " into "
This isn't good for me, as I use this with json fields I save and its broken now. When I go to use json_decode it doesn't recognize it.

10/15/2018 12:13 pm | #3 Ray BorduinWebAssist

It encodes when displaying for cross site scripting protection with ->getColumnVal("column") you can tell it not to by manually adding the "false" argument like:

->getColumnVal("column",false);

Did this help? Tips are appreciated...

10/18/2018 8:36 am | #4 James

Thank you sir!
That fixed my issue

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.