又来小小折腾下我的Wordpress:为我的Wordpress博客添加博客统计,效果在右下角。用各种数据库查询就能轻松实现哦~
直接Copy上我Wordpress 博客统计数据库查询代码的代码:
<li>日志总数:<?php $count_posts = wp_count_posts(); echo $published_posts = $count_posts->publish;?> 篇</li>
<li>评论总数:<?php echo $wpdb->get_var(“SELECT COUNT(*) FROM $wpdb->comments“);?> 条</li>
<li>标签数量:<?php echo $count_tags = wp_count_terms(‘post_tag’); ?> 个</li>
<li>建站日期:2009-09-09<br />
<li>运行天数:<?php echo floor((time()-strtotime(“2009-9-9″))/86400); ?> 天</li>
<li>最后更新:<?php $last = $wpdb->get_results(“SELECT MAX(post_modified) AS MAX_m FROM $wpdb->posts WHERE (post_type = ‘post’ OR post_type = ‘page’) AND (post_status = ‘publish’ OR post_status = ‘private’)”);$last = date(‘Y-n-j’, strtotime($last[0]->MAX_m));echo $last; ?></li>
<li>评论总数:<?php echo $wpdb->get_var(“SELECT COUNT(*) FROM $wpdb->comments“);?> 条</li>
<li>标签数量:<?php echo $count_tags = wp_count_terms(‘post_tag’); ?> 个</li>
<li>建站日期:2009-09-09<br />
<li>运行天数:<?php echo floor((time()-strtotime(“2009-9-9″))/86400); ?> 天</li>
<li>最后更新:<?php $last = $wpdb->get_results(“SELECT MAX(post_modified) AS MAX_m FROM $wpdb->posts WHERE (post_type = ‘post’ OR post_type = ‘page’) AND (post_status = ‘publish’ OR post_status = ‘private’)”);$last = date(‘Y-n-j’, strtotime($last[0]->MAX_m));echo $last; ?></li>
添加到你任意想展示的位置,搞定~
PS.发现我博客建立日期还是很吉利的~~
