附统计全站文章年度及总评论数和浏览数代码:
- 评论总数:
- <?php echo $wpdb->get_var(“SELECT COUNT(*) FROM $wpdb->comments”);?>
- 2015 评论总数:
- <?php echo $wpdb->get_var(“SELECT COUNT(*) FROM $wpdb->comments WHERE date_format(comment_date,’%Y’)=2015″);?>
- 全站文章总浏览数:
- <?php get_totalviews(); ?>
- 2015 全站文章总浏览数:
- <?php echo $wpdb->get_var(“SELECT SUM(meta_value+0) FROM $wpdb->postmeta,$wpdb->posts where $wpdb->posts.ID=$wpdb->postmeta.post_id and date_format(post_date,’%Y’)=2015 and meta_key = ‘views’“);?>