我的示例 JSON 數據類似于：數據字段不是所有行的同一組字段。[{"date":"2020-04-05 18:26:01", "mydata":{"city":{"name":"paris"},"travel":{"frequency":"5","climate":"cold"}}},{"date":"2020-04-05 18:26:17", "mydata":{"city":{"name":"amsterdam"},"fly":{"airports":"1","type":"international"}}}]這被保存到我的 MariaDB 的一列中。我想以表格格式檢索它，例如：Date mydata-city-name travel-frequency travel-climate fly-airports fly-type 2020-04-05 18:26:01 paris 5 cold null/blank null/blank2020-04-05 18:26:17 amsterdam null/blank null/blank 1 international到目前為止，我嘗試了以下 js 和 html 但我無法按預期獲取數據：JavaScript：var myList$.ajax({ type: "GET", url: "symptom_list.php", success: function (data) { console.log(data) myList = JSON.parse(data) console.log(JSON.parse( data) ); /* alert(data); */ // show response from the php script. },});function buildHtmlTable(selector) { var columns = addAllColumnHeaders(myList, selector); for (var i = 0; i < myList.length; i++) { var row$ = $('<tr/>'); for (var colIndex = 0; colIndex < columns.length; colIndex++) { var cellValue = myList[i][columns[colIndex]]; if (cellValue == null) cellValue = ""; row$.append($('<td/>').html(cellValue)); } $(selector).append(row$); }}// Adds a header row to the table and returns the set of columns.// Need to do union of keys from all records as some records may not contain// all records.function addAllColumnHeaders(myList, selector) { var columnSet = []; var headerTr$ = $('<tr/>'); for (var i = 0; i < myList.length; i++) { var rowHash = myList[i]; for (var key in rowHash) { if ($.inArray(key, columnSet) == -1) { columnSet.push(key); headerTr$.append($('<th/>').html(key)); } } } $(selector).append(headerTr$); return columnSet;}HTML：<body onLoad="buildHtmlTable('#excelDataTable')"><table id="excelDataTable" border="1"></table></body>我如何獲得預期的輸出？
創建動態 JSON 表 HTML JS
慕的地8271018
2023-11-06 15:36:52
