给emlog主页添加统计栏目代码及教程 - 小飞资源网

给emlog主页添加统计栏目代码及教程

作者: 小飞

全网最全的网络资源分享网站

手机扫码查看

特别声明:文章多为网络转载,资源使用一般不提供任何帮助,特殊资源除外,如有侵权请联系!

演示图:

1.jpg

第一步:

把下面代码加在log_list.php文件里具体位置自己定

<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>

第二步:

打开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;       
	};
?>

第三步:

添加CSS代码把下面代码添加到模板公共CSS文件 比如fee模板main.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;}}

好了大功告成

分享到:
打赏

文章版权信息
头像
站长签名: 小飞资源网(www.52fzyw.cn)免费资源分享平台

阅读时间:  发布于:2020-4-3

本文标题: 给emlog主页添加统计栏目代码及教程

本文链接: https://www.52fzyw.cn/post-774.html

版权声明:文章为《 小飞》原创,转载请保留出处!

分享到:

评论

切换注册

登录

您也可以使用第三方帐号快捷登录

切换登录

注册

觉得文章有用就打赏一下文章作者

支付宝扫一扫打赏

微信扫一扫打赏