前端html：
<table id="goods" class="easyui-datagrid" title="" style="width:100%;height:280px">
</table>
這是我的js：
$('#goods').datagrid({
url:'index.php?a=admin&c=admin&m=goods_data',
Columns:[[
{field:'id',title:'自身ID',width:50},
{field:'cid',title:'分類ID',width:50},
{field:'cname',title:'分類名稱',width:100},
{field:'description',title:'副標題',width:200},
{field:'name',title:'商品名稱',width:300},
{field:'sname',title:'商品詳情名',width:400},
{field:'ename',title:'外文名稱',width:400},
{field:'original_price',title:'英鎊價格',width:100},
{field:'present_price',title:'人民幣價格',width:100},
{field:'weight',title:'凈含量',width:100},
{field:'specs',title:'商品規格',width:100},
{field:'brand',title:'商品品牌',width:100},
{field:'introuduction',title:'產品介紹',width:400},
{field:'fname',title:'廠名',width:150},
{field:'faddress',title:'廠址',width:150},
{field:'fnum',title:'廠家電話',width:150},
{field:'composition',title:'成分',width:400},
{field:'temperature',title:'溫度',width:200},
{field:'pd',title:'生產日期',width:100},
{field:'ed',title:'保質期',width:100},
{field:'date',title:'創建日期',width:200},
{field:'pic_path',title:'展位圖路徑',width:400},
{field:'mygood_picture',title:'串列圖路徑',width:400},
]]
});
對應的php：
//商品管理
function goods_data()
{
$mysqli = new mysqli('localhost','shop','123456','shop');
$mysqli->set_charset("utf8");
$sql = "SELECT * FROM goods ";
$data = '{"rows":[';
if ($result = $mysqli->query($sql)) {
while ($row = $result->fetch_assoc()) {
// print_r($row);//可以輸出
$date = strtotime($row["date"]);
$date = date("Y-m-d H:i:s",$row["date"]);
$data .= '{"id":"' . $row["id"] . '","cid":"' . $row["cid"] . '","cname":"' . $row["cname"] . '",
"description":"' . $row["description"] . '","name":"' . $row["name"] . '","sname":"' . $row["sname"] .
'","ename":"' . $row["ename"] . '","original_price":"' . $row["original_price"] . '",
"present_price":"' . $row["present_price"] . '","weight":"' . $row["weight"] . '","specs":"' . $row["specs"] .
'",
"brand":"' . $row["brand"] . '","introuduction":"' . $row["introuduction"] . '","fname":"' . $row["fname"] .
'","faddress":"' . $row["faddress"] . '",
"fnum":"' . $row["fnum"] . '","composition":"' . $row["composition"] . '","temperature":"' .
$row["temperature"] . '","pd":"' . $row["pd"] . '",
"ed":"' . $row["ed"] . '","pic_path":"' . $row["pic_path"] . '","mygood_picture":"' .
$row["mygood_picture"] . '","date":"' . $date . '"},';
}
// print_r($data);//可以輸出
$count = $mysqli->affected_rows;
if($count > 0)
{
$data = substr($data, 0, -1);
}
$result->close();
}
$data .= ']}';
echo $data;
}
表頭和資料都不顯示，但是后臺可以看到是有echo資料出來的：
求大神指教
轉載請註明出處，本文鏈接：https://www.uj5u.com/qianduan/99869.html
標籤：JavaScript