php json解析教程,php解析json

我不是女神ヾ 2023-01-14 04:55 204阅读 0赞

本帖最后由 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 中