discuz数据表发布为json格式

最新推荐文章于 2020-03-11 18:30:53 发布

老狼8848

最新推荐文章于 2020-03-11 18:30:53 发布

阅读量1.5k

点赞数

分类专栏： discuz 小猫统计专家文章标签： discuz json

本文链接：https://blog.csdn.net/bq_cui/article/details/53021997

版权

discuz 同时被 2 个专栏收录

93 篇文章 1 订阅

订阅专栏

小猫统计专家

69 篇文章 4 订阅

订阅专栏

测试一下以json格式传送数据到浏览器。

从国家统计局查询2016年9月份主要工业产品产量，pre_工业产品产量.xls，或者转换后的csv文件，用小猫统计导入discuz后台数据库。里面有个本月字段，拼音首字母为“BY”，与sql保留字重合，改为“本月1”。

导入后数据表内容：

在discuz根目录中，建立文件 json_gycp.php：

<?php header('Content-type:text/json;charset=utf-8');
define('APPTYPEID', 5);
define('CURSCRIPT', 'userapp');
require_once './source/class/class_core.php';
$discuz = &discuz_core::instance();
$discuz -> cachelist = $cachelist;
$discuz -> init();

try {
		$query = DB::query("SELECT * FROM " . DB::table('gycp') . " WHERE 1 ORDER BY ID ASC limit 10");
		$jsonstr = "{\"data\":[";
		while ($data = DB::fetch($query)) {
			$newlist .= "{\"id\":" . $data['ID'] . ",\"ZB\":\"" . $data['ZB'] . "\",\"BY\":" . $data['BY1'] . ",\"LJ\":" . $data['LJ'] . "},";
		}
		$jsonstr = $jsonstr . rtrim($newlist, ',') . "]}";
		echo $jsonstr;

} catch(Exception $e) {
	echo "{state:0,data:[]}";
}
?>

好了，浏览器浏览网址：http://localhost/upload/json_gycp.php 得到结果：

{"data":[{"id":1,"ZB":"铁矿石原矿(万吨)","BY":11892.7,"LJ":94120.9},{"id":2,"ZB":"磷矿石（折含五氧化二磷30％）(万吨)","BY":1348.0,"LJ":10260.8},{"id":3,"ZB":"原盐(万吨)","BY":477.3,"LJ":4329.6},{"id":4,"ZB":"饲料(万吨)","BY":2723.2,"LJ":21125.7},{"id":5,"ZB":"精制食用植物油(万吨)","BY":615.1,"LJ":4865.8},{"id":6,"ZB":"成品糖(万吨)","BY":12.5,"LJ":932.7},{"id":7,"ZB":"鲜、冷藏肉(万吨)","BY":321.6,"LJ":2592.4},{"id":8,"ZB":"乳制品(万吨)","BY":270.7,"LJ":2195.6},{"id":9,"ZB":"白酒（折65度，商品量）(万千升)","BY":123.6,"LJ":974.6},{"id":10,"ZB":"啤酒(万千升)","BY":409.6,"LJ":3685.3}]}

用在线检测工具检测一下得到的json数据格式：http://www.bejson.com/

{
    "data": [
        {
            "id": 1,
            "ZB": "铁矿石原矿(万吨)",
            "BY": 11892.7,
            "LJ": 94120.9
        },
        {
            "id": 2,
            "ZB": "磷矿石（折含五氧化二磷30％）(万吨)",
            "BY": 1348,
            "LJ": 10260.8
        },
        {
            "id": 3,
            "ZB": "原盐(万吨)",
            "BY": 477.3,
            "LJ": 4329.6
        },
        {
            "id": 4,
            "ZB": "饲料(万吨)",
            "BY": 2723.2,
            "LJ": 21125.7
        },
        {
            "id": 5,
            "ZB": "精制食用植物油(万吨)",
            "BY": 615.1,
            "LJ": 4865.8
        },
        {
            "id": 6,
            "ZB": "成品糖(万吨)",
            "BY": 12.5,
            "LJ": 932.7
        },
        {
            "id": 7,
            "ZB": "鲜、冷藏肉(万吨)",
            "BY": 321.6,
            "LJ": 2592.4
        },
        {
            "id": 8,
            "ZB": "乳制品(万吨)",
            "BY": 270.7,
            "LJ": 2195.6
        },
        {
            "id": 9,
            "ZB": "白酒（折65度，商品量）(万千升)",
            "BY": 123.6,
            "LJ": 974.6
        },
        {
            "id": 10,
            "ZB": "啤酒(万千升)",
            "BY": 409.6,
            "LJ": 3685.3
        }
    ]
}

结果正确。