Question

如何编写Discuz论坛返回JSON数据的接口

Answer 1

<?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 {
if ($_GET["type"] == "wdnew") {
$query = DB::query("SELECT * FROM " . DB::table('forum_thread') . " WHERE fid=49 ORDER BY dateline ASC limit 10");
$jsonstr = "{state:10000,data:[";
while ($soft = DB::fetch($query)) {
$newlist .= "{\"id\":" . $soft['tid'] . ",\"title\":\"" . $soft['subject'] . "\"},";
}
$jsonstr = $jsonstr . rtrim($newlist, ',') . "]}";
echo $jsonstr;
} else if ($_GET["type"] == "getForumClass") {
$query = DB::query("SELECT * FROM " . DB::table('forum_forum') . " WHERE status=1 ORDER BY fid ASC");
$jsonstr = "{state:10000,data:[";
while ($soft = DB::fetch($query)) {
$newlist .= "{\"id\":" . $soft['fid'] . ",\"fup\":" . $soft['fup'] . ",\"name\":\"" . $soft['name'] . "\",\"px\":" . $soft['displayorder'] . "},";
}
$jsonstr = $jsonstr . rtrim($newlist, ',') . "]}";
echo $jsonstr;
} else if ($_GET["type"] == "getForumInfo") {
$fid = $_GET["fid"];
$dateline_min = $_GET["dateline_min"];
$dateline_max = $_GET["dateline_max"];
$datacount = DB::result_first("SELECT COUNT(*) FROM " . DB::table('forum_thread') . " WHERE fid=".$fid." and closed=0 and dateline>=".$dateline_min." and dateline<=".$dateline_max);
if($datacount==0){
$jsonstr = "{state:10001,data:[]}";
}else{
$query = DB::query("SELECT * FROM " . DB::table('forum_thread') . " WHERE fid=".$fid." and closed=0 and dateline>=".$dateline_min." and dateline<=".$dateline_max);
$jsonstr = "{state:10000,data:[";
while ($soft = DB::fetch($query)) {
$typename = DB::result_first("SELECT name FROM " . DB::table('forum_threadclass') . " WHERE typeid=".$soft['typeid'] );
$newlist .= "{\"id\":" . $soft['tid'] . ",\"title\":\"[".$typename."]" . $soft['subject'] . "\",\"price\":\"" . $soft['price'] . "\",\"views\":\"" . $soft['views'] . "\",\"dateline\":\"" . $soft['dateline'] . "\"},";
}
$jsonstr = $jsonstr . rtrim($newlist, ',') . "]}";
}
echo $jsonstr;
}else {
echo "{state:0,data:[]}";
}
} catch(Exception $e) {
echo "{state:0,data:[]}";
}
?>