一、wordpress,请问wordpress怎样显示指定作者的文章数量和评论数量
Wordpress 如何显示作者文章数量和评论数量,这是通过数据库查询获得文章作者文章数量和评论数量,其代码如下:
$author_id = $current_user->ID;
$comment_count = $wpdb->get_var( $wpdb->prepare( “SELECT COUNT(*) FROM $wpdb->comments WHERE comment_approved='1′ AND user_id = '$author_id' AND comment_type not in ('trackback','pingback')” ) ); //查询作者评论数量
$post_count = $wpdb->get_var( $wpdb->prepare( “SELECT COUNT(*) FROM $wpdb->posts WHERE post_status IN ('publish','static') AND post_author = '$author_id' AND post_type = 'iask'” ) ); //查询作者文章数量
?>
下面是显示文章作者文章数和评论数:
文章数量:
点评数量:
将以上代码放到wordpress主题 single.php文件 loop内即可
希望能够帮到你。
二、wordpress 评论数排序文章问题
你用的是哪个版本的?我给你写了一段,你试下: global $wp_query; $args= array( 'post_type' => 'post', 'post_status' => 'publish', 'post__not_in' => array(1), 'orderby' => 'comment_count', 'ignore_sticky_posts' => true, 'posts_per_page' => 18 ); $wp_query = new WP_Query( $args ); var_dump($wp_query->query); var_dump($wp_query->request); if ( have_posts() ) : while ( have_posts() ) : the_post(); the_title(); // to do loop endwhile; endif; wp_reset_query();。
三、请教一下大神,wordpress如何实现,显示当前已登录用户的文章数量
当前已登录用户: get_current_user_id();// 或者 global $user_id;文章数量: count_user_posts($user_id )评论数量 global $wpdb;$count_user_comments = $wpdb->get_var( $wpdb->prepare("Select count(comment_ID) from $wpdb->comments where user_id = %d", $user_id) );var_dump($count_user_comments);。
四、WordPress如何让当前分类的文章列表按阅读量排列和热评数量排列
按阅读量排列,可安装插件 wp-postviews ,该插件提供了热门阅读文章列表调用代码: 或者 或者//显示最热门文章//显示某个或某些目录下最冷门文//显示某个或某些目录下最热门文章//显示指定标签下的最热门文章//显示指定标签下的最冷门文章//显示全站文章总共被浏览过多少次 特定时间内阅读量:### Function: Get TimeSpan Most Viewed function get_timespan_most_viewed($mode = '', $limit = 20, $days = 30, $display = true) { global $wpdb, $post;$limit_date = current_time('timestamp') - ($days*86400);$limit_date = date("Y-m-d H:i:s",$limit_date);$where = '';$temp = ''; if(!empty($mode) && $mode != 'both') {$where = "post_type = '$mode'"; } else {$where = '1=1'; }$most_viewed = $wpdb->get_results("SELECT DISTINCT $wpdb->posts.*, (meta_value+0) AS views FROM $wpdb->posts LEFT JOIN $wpdb->postmeta ON $wpdb->postmeta.post_id = $wpdb->posts.ID WHERE post_date '".$limit_date."' AND $where AND post_status = 'publish' AND meta_key = 'views' AND post_password = '' ORDER BY views DESC LIMIT $limit"); if($most_viewed) { foreach ($most_viewed as $post) {$post_title = get_the_title();$post_views = intval($post->views);$post_views = number_format($post_views);$temp .= "$post_title - $post_views ".__('views', 'wp-postviews').""; } } else {$temp = ''.__('N/A', 'wp-postviews').''."\n"; } if($display) { echo $temp; } else { return $temp; } }$days这个参数是多长时间内发表的文章,设置为30,就是1个月的热门文章。
转载请注明出处51数据库 » wordpress文章评论数