效果图
获取当前在线用户数
DB::result_first("SELECT COUNT(*) FROM " . DB::table('session') . " WHERE uid");
调用示例:
$zaixianrenshu = DB::result_first("SELECT COUNT(*) FROM " . DB::table('session') . " WHERE uid");
echo $zaixianrenshu;
获取总用户数
DB::result_first("SELECT COUNT(*) FROM " . DB::table('user') . " WHERE uid");
调用示例:
$yonghurenshu = DB::result_first("SELECT COUNT(*) FROM " . DB::table('user') . " WHERE uid");
echo $yonghurenshu;
获取停用用户数
DB::result_first("SELECT COUNT(*) FROM " . DB::table('user') . " WHERE status");
调用示例:
$tingyongrenshu = DB::result_first("SELECT COUNT(*) FROM " . DB::table('user') . " WHERE status");
echo $tingyongrenshu;
案例
以在首页头部显示为例
文件:\dzz\index_simple\index.php
在include template('main');
前插入
$zaixianrenshu = DB::result_first("SELECT COUNT(*) FROM " . DB::table('session') . " WHERE uid");
$yonghurenshu = DB::result_first("SELECT COUNT(*) FROM " . DB::table('user') . " WHERE uid");
$tingyongrenshu = DB::result_first("SELECT COUNT(*) FROM " . DB::table('user') . " WHERE status");
文件:\dzz\index_simple\template\header_search.htm 如果该目录下没有header_search.htm就新建
在线人数:$zaixianrenshu
用户数:$yonghurenshu
停用人数:$tingyongrenshu
如果还未生效话,清理系统缓存试试。