我用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的函数使用的不对啊?
({"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的函数使用的不对啊?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货