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

作者：袖梨 2022-06-25

这里就不介绍页面的建设方法了。明凯博客里面有介绍。搜索一下就可以了。

一、函数代码：

代码如下

复制代码

< ?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_pass

word = '' ORDER BY post_views_count DESC LIMIT $limit");
if($most_viewed) {
$num=1;
foreach ($most_viewed as $post) {
$output .= "＼nID)."＼" 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 .= "