php文章月浏览数统计,WordPress非插件添加文章浏览次数统计功能

阅读：评论：0

/// get_most_viewed_format

/// 函数作用：取得阅读最多的文章

function get_most_viewed_format($mode = '', $limit = 10, $show_date = 0, $term_id = 0, $beforetitle= '(', $aftertitle = ')', $beforedate= '(', $afterdate = ')', $beforecount= '(', $aftercount = ')') {

global $wpdb, $post;

$output = '';

$mode = ($mode == '') ? 'post' : $mode;

$type_sql = ($mode != 'both') ? "AND post_type='$mode'" : '';

$term_sql = (is_array($term_id)) ? "AND $wpdb->_id IN (" . join(',', $term_id) . ')' : ($term_id != 0 ? "AND $wpdb->_id = $term_id" : '');

$term_sql.= $term_id ? " AND $wpdb->term_taxonomy.taxonomy != 'link_category'" : '';

$inr_join = $term_id ? "INNER JOIN $wpdb->term_relationships ON ($wpdb->posts.ID = $wpdb->term_relationships.object_id) INNER JOIN $wpdb->term_taxonomy ON ($wpdb->_taxonomy_id = $wpdb->_taxonomy_id)" : '';

// database query

$most_viewed = $wpdb->get_results("SELECT ID, post_date, post_title, (meta_value+0) AS views FROM $wpdb->posts LEFT JOIN $wpdb->postmeta ON ($wpdb->posts.ID = $wpdb->postmeta.post_id) $inr_join WHERE post_status = 'publish' AND post_password = '' $term_sql $type_sql AND meta_key = 'views' GROUP BY ID ORDER BY views DESC LIMIT $limit");

if ($most_viewed) {

foreach ($most_viewed as $viewed) {

$post_ID = $viewed->ID;

$post_views = number_format($viewed->views);

$post_title = esc_attr($viewed->post_title);

$get_permalink = esc_attr(get_permalink($post_ID));

$output .= "

$beforetitle$post_title$aftertitle";

if ($show_date) {

$posted = date(get_option('date_format'), strtotime($viewed->post_date));

$output .= "$beforedate $posted $afterdate";

}

$output .= "$beforecount $post_views $aftercount

}

} else {

$output = "

N/An";

}

echo $output;

}