我用oci_fetch_object获取对象,然后转换为json格式,结果输出来看了一下,不对:
({"totalProperty":"7","results":{"FX":["6410314 ","6410404 ","6410221 ","6410228 ","6410126 ","6410214 ","6410328 "],"FY":["2","1","2","1","1","2","1"],"0":{"FX":"6410314 ","FY":"2"},"1":{"FX":"6410404 ","FY":"1"},"2":{"FX":"6410221 ","FY":"2"},"3":{"FX":"6410228 ","FY":"1"},"4":{"FX":"6410126 ","FY":"1"},"5":{"FX":"6410214 ","FY":"2"},"6":{"FX":"6410328 ","FY":"1"}}}) 
居然输出了这种格式,正常的json格式应该是:
{"FX":"6410314 ","FY":"2"},"1":{"FX":"6410404 ","FY":"1"},"2":{"FX":"6410221 ","FY":"2"},"3":{"FX":"6410228 ","FY":"1"},"4":{"FX":"6410126 ","FY":"1"},"5":{"FX":"6410214 ","FY":"2"},"6":{"FX":"6410328 ","FY":"1"}
也就是说,他输出的结果先输出fx的值的组、然后是fy的值的组,然后才是正常的json格式,我十分的奇怪,请教各位这是什么问题,是不是查询oracel的函数使用的不对啊?

解决方案 »

  1.   

    用oci_fetch_assoc获取关联数组呢?
      

  2.   

    ({"totalProperty":"7","results":{"NAME":["6410314 ","6410404 ","6410221 ","6410228 ","6410126 ","6410214 ","6410328 "],"VISITS":["2","1","2","1","1","2","1"],"VIEWS":["2","1","2","1","1","2","1"],"0":{"NAME":"6410314 ","VISITS":"2","VIEWS":"2"},"1":{"NAME":"6410404 ","VISITS":"1","VIEWS":"1"},"2":{"NAME":"6410221 ","VISITS":"2","VIEWS":"2"},"3":{"NAME":"6410228 ","VISITS":"1","VIEWS":"1"},"4":{"NAME":"6410126 ","VISITS":"1","VIEWS":"1"},"5":{"NAME":"6410214 ","VISITS":"2","VIEWS":"2"},"6":{"NAME":"6410328 ","VISITS":"1","VIEWS":"1"}}})还是一样的,我怀疑是不是我的json的格式转换有问题,我的是php5,不支持json的最小的api,我找了个转换的函数,但是在mysql下又是对的,奇怪