關於ajax讀取資料表中存放複合json的問題

最後更新：2017-07-27 來源：互聯網

上載者：User

創建阿里雲帳戶，並獲得超過 40 款產品的免費試用版；而企業帳戶則可以享有總值 $1200 的免費試用版。立即註冊！

標籤：關於ajax讀取資料表中存放複合json的問題

自己類比了一點json資料存放在了資料庫一個表中大家可以自己類比

{"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檔案

<?php$db = ‘mysql‘;$host =‘localhost‘;$port  = ‘3306‘;$dbname = ‘t_shop‘;$user = ‘root‘;$pwd  = ‘‘;$dsn = "$db:host=$host;port=$port;dbname=$dbname";   //設定字元集 $options = array(PDO::MYSQL_ATTR_INIT_COMMAND=>‘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接收輸出

<script>      //解析json          function Object(value){              return eval("("+value+")");           }                             function get_wd(){          $.get(‘./json.php‘,function (data){                var data = Object(data)              for(i in data){                  var obj = data[i][‘json‘];                  var keys = [];                  var values = [];                  for(var key in obj){                     //  console.log(key);                    // keys.push(key); //定義一個數組用來接受key                     // values.push(obj[key]);//取得value                       //追加內容定義追加對象的id                    $(‘#div1‘).append(‘<p>‘+obj[key][‘name‘]+‘<p>‘);                      }                                  }           })                     }        </script>        <title>前端接收json</title>    </head>    <body id="userlogin_body">     <div class="popped_card_con" id="div1">      <p>姓名</p>    </div>         <input type="button" value="點擊" onclick="get_wd()"/>                </body>

本文出自 “kangjunfei” 部落格，轉載請與作者聯絡！

關於ajax讀取資料表中存放複合json的問題

本文章原先以中文撰寫並發佈於 aliyun.com，亦設英文版本，僅作資訊用途。本網站不對文章的準確性，完整性或可靠性或其任何翻譯作出任何明示或暗示的陳述或保證。如對該文章有任何疑慮或投訴，請傳送電郵至 info-contact@alibabacloud.com 並提供相關疑慮或投訴的詳細說明。職員會於 5 個工作天內與您聯絡，一經驗證之後，即會刪除該侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

Get Started for Free

Sales Support

1 on 1 presale consultation

Chat Contact Sales
After-Sales Support

24/7 Technical Support 6 Free Tickets per Quarter Faster Response

Open a Ticket
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

Learn More