|
|
楼主 |
发表于 2014-1-3 19:23:57
|
显示全部楼层
本帖最后由 hardrock 于 2014-1-3 19:27 编辑 . N( a1 w( A+ M5 N7 A+ s% J4 z" k
4 [/ Q) g! m! h# U A: N
WordPress不用插件如何调用热门日志http://www.bluehostdemon.com/how-to-get-most-viewed-post.html 2013-11-05, u3 S& O$ ~$ }! c
Q4 ^4 X: L8 P0 e) k首先打开function.php，添加一段代码：: u* V6 t( W2 N
function simple_get_most_viewed($posts_num=10, $days=300){" y0 a7 ^9 S! B! C$ C
global $wpdb;7 d/ { ^5 Q: G9 q+ Z
$sql = “SELECT ID , post_title , comment_count
! h) p# |; z# q. f0 b& m FROM $wpdb->posts" W7 W6 y2 i2 i3 c, h ^8 w
WHERE post_type = ‘post’ AND TO_DAYS(now()) – TO_DAYS(post_date) < $days8 [0 m& ^; N/ X/ S
AND ($wpdb->posts.`post_status` = ‘publish’ OR $wpdb->posts.`post_status` = ‘inherit’): d" `( [. d. `; `& D- r
ORDER BY comment_count DESC LIMIT 0 , $posts_num “;
3 Q3 o# y8 F, E) G* L $posts = $wpdb->get_results($sql);0 s2 P$ P2 v2 P
$output = “”;6 K- a: r' N9 c' o/ \; N V4 }
foreach ($posts as $post){
% Y) P0 |6 Z4 I; Q# y9 Q9 q $output .= “n<li><a href= “”.get_permalink($post->ID).”" rel=”bookmark” title=”".$post->post_title.” (“.$post->comment_count.”条评论)” >”. $post->post_title.”</a></li>”;, ]7 T# l) k. W- T! @2 d
}
. A2 t4 @% s) l echo $output;7 q. }4 f' |5 h/ a" L
}
其中 $posts_num=10, $days=300 是显示日志的数量和统计的天数，这里是指统计300天内最热门的10篇。/ [0 o7 V2 n8 i- G, S" V- r4 m
4 Q# Q! p. v* ^$ t
然后在你需要调用热门日志的地方插入- <?php simple_get_most_viewed(); ?>
 ; N5 j0 C4 }2 E Y, s8 Y0 K
|
|
发表于 2013-12-23 20:36:55
发表于 2013-12-23 21:34:03
楼主
