WordPress 相关 - 统计信息获取一览表

1
日志总数：<?php $count_posts = wp_count_posts(); echo $published_posts =$count_posts->publish;?>篇
2

3
草稿总数：<?php $count_posts = wp_count_posts(); echo $draft_posts = $count_posts->draft; ?>
4

5
页面总数：<?php $count_pages = wp_count_posts('page'); echo $page_posts = $count_pages->publish; ?>
6

7
用户总数：<?php $users = $wpdb->get_var("SELECT COUNT(ID) FROM $wpdb->users"); echo $users; ?>
8

9
成立时间：<?php echo floor((time()-strtotime("2009-8-23"))/86400); ?> //其中的年月日改成你自己的网站成立时间
10

11
分类总数：<?php echo $count_categories = wp_count_terms('category'); ?>个
12

13
标签总数：<?php echo $count_tags = wp_count_terms('post_tag'); ?>个
14

15
友情链接：<?php $link = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->links WHERE link_visible = 'Y'"); echo $link; ?>个
16

17
网站运行：<?php echo floor((time()-strtotime("2011-7-27"))/86400); ?>天
18

19
最后更新：<?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; ?>

1
//WordPress获取本周发布的文章数量
2

3
function get_week_post_count(){
4
  $date_query = array(
5
    array(
6
      'after'=>'1 week ago'
7
    )
8
  );$args = array(
9
    'post_type' => 'post',
10
    'post_status'=>'publish',
11
    'date_query' => $date_query,
12
    'no_found_rows' => true,
13
    'suppress_filters' => true,
14
    'fields'=>'ids',
15
    'posts_per_page'=>-1
16
  );
17
  $query = new WP_Query( $args );
18
  return $query->post_count;
19
}

1
<?php echo get_week_post_count()?>

1
//WordPress获取今天更新的文章数量
2

3
function get_posts_count_from_today($post_type ='post') {
4
    global $wpdb;
5

6
    $numposts = $wpdb->get_var(
7
        $wpdb->prepare(
8
            "SELECT COUNT(ID) ".
9
            "FROM {$wpdb->posts} ".
10
            "WHERE post_status='publish' ".
11
                "AND post_type= %s ".
12
                "AND DATE_FORMAT(post_date, '%Y-%m-%d') = %s",
13
            $post_type, date('Y-m-d', time())
14
        )
15
    );
16
    return $numposts;
17
}

1
<?php echo get_today_post_count()?>

1
<?php echo get_posts_count_from_today('site'); ?>

1
//WordPress获取最近24小时发布的文章数量
2
function get_posts_count_from_last_24h($post_type ='post') {
3
    global $wpdb;
4

5
    $numposts = $wpdb->get_var(
6
        $wpdb->prepare(
7
            "SELECT COUNT(ID) ".
8
            "FROM {$wpdb->posts} ".
9
            "WHERE ".
10
                "post_status='publish' ".
11
                "AND post_type= %s ".
12
                "AND post_date> %s",
13
            $post_type, date('Y-m-d H:i:s', strtotime('-24 hours'))
14
        )
15
    );
16
    return $numposts;
17
}

1
<?php echo get_posts_count_from_last_24h(); ?>

1
<?php echo get_posts_count_from_last_24h('site'); ?>