php解析json

本帖最后由 yskang 于 2012-08-08 10:07:31 编辑

这是某个软件在在线情况
远程获取的json数据，其中我需要records值，这个records：31就是在线总数，然后下面获取14041221001，农哈西塘 |14041220001，农哈董张，这些值写进自己数据库，如第一个14041221001是农哈西塘的帐号。这样的格式请问怎么解析。

{total:1,page:1,records:31,rows:[{id:'14041221001',cell:["1","14041221001","农哈西塘"]},{id:'14041220001',cell:["2","14041220001","农哈董张"]},{id:'14041206001',cell:["3","14041206001","农哈陈武"]},{id:'14041205001',cell:["4","14041205001","农哈赵庄"]},{id:'14041202001',cell:["5","14041202001","农哈北邢"]},{id:'14041201001',cell:["6","14041201001","农哈大曹"]},{id:'14041129001',cell:["7","14041129001","农奥满庄"]},{id:'14041109001',cell:["8","14041109001","农奥乔庄"]},{id:'14041101001',cell:["9","14041101001","农奥保店中心"]},{id:'14041010001',cell:["10","14041010001","鲁罗黑白"]},{id:'14041009001',cell:["11","14041009001","鲁罗大刘普"]},{id:'14041006001',cell:["12","14041006001","鲁罗车李"]},{id:'14040912001',cell:["13","14040912001","恩施九窑场"]},{id:'14040904001',cell:["14","14040904001","恩施白菜魏"]},{id:'14040704001',cell:["15","14040704001","涩谷付集"]},{id:'14040617001',cell:["16","14040617001","火炬三苑"]},{id:'14040602001',cell:["17","14040602001","火炬杨庄"]},{id:'140406001',cell:["18","140406001","火炬办"]},{id:'14040530001',cell:["19","14040530001","加爱古庄"]},{id:'14040523001',cell:["20","14040523001","加爱丁庄"]},{id:'14040520001',cell:["21","14040520001","加爱魏安"]},{id:'14040509001',cell:["22","14040509001","加爱高苏"]},{id:'14040449001',cell:["23","14040449001","安家毕子刘"]},{id:'14040444001',cell:["24","14040444001","安家王庄"]},{id:'14040422001',cell:["25","14040422001","安家孟集"]},{id:'14040319001',cell:["26","14040319001","舍瓦王庄村"]},{id:'14040128001',cell:["27","14040128001","袍哈苏陈"]},{id:'14040127001',cell:["28","14040127001","袍哈小店"]},{id:'14040123001',cell:["29","14040123001","袍哈陈万侯"]},{id:'14040119001',cell:["30","14040119001","袍哈谢集"]},{id:'1404002',cell:["31","1404002","县办公室"]}]}

他是标准的json吗，我看json都引号引起来，他这个很多没引起来呢

回复讨论(解决方案)

你直接用 json_decode($string,true); 试试

是json，这东西好用

怎么写啊，我也知道json_decode，但是总是出错

这是供 js 使用的数据块，而不是供数据交换用的 json。至少他不能被 php 的 json_decode 所接受

设数据存放于变量 $s 中
$s = preg_replace('/["\']?(\w+)["\']?/', '"$1"', $s);
$s = iconv('gbk', 'utf-8', $s);//如果不是 utf-8 编码的，还需转换成 utf-8 编码
print_r(json_decode($s));

这是供 js 使用的数据块，而不是供数据交换用的 json。至少他不能被 php 的 json_decode 所接受

设数据存放于变量 $s 中
$s = preg_replace('/["\']?(\w+)["\']?/', '"$1"', $s);
$s = iconv('gbk', 'utf-8', $s);//如果不是 utf-8 编码的，还需转换成 utf-8 编码
pri……
$1是什么

http://www.yesky.com/imagesnew/software/php/zh/function.preg-replace.html

http://www.yesky.com/imagesnew/software/php/zh/function.preg-replace.html
求qq

不知道为啥 json_decode 解析不了 求高手