自己模拟了一点json数据存放在了数据库一个表中大家可以自己模拟
10年积累的成都网站制作、网站建设、
外贸网站建设经验，可以快速应对客户对网站的新想法和需求。提供各种问题对应的解决方案。让选择我们的客户得到更好、更有力的网络服务。我虽然不认识你，你也不认识我。但先
网站制作后付款的网站建设流程，更有
屯溪免费网站建设让你可以放心的选择与我们合作。
{"1":{"id":"1","name":"asd","type":"1","value":"1L,4L"}}
{"2":{"id":"2","name":"kjf","type":"1","value":"1L,4L"}}
{"3":{"id":"3","name":"sss","type":"1","value":"1L,4L"}}下面我用的pdo执行的php文件
'SET NAMES \'UTF8\'');
$pdo = new PDO($dsn,$user,$pwd,$options);
$sql="select id,json from ecs_json";
$res=$pdo->query($sql);
$row = $res->fetchAll();
// $row是一个含有json字段键值得二维数组
//打印结果 Array
(
[0] => Array
(
[id] => 1
[0] => 1
[json] => {"1":{"id":"1","name":"asd","type":"1","value":"1L,4L"}}
[1] => {"1":{"id":"1","name":"asd","type":"1","value":"1L,4L"}}
)
[1] => Array
(
[id] => 2
[0] => 2
[json] => {"2":{"id":"2","name":"kjf","type":"1","value":"1L,4L"}}
[1] => {"2":{"id":"2","name":"kjf","type":"1","value":"1L,4L"}}
)
[2] => Array
(
[id] => 3
[0] => 3
[json] => {"3":{"id":"3","name":"sss","type":"1","value":"1L,4L"}}
[1] => {"3":{"id":"3","name":"sss","type":"1","value":"1L,4L"}}
)
)
//定义一个空数组 把二维组里json解析后放进新数组中
$json = array();
foreach ($row as $k=>$v){
//json新数组中放入我需要的id 和 json 的二维数组键
$json[$k]['id'] =$v['id'];
//把键值为json的json串转换成数组 放到新数组中
$json[$k]['json'] =json_decode($v['json'],true);
//转换成数组的json串
//Array
(
[3] => Array
(
[id] => 3
[name] => sss
[type] => 1
[value] => 1L,4L
)
)
}
echo json_encode($json);
exit;前端ajax接收输出
前端接收json
姓名
