从JSON转换成HTML表格式这样
问题描述:
我有一个对象从JSON deserialised这样的:从JSON转换成HTML表格式这样
{
"Wilayah": "BALI ",
"Jns_Brg": "WATER DISPANSER ",
"Kd_Brg": "WDP-300 ",
"Kd_Trn": "J",
"Qty": "159",
"Bulan": 7,
"Tahun": 2017
}, {
"Wilayah": "BANDUNG ",
"Jns_Brg": "WATER DISPANSER",
"Kd_Brg": "WDP-300 ",
"Kd_Trn": "J",
"Qty": "2522",
"Bulan": 7,
"Tahun": 2017
}, {
"Wilayah": "BANDUNG ",
"Jns_Brg": "BLENDER ",
"Kd_Brg": "BL-101 ",
"Kd_Trn": "J",
"Qty": "4554",
"Bulan": 7,
"Tahun": 2017
}
我想在这样的表中显示的数据。
Kd_Brg | Bali | Bandung
| 7 | 7
========================
WDP-300| 159 | 2522
BL-101 | | 4554
我该如何解决这个问题?后端php,前端引导jquery + html
答
<?php
$json= "your json code";
$data = json_decode($json);
if (count($data->stand)){
// Open the table
echo "<table>";
// Cycle through the array
foreach ($data as $key => $value) {
// Output a row
echo "<tr>";
echo "<td>".$key."</td>";
echo "<td>".$value."</td>";
echo "</tr>";
}
// Close the table
echo "</table>";
}
?>
+0
这将是我开始为基本表的地方。它把渲染放在服务器上,而不是你的浏览器(通过JS或jQuery),所以会更快地加载你的页面。 – Luke
看看这个[jQuery插件](https://github.com/jongha/jquery-jsontotable)。 – brevis