<div class="hd">站点统计</div>
<div class="bd">
<ul>
<li>新闻:[e:loop={'select count(*) as total from [!db.pre!]ecms_news ',1,24,0}]<?=$bqr[total]?>[/e:loop]条</a> ‖ 文章:[e:loop={'select count(*) as total from [!db.pre!]ecms_article ',1,24,0}]<?=$bqr[total]?>[/e:loop]篇</li>
<li>视频:[e:loop={'select count(*) as total from [!db.pre!]ecms_movie ',1,24,0}]<?=$bqr[total]?>[/e:loop]个 ‖ 资源:[e:loop={'select count(*) as total from [!db.pre!]ecms_download ',1,24,0}]<?=$bqr[total]?>[/e:loop]件</li>
<li>图片:[e:loop={'select count(*) as total from [!db.pre!]ecms_photo ',1,24,0}]<?=$bqr[total]?>[/e:loop]张 ‖ 留言:[e:loop={'select count(*) as total from [!db.pre!]enewsgbook where checked=0',1,24,0}]<?=$bqr[total]?>[/e:loop]
条</li>
<li>评论:<?=$empire->gettotal("select count(*) as total from phome_enewspl_1");?>次‖
<?php
$members=$empire->gettotal("select count(*) as total from phome_enewsmember");
$newmember=$empire->fetch1("select userid,username from phome_enewsmember order by userid desc limit 1");
?>
会员:<?=$members?>人
<br>
</li>
</ul>
</div>
前台调用发布信息统计
1、按字段="值":<?=$empire->gettotal("select count(*) as total from phome_ecms_news where 字段='值'")?>
2、统计有多少附件:一共有 <?=$empire->gettotal("select count(*) as total from phome_enewsfile")?> 个附件
3、注册会员ID:<?=$empire->gettotal("select count(*) as total from phome_ecms_news where userid=会员ID and ismember=1");?>
扫一扫 在手机阅读、分享本文
版权所有:《董为坚个人网》
本文地址:https://www.dwjgrw.cn/Content/id/428.html 复制地址
本站内容除特别注明外,均为《董为坚个人网》原创,欢迎转载!转载请注明本文地址,谢谢!
- 2023-1-22 17:41:09帝国CMS7.5支持PHP7.*系列,兼容性更好
- 2023-1-22 2:37:50调用当前“结合项”属性下的文章数量
- 2023-1-15 17:41:10帝国CMS官方互联登录插件登录后返回当前地址
- 2023-1-15 17:37:11帝国CMS如何调用栏目别名
- 2023-1-15 14:01:40帝国在封面页显示当前栏目下的二级栏目、三级栏目下的所
暂无评论