自己模擬了一點json數(shù)據(jù)存放在了數(shù)據(jù)庫一個表中大家可以自己模擬

10年積累的成都網(wǎng)站制作、網(wǎng)站建設(shè)、外貿(mào)網(wǎng)站建設(shè)經(jīng)驗，可以快速應(yīng)對客戶對網(wǎng)站的新想法和需求。提供各種問題對應(yīng)的解決方案。讓選擇我們的客戶得到更好、更有力的網(wǎng)絡(luò)服務(wù)。我雖然不認識你，你也不認識我。但先網(wǎng)站制作后付款的網(wǎng)站建設(shè)流程，更有屯溪免費網(wǎng)站建設(shè)讓你可以放心的選擇與我們合作。

{"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執(zhí)行的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字段鍵值得二維數(shù)組
//打印結(jié)果   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"}}
        )

)

//定義一個空數(shù)組 把二維組里json解析后放進新數(shù)組中
$json = array();

foreach ($row as $k=>$v){
    //json新數(shù)組中放入我需要的id 和 json 的二維數(shù)組鍵
    $json[$k]['id'] =$v['id'];
    //把鍵值為json的json串轉(zhuǎn)換成數(shù)組 放到新數(shù)組中
    $json[$k]['json'] =json_decode($v['json'],true);
   //轉(zhuǎn)換成數(shù)組的json串
   //Array
(
    [3] => Array
        (
            [id] => 3
            [name] => sss
            [type] => 1
            [value] => 1L,4L
        )

)
 
}
echo json_encode($json);
exit;

前端ajax接收輸出

        

    
    
     
      
姓名