有时候想在网页中向访客展现emlog博客的文章数目、批评数目、运转时候等信息,但emlog背景侧边栏没有供应相干的模块,因而须要博主自立增加博客统计信息代码。下面是整顿的emlog网站信息统计代码,已在emlog 5.3.x上测试可用。
挪用代码:
要领一:官方缓存类统计代码。长处:加载速率快;瑕玷:大概信息更新不及时。
把以下代码增加到当前运用的主题模板文件中,如side.php文件:
1234567 | <?php $sta_cache = Cache::getInstance()->readCache('sta'); /*必需增加*/ ?><ul><li>文章总数:<?php echo $sta_cache['lognum']; ?> 篇</li><li>批评总数:<?php echo $sta_cache['comnum_all']; ?> 条</li><li>闲言碎语:<?php echo $sta_cache['twnum']; ?>条</li><li>网站运转:<?php echo floor((time()-strtotime(20160423))/86400); ?> 天</li></ul> |
附:$sta_cache[‘参数’]中的参数可选以下:
lognum 旅客可见日记总数
draftnum 草稿,也就是隐蔽文件数目
comnum 未隐蔽的批评数目
comnum_all 一切批评数目
hidecomnum 被隐蔽的批评数目
twnum 微语数目
checknum 未审核的文章数目
要领二:自编函数,经由过程SQL语句查询相干数据。瑕玷:加载速率较缓存类慢;长处:及时显现
把下面的代码增加到主题的module.php文件中:
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128 | <?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; };?> |
挪用代码:
1234567891011121314151617181920 | <ul><li>文章总数:<?php echo count_log_all();?></li><li>置顶文章:<?php echo count_log_top();?></li><li>隐蔽文章:<?php echo count_log_hide();?></li><li>待审文章:<?php echo count_log_check();?></li><li>加密文章:<?php echo count_log_pass();?></li><li>页面总数:<?php echo count_page_all();?></li><li>批评总数:<?php echo count_com_all();?></li><li>友链总数:<?php echo count_link_all();?></li><li>微语批评:<?php echo count_treply_all();?></li><li>分类总数:<?php echo count_sort_all();?></li><li>子分类数:<?php echo count_sort_mod();?></li><li>标签总数:<?php echo count_tag_all();?></li><li>微语总数:<?php echo count_tw_all();?></li><li>用户总数:<?php echo count_user_all();?></li><li>管理员数:<?php echo count_user_admin();?></li><li>作者总数:<?php echo count_user_writer();?></li><li>附件总数:<?php echo count_att_all();?></li><li>末了更新:<?php echo last_post_log();?></li></ul> |

评论列表