栏目页的JSON格式输出

插件程序存放目录用：/e/extend/jsonclasspage/

主程序文件内容：(/e/extend/jsonclasspage/index.php)：

<?php
require('../../class/connect.php'); //引入数据库配置文件和公共函数文件
require('../../data/dbcache/class.php'); //引入栏目缓存文件
$link=db_connect(); //连接数据库
$empire=new mysqlquery(); //声明数据库操作类
$editor=1; //声明目录层次
$classid=(int)$_GET['classid'];
if(empty($classid))
{
exit();
}
$tbname=$class_r[$classid]['tbname'];
$mid=(int)$class_r[$classid]['modid'];
if(empty($tbname)||empty($mid)||InfoIsInTable($tbname))
{
exit();
}

$add='';
//栏目
if($class_r[$classid]['islast'])//终级栏目
{
$add.="classid='$classid'";
$have_class=0;
}
else
{
$add.=ReturnClass($class_r[$classid]['sonclass']);
$have_class=1;
}
//排序
if(empty($class_r[$classid]['reorder']))
{
$addorder="newstime desc";
}
else
{
$addorder=$class_r[$classid]['reorder'];
}
//分页
$page=(int)$_GET['page'];
$page=RepPIntvar($page);
$start=0;
$line=(int)$class_r[$classid]['lencord'];//每页显示记录数
$page_line=10;//每页显示链接数
$offset=$page*$line;//总偏移量

//优化
$yhadd='';
$yhid=(int)$class_r[$classid]['yhid'];
$yhvar='qlist';
if($yhid)
{
$yhadd=ReturnYhSql($yhid,$yhvar,1);
}

//统计SQL
$totalquery="select count(*) as total from {$dbtbpre}ecms_".$tbname." where ".$yhadd.$add;
$num=$empire->gettotal($totalquery);

//checkpageno
eCheckListPageNo($page,$line,$num);

//查询SQL
$query="select ".ReturnSqlListF($mid)." from {$dbtbpre}ecms_".$tbname." where ".$yhadd.$add;
$query.=" order by ".ReturnSetTopSql('list').$addorder."".do_dblimit($line,$offset);

//JSON
$eapi_jsondbr=eapi_JsonDbQuery($query);
$eapi_jsonstr=eapi_JsonEn($eapi_jsondbr);
echo $eapi_jsonstr;
db_close(); //关闭数据库链接
$empire=null; //注消操作类变量
?>

浏览器访问：/e/extend/jsonclasspage/index.php?classid=栏目ID&page=页码

如访问 /e/extend/jsonclasspage/index.php?classid=1&page=0，返回如下内容：

{
"0":{"id":"5","classid":"2","ttid":"0","onclick":"0","plnum":"0","totaldown":"0","newspath":"2025-11-20","filename":"5","userid":"1","username":"admin","firsttitle":"0","isgood":"0","ispic":"0","istop":"0","isqf":"0","ismember":"0","isurl":"0","truetime":"1763609738","lastdotime":"1763609738","havehtml":"1","groupid":"0","userfen":"0","titlefont":"","titleurl":"/fulanmu1/zilanmu1/2025-11-20/5.html","stb":"1","fstb":"1","restb":"1","keyboard":"","eckuid":"0","efz":"0","title":"增加信息5","ftitle":"","newstime":"1763609728","titlepic":"","smalltext":"增加信息5","diggtop":"0"},
"1":{"id":"4","classid":"2","ttid":"0","onclick":"2","plnum":"0","totaldown":"0","newspath":"2025-11-17","filename":"4","userid":"1","username":"admin","firsttitle":"0","isgood":"0","ispic":"0","istop":"0","isqf":"0","ismember":"0","isurl":"0","truetime":"1763371906","lastdotime":"1763371906","havehtml":"1","groupid":"0","userfen":"0","titlefont":"","titleurl":"/fulanmu1/zilanmu1/2025-11-17/4.html","stb":"1","fstb":"1","restb":"1","keyboard":"","eckuid":"0","efz":"0","title":"增加信息4","ftitle":"","newstime":"1763371883","titlepic":"","smalltext":"增加信息4","diggtop":"0"},
"2":{"id":"1","classid":"2","ttid":"0","onclick":"1","plnum":"0","totaldown":"0","newspath":"2025-11-17","filename":"1","userid":"1","username":"admin","firsttitle":"0","isgood":"0","ispic":"0","istop":"0","isqf":"0","ismember":"0","isurl":"0","truetime":"1763369491","lastdotime":"1763369491","havehtml":"1","groupid":"0","userfen":"0","titlefont":"","titleurl":"/fulanmu1/zilanmu1/2025-11-17/1.html","stb":"1","fstb":"1","restb":"1","keyboard":"","eckuid":"0","efz":"0","title":"增加信息1","ftitle":"","newstime":"1763369483","titlepic":"","smalltext":"增加信息1","diggtop":"0"}
}