emlog主题添加文章评论数量和最近更新时间统计栏目代码教程

02444

教程介绍
首页调用代码,直接丢到log_list.php文件里头，不同模板首页文件可能不同根据情况而定，跑不了一般是index，当然也有人会问具体丢首页文件的哪里？因为有很多那种刚玩网站的”大佬”不知道加哪里，然而加了把网站也打不开的那种，只要记住代码丢后面基本会没错，具体放入位置，看个人喜欢吧！

操作步骤

<!--统计栏目-->
<div class="tpt-wp cl">
<ul>
<li class="tpt-md-4"><div class="tpt-cm">
<i class="layui-icon fa fa-folder-open-o" style="font-size: 20px; color: #e4ad85;vertical-align: middle;
    margin: 0px 3px;"></i>文章资源 <font color="#03f"><?php echo $sta_cache['lognum']; ?></font> 篇</div>
</li>
<li class="tpt-md-4"><div class="tpt-cm">
<i class="layui-icon fa fa-commenting-o" style="font-size: 20px; color: #27c24c;vertical-align: middle;
    margin: 0px 3px;"></i>评论回复 <font color="#03f"><?php echo $sta_cache['comnum_all']; ?></font> 次</div>
</li>
<li class="tpt-md-4"><div class="tpt-cm">
<i class="layui-icon fa fa-user-o" style="font-size: 20px; color: #23b7e5;vertical-align: middle;
    margin: 0px 3px;"></i>网站用户 <font color="#03f"><?php echo count_user_all();?> </font>位</div>
</li>
<li class="tpt-md-4"><div class="tpt-cm">
<i class="layui-icon fa fa-history" style="font-size: 20px; color: #7266ba;vertical-align: middle;
    margin: 0px 3px;"></i>最后更新 <font color="#ff0000"><?php echo last_post_log();?></font></a ></div>
</li>
</ul>
</div>

1、module.php文件添加以下代码,前台调用,具体你想调用哪些还是个人喜欢。

<?php
    //统计文章总数
    function count_log_all(){
        $db = MySql::getInstance();
        $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "blog WHERE type = 'blog'");
        return $data['total'];
    }

    //置顶文章数
    function count_log_top(){
        $db = MySql::getInstance();
        $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "blog WHERE  top = 'y' or sortop = 'y' AND type = 'blog'");
        return $data['total'];
    }
    //隐藏文章数
    function count_log_hide(){
        $db = MySql::getInstance();
        $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "blog WHERE hide = 'y' AND type = 'blog'");
        return $data['total'];
    }

    //未审核文章数
    function count_log_check(){
        $db = MySql::getInstance();
        $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "blog WHERE checked = 'n' AND type = 'blog'");
        return $data['total'];
    }

    //加密文章数
    function count_log_pass(){
        $db = MySql::getInstance();
        $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "blog WHERE  password !='' AND type = 'blog'");
        return $data['total'];
    }

    //统计页面总数
    function count_page_all(){
        $db = MySql::getInstance();
        $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "blog WHERE type = 'page'");
        return $data['total'];
    }

    //统计评论总数
    function count_com_all(){
        $db = MySql::getInstance();
        $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "comment");
        return $data['total'];
    }
    //统计友链总数
    function count_link_all(){
        $db = MySql::getInstance();
        $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "link");
        return $data['total'];
    }

    //统计微语评论总数
    function count_treply_all(){
        $db = MySql::getInstance();
        $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "reply");
        return $data['total'];
    }

    //统计分类总数
    function count_sort_all(){
        $db = MySql::getInstance();
        $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "sort");
        return $data['total'];
    }

    //统计子分类数
    function count_sort_mod(){
        $db = MySql::getInstance();
        $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "sort WHERE pid != 0");
        return $data['total'];
    }

    //统计标签总数
    function count_tag_all(){
        $db = MySql::getInstance();
        $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "tag");
        return $data['total'];
    }

    //统计微语总数
    function count_tw_all(){
        $db = MySql::getInstance();
        $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "twitter");
        return $data['total'];
    }

    //统计用户总数
    function count_user_all(){
        $db = MySql::getInstance();
        $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "user");
        return $data['total'];
    }

    //统计管理员总数
    function count_user_admin(){
        $db = MySql::getInstance();
        $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "user WHERE role = 'admin'");
        return $data['total'];
    }

    //统计作者总数
    function count_user_writer(){
        $db = MySql::getInstance();
        $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "user WHERE role = 'writer'");
        return $data['total'];
    }

    //统计附件总数
    function count_att_all(){
        $db = MySql::getInstance();
        $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "attachment");
        return $data['total'];
    }

    //最后发表文章时间 
    function last_post_log(){
        $db = MySql::getInstance();
        $sql = "SELECT * FROM " . DB_PREFIX . "blog WHERE type='blog' ORDER BY date DESC LIMIT 0,1";
        $res = $db->query($sql);
        $row = $db->fetch_array($res);
        $date = date('Y-n-j H:i',$row['date']);
        return $date;       
    };
?><?php
    //统计文章总数
    function count_log_all(){
        $db = MySql::getInstance();
        $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "blog WHERE type = 'blog'");
        return $data['total'];
    }

    //置顶文章数
    function count_log_top(){
        $db = MySql::getInstance();
        $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "blog WHERE  top = 'y' or sortop = 'y' AND type = 'blog'");
        return $data['total'];
    }
    //隐藏文章数
    function count_log_hide(){
        $db = MySql::getInstance();
        $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "blog WHERE hide = 'y' AND type = 'blog'");
        return $data['total'];
    }

    //未审核文章数
    function count_log_check(){
        $db = MySql::getInstance();
        $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "blog WHERE checked = 'n' AND type = 'blog'");
        return $data['total'];
    }

    //加密文章数
    function count_log_pass(){
        $db = MySql::getInstance();
        $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "blog WHERE  password !='' AND type = 'blog'");
        return $data['total'];
    }

    //统计页面总数
    function count_page_all(){
        $db = MySql::getInstance();
        $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "blog WHERE type = 'page'");
        return $data['total'];
    }

    //统计评论总数
    function count_com_all(){
        $db = MySql::getInstance();
        $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "comment");
        return $data['total'];
    }
    //统计友链总数
    function count_link_all(){
        $db = MySql::getInstance();
        $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "link");
        return $data['total'];
    }

    //统计微语评论总数
    function count_treply_all(){
        $db = MySql::getInstance();
        $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "reply");
        return $data['total'];
    }

    //统计分类总数
    function count_sort_all(){
        $db = MySql::getInstance();
        $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "sort");
        return $data['total'];
    }

    //统计子分类数
    function count_sort_mod(){
        $db = MySql::getInstance();
        $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "sort WHERE pid != 0");
        return $data['total'];
    }

    //统计标签总数
    function count_tag_all(){
        $db = MySql::getInstance();
        $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "tag");
        return $data['total'];
    }

    //统计微语总数
    function count_tw_all(){
        $db = MySql::getInstance();
        $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "twitter");
        return $data['total'];
    }

    //统计用户总数
    function count_user_all(){
        $db = MySql::getInstance();
        $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "user");
        return $data['total'];
    }

    //统计管理员总数
    function count_user_admin(){
        $db = MySql::getInstance();
        $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "user WHERE role = 'admin'");
        return $data['total'];
    }

    //统计作者总数
    function count_user_writer(){
        $db = MySql::getInstance();
        $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "user WHERE role = 'writer'");
        return $data['total'];
    }

    //统计附件总数
    function count_att_all(){
        $db = MySql::getInstance();
        $data = $db->once_fetch_array("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "attachment");
        return $data['total'];
    }

    //最后发表文章时间 
    function last_post_log(){
        $db = MySql::getInstance();
        $sql = "SELECT * FROM " . DB_PREFIX . "blog WHERE type='blog' ORDER BY date DESC LIMIT 0,1";
        $res = $db->query($sql);
        $row = $db->fetch_array($res);
        $date = date('Y-n-j H:i',$row['date']);
        return $date;       
    };
?>

2、CSS部分 丢到公共的css文件即可！一般是mian.css，不同小众模板可能略有不同。

/*统计栏目*/
.new-content {margin-top: 5px;}
.tpt-wp{margin:0 auto;width:100%}.tpt-cm{color: #333;text-align: center;background: #FFF;height: 60px;line-height: 60px;    border: 1px solid #eaeaea;}.tpt-md-4{float:left}.tpt-md-3{float:left}.tpt-md-2{float:left}.tpt-md-1{width:100%}
@media only screen and (max-width:767px){.tpt-md-4{width:50%}.tpt-md-3{width:100%}.tpt-md-2{width:100%}.tpt-ml-3{display:none}.tpt-mr-3{display:none}.tpt-ml-7{width:100%}.tpt-mr-7{width:100%}}
@media only screen and (min-width:768px) and (max-width:1023px){.tpt-md-4{width:50%}.tpt-md-3{width:50%}.tpt-md-2{width:50%}.tpt-ml-3{display:none}.tpt-mr-3{display:none}.tpt-ml-7{width:100%}.tpt-mr-7{width:100%}}
@media only screen and (min-width:1024px) and (max-width:1199px){.tpt-md-4{width:33.33333333%}.tpt-md-3{width:33.33333333%}.tpt-md-2{width:50%}.tpt-ml-3{float:left;width:30%}.tpt-mr-3{float:right;width:30%}.tpt-ml-7{float:left;width:70%}.tpt-mr-7{float:right;width:70%}}
@media only screen and (min-width:1200px){.tpt-md-4{width:25%}.tpt-md-3{width:33.33333333%}.tpt-md-2{width:50%}.tpt-ml-3{float:left;width:30%}.tpt-mr-3{float:right;width:30%}.tpt-ml-7{float:left;width:70%}.tpt-mr-7{float:right;width:70%}.tpt-wp{width:100%;margin:0 auto;}}
THE END
网页代码
# CSS# Emlog
喜欢就支持一下吧
点赞44 分享
xizii.com的头像-夕子小屋
美杜莎女王A2041-夕子小屋
美杜莎女王A2041
美杜莎女王A2041
40天前 3551
宝塔面板纯净版（免费使用所有插件）V8.0.5-夕子小屋
宝塔面板纯净版（免费使用所有插件）V8.0.5
宝塔面板纯净版（免费使用所有插件）V8.0.5
1个月前 3297
秘书制服清漪A1942-夕子小屋
秘书制服清漪A1942
秘书制服清漪A1942
1个月前 3279
护士云曦A1943-夕子小屋
护士云曦A1943
护士云曦A1943
1个月前 3191
居家云曦A2043-夕子小屋
居家云曦A2043
居家云曦A2043
40天前 3112
兔女郎小舞A1918-夕子小屋
兔女郎小舞A1918
兔女郎小舞A1918
1个月前 2610
相关推荐
网站添加底部小鱼特效【JS特效】-夕子小屋
网站添加底部小鱼特效【JS特效】
网站添加底部小鱼特效【JS特效】
5个月前 545
网站侧边栏添加旗下站点小工具导航-夕子小屋
网站侧边栏添加旗下站点小工具导航
网站侧边栏添加旗下站点小工具导航
3个月前 1140
只言语 — 静态导航主页源码-夕子小屋
只言语 — 静态导航主页源码
只言语 — 静态导航主页源码
3个月前 1144
WordPress 文章发布或更新时发送邮件通知用户-夕子小屋
WordPress 文章发布或更新时发送邮件通知用户
WordPress 文章发布或更新时发送邮件通知用户
3个月前 751
给自己的网站添加个导航卡片小工具-夕子小屋
给自己的网站添加个导航卡片小工具
给自己的网站添加个导航卡片小工具
5个月前 263
WordPress设置网站动态标题[WP教程]-夕子小屋
WordPress设置网站动态标题[WP教程]
WordPress设置网站动态标题[WP教程]
5个月前 625
评论 抢沙发
头像
欢迎您留下宝贵的见解！
提交
头像

昵称

取消
昵称

请填写用户信息：

  • 昵称(必填)
  • 邮箱(必填)
表情
[aoman][baiyan][bishi][bizui][cahan][ciya][dabing][daku][deyi][doge][fadai][fanu][fendou][ganga][guzhang][haixiu][hanxiao][zuohengheng][zhuakuang][zhouma][zhemo][zhayanjian][zaijian][yun][youhengheng][yiwen][yinxian][xu][xieyanxiao][xiaoku][xiaojiujie][xia][wunai][wozuimei][weixiao][weiqu][tuosai][tu][touxiao][tiaopi][shui][se][saorao][qiudale][qinqin][qiaoda][piezui][penxue][nanguo][liulei][liuhan][lenghan][leiben][kun][kuaikule][ku][koubi][kelian][keai][jingya][jingxi][jingkong][jie][huaixiao][haqian][aini][OK][qiang][quantou][shengli][woshou][gouyin][baoquan][aixin][bangbangtang][xiaoyanger][xigua][hexie][pijiu][lanqiu][juhua][hecai][haobang][caidao][baojin][chi][dan][kulou][shuai][shouqiang][yangtuo][youling]
代码

请输入代码：

确认

    暂无评论内容

用户封面
xizii.com的头像-夕子小屋
居家云曦-夕子小屋
3112人已阅读
居家云曦A2043
TOP1
美杜莎女王-夕子小屋
美杜莎女王A2041
40天前3551人已阅读
TOP2
宝塔面板纯净版（免费使用所有插件）-夕子小屋
宝塔面板纯净版（免费使用所有插件）V8.0.5
1个月前3297人已阅读
TOP3
护士云曦-夕子小屋
护士云曦A1943
1个月前3191人已阅读
TOP4
秘书制服清漪-夕子小屋
秘书制服清漪A1942
1个月前3279人已阅读
TOP5
报纸墙背景少女-夕子小屋
报纸墙背景少女A1941
1个月前2150人已阅读
TOP6