直接在模板中嵌入 PHP,調用帝國 CMS 核心類 $empire 的 gettotal() 方法執行 COUNT(*) SQL 查詢,實時統計對應數據表記錄數,無需緩存、無延遲。
將以下代碼放入首頁模板 (index.temp.htm) 任意位置即可:
<?=$empire->gettotal("SELECT COUNT(*) AS total FROM phome_enewsmember");?>
<?=$empire->gettotal("SELECT COUNT(*) AS total FROM phome_enewsgbook");?>
<?=$empire->gettotal("SELECT COUNT(*) AS total FROM phome_enewspl_1");?>
<?php
// 今日新增會員
$today = date('Y-m-d');
$today_reg = $empire->gettotal("SELECT COUNT(*) AS total FROM phome_enewsmember WHERE DATE(FROM_UNIXTIME(regtime)) = '$today'");
// 已審核評論數
$approved_pl = $empire->gettotal("SELECT COUNT(*) AS total FROM phome_enewspl_1 WHERE checked=1");
// 指定欄目評論數
$classid = 5;
$class_pl = $empire->gettotal("SELECT COUNT(*) AS total FROM phome_enewspl_1 WHERE classid=$classid AND checked=1");
?>
今日新增會員: <?=$today_reg?> | 已審評論: <?=$approved_pl?> | 欄目=$classid?>評論: <?=$class_pl?>
phome_,若安裝時自定義前綴請對應修改。phome_enewspl_1、_2...),統計全站評論需 UNION ALL 或遍歷所有分表求和。COUNT(*) 在大表 (百萬級+) 可能較慢,高頻調用建議寫入緩存 (如 sys_Config 表單獨字段) 定時任務更新。