EasyUI Forum
May 05, 2024, 06:44:25 AM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News:
 
   Home   Help Search Login Register  
Pages: [1]
  Print  
Author Topic: JSON encode fails using blanks  (Read 7632 times)
jaimi
Full Member
***
Posts: 119


View Profile
« on: September 10, 2012, 12:21:44 AM »

I have the following MySQL Query:
  sql => SELECT ... , hom.hom_name AS HOM_NAME FROM ...
where the value for hom_name is:
  hom_name => Nacromancer\'s Diamond
after pushing the row to the rows array with
  array_push($rows, $row);
I get the JSON output like this:
jsonarr => {"total":"1","rows":[{"OLT40A002T_KEY":"10000042","OLT20A004T_KEY":"10000001","OLT20I001T_KEY":"10020043","PVA_NAME":"Grundausbildung","PVA_BEG_FORMAT":"01.01.2012","PVA_END_FORMAT":"31.12.2012","PNA_NAME":"Stawitzki, Jana","HOM_NAME":"Nacromancer\\'s"}]}

The String is not complete, it omits the String after the blank.
How can I deal with that?
Logged
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.18 | SMF © 2013, Simple Machines Valid XHTML 1.0! Valid CSS!