|

楼主 |
发表于 2014-1-3 19:23:57
|
显示全部楼层
本帖最后由 hardrock 于 2014-1-3 19:27 编辑
+ s% D5 a( h' k0 F- o3 Z- I3 k; b i9 B* e2 B# p z, {4 d2 N
WordPress不用插件如何调用热门日志http://www.bluehostdemon.com/how-to-get-most-viewed-post.html 2013-11-05 J" j( P4 A [4 M, k/ Q- b6 o
! [: Y" v+ K5 X. \, ~6 |/ U
首先打开function.php,添加一段代码:5 l( C0 A4 Z1 H& {& \& K( [, a+ O
function simple_get_most_viewed($posts_num=10, $days=300){
( D c! [# ~ w2 h global $wpdb;9 B# Z+ J a( [, m- r( S) e
$sql = “SELECT ID , post_title , comment_count
3 ~% O% S2 E: Z2 \ FROM $wpdb->posts3 M$ X( J1 C! \2 Q: H
WHERE post_type = ‘post’ AND TO_DAYS(now()) – TO_DAYS(post_date) < $days
! X, Q# m/ b) r t# T' {' O! e' F AND ($wpdb->posts.`post_status` = ‘publish’ OR $wpdb->posts.`post_status` = ‘inherit’)
& ?4 J' R* j7 o3 A9 \0 P ORDER BY comment_count DESC LIMIT 0 , $posts_num “;
" C% o. ^3 q' ] $posts = $wpdb->get_results($sql);
% G! G0 x+ b7 d, L $output = “”;
1 n1 e Q& T3 R/ \9 e% ~0 u; t foreach ($posts as $post){: Z6 }) T$ ]4 a7 m4 w7 [
$output .= “n<li><a href= “”.get_permalink($post->ID).”" rel=”bookmark” title=”".$post->post_title.” (“.$post->comment_count.”条评论)” >”. $post->post_title.”</a></li>”;/ B8 y/ ?- p* E7 W( ^+ F: y: [
}
9 P7 N& {, v' p echo $output;$ V1 E) _# U t+ a, ^
} 4 p& a1 u8 p9 ?) p) n9 p
其中 $posts_num=10, $days=300 是显示日志的数量和统计的天数,这里是指统计300天内最热门的10篇。
! ~1 ~8 i# l+ _8 K' |' a q3 v
3 y8 I& f! N3 D# }5 W) i; @然后在你需要调用热门日志的地方插入- <?php simple_get_most_viewed(); ?>
复制代码
" Q3 `0 J5 P/ J' s" Z. E$ p7 s |
|