wordpress添加阅读和评论排行榜功能例子

< ?php
//文章排行
function most_viewed($time,$limit) {
global $wpdb, $post;
$output = "

";
$most_viewed = $wpdb->get_results("SELECT DISTINCT $wpdb->posts.*, (meta_value+0) AS post_views_count FROM $wpdb->posts LEFT JOIN $wpdb->postmeta ON $wpdb->postmeta.post_id = $wpdb->posts.ID WHERE post_date > date_sub( now(), interval $time day ) AND post_type ='post' AND post_status = 'publish' AND meta_key = 'post_views_count' AND post_password = '' ORDER BY post_views_count DESC LIMIT $limit");
if($most_viewed) {
$num=1;
foreach ($most_viewed as $post) {
$output .= "＼n
• ID)."＼" rel=＼"bookmark＼" title=＼"".$post->post_title." (".$post->post_views_count."+)＼" >$num. ". $post->post_title." (".$post->post_views_count."+)
";
$num++;
}
$output .= "
";
echo $output;
}
}
//评论排行
function most_commmented($time,$limit) {
global $wpdb, $post;
$output = "
";
$most_viewed = $wpdb->get_results("SELECT DISTINCT $wpdb->posts.* FROM $wpdb->posts  WHERE post_date > date_sub( now(), interval $time day ) AND post_type ='post' AND post_status = 'publish'  AND post_password = '' ORDER BY comment_count DESC LIMIT $limit");
if($most_viewed) {
$num=1;
foreach ($most_viewed as $post) {
$output .= "＼n
• ID)."＼" rel=＼"bookmark＼" title=＼"".$post->post_title." (".$post->comment_count."+)＼" >$num. ". $post->post_title." (".$post->comment_count."+)
";
$num++;
}
$output .= "

";
echo $output;
}
}
?>

本月浏览量排行

本月评论量排行

年度浏览量排行

年度评论量排行