登陆      注册    找回密码   会员投稿 宽屏版 I 换肤 手机版 | 收藏本站   当前时间是: 
首页>技术文档>php学习>正文


帝国站点统计、发布信息统计

来源:互联网   作者:佚名   浏览:151次   发表时间:2022-10-3 5:06:02
【字体: 视力保护色:

 <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/ 【关闭窗口
注:转载或者复制本站文章,必须带上董为坚个人网链接。
部分文章来源于网络,如有侵权联系删除!
扫一扫在手机阅读

扫一扫 在手机阅读、分享本文


上一篇:热爱自我
下一篇:酷狗音乐API接口大全(40+个)

版权所有:《董为坚个人网
本文地址:https://www.dwjgrw.cn/Content/id/428.html   复制地址
本站内容除特别注明外,均为《董为坚个人网》原创,欢迎转载!转载请注明本文地址,谢谢!


  评论列表

暂无评论

  发表评论 [评论会通过邮件和短信的形式通知我,我会及时回复,一定回来看哦!!!]
昵称: [必填]
邮箱: [必填]
内容:

           

[必填]
验证码:   
                     
给我留言 申请友链Copyright © 2012- 董为坚个人网, All rights reserved 手机版
本站已正常运行3462天技术顾问:董为坚个人网 ( 桂ICP备15004478号-1 )
  今日更新:1篇, 最后更新:2022-11-30联系QQ1115030108,邮箱:1115030108@qq.com
今日有459人访问,总访问数828277人请勿发布违反中华人民共和国法律法规的言论.