帝国CMS数据接口如何提供？JSON数据怎么输出？

<?php
// 引入帝国CMS配置文件和数据库操作类
require '../e/class/connect.php';
require '../e/class/db_sql.php';
require '../e/data/dbcache/class.php';

// 实例化数据库类
$empire = new mysqlquery();

// 设置响应头为JSON
header('Content-Type: application/json; charset=utf-8');

// 查询示例：获取最新10条新闻
$sql = $empire->query("SELECT id, title, newstime, titleurl FROM {$dbtbpre}ecms_news ORDER BY newstime DESC LIMIT 10");

$data = array();
while ($r = $empire->fetch($sql)) {
    $data[] = array(
        'id' => (int)$r['id'],
        'title' => htmlspecialchars($r['title']),
        'newstime' => (int)$r['newstime'],
        'url' => $r['titleurl']
    );
}

// 输出JSON数据
echo json_encode(array('code' => 0, 'msg' => 'success', 'data' => $data), JSON_UNESCAPED_UNICODE);

// 释放资源
$empire->free($sql);
db_close();
?>

// 获取栏目ID参数
$classid = (int)$_GET['classid'] ?? 0;
$limit = (int)$_GET['limit'] ?? 10;

$where = '';
if ($classid > 0 && in_array($classid, $class_r)) {
    $where = " WHERE classid='$classid'";
}

$sql = $empire->query("SELECT id, title, newstime, titleurl FROM {$dbtbpre}ecms_news $where ORDER BY newstime DESC LIMIT $limit");

{
  "code": 0,
  "msg": "success",
  "data": [
    {
      "id": 123,
      "title": "新闻标题",
      "newstime": 1700000000,
      "url": "/news/123.html"
    }
  ]
}

{"code": 1, "msg": "参数错误", "data": []}