|
楼主 |
发表于 2014-1-3 19:23:57
|
显示全部楼层
本帖最后由 hardrock 于 2014-1-3 19:27 编辑 4 p# i/ G, i1 l; Q$ S
2 r: j& G' Q7 o3 L3 L% w1 M( SWordPress不用插件如何调用热门日志http://www.bluehostdemon.com/how-to-get-most-viewed-post.html 2013-11-05( n; |" m b V+ t
. B |6 K. \+ c& p
首先打开function.php,添加一段代码:8 @ W/ `$ K- B
function simple_get_most_viewed($posts_num=10, $days=300){3 h2 G: V: T' O9 h+ @' |
global $wpdb;
6 H# P6 q- w! m8 C. z# M# W $sql = “SELECT ID , post_title , comment_count
! A8 l# z# l1 `6 w FROM $wpdb->posts' d+ _6 a( {1 a; K9 ], B: r$ z3 Q( w
WHERE post_type = ‘post’ AND TO_DAYS(now()) – TO_DAYS(post_date) < $days
: T$ k+ Z: B8 k3 O2 J) b6 ` AND ($wpdb->posts.`post_status` = ‘publish’ OR $wpdb->posts.`post_status` = ‘inherit’)/ K2 t1 Z7 n, Q7 n
ORDER BY comment_count DESC LIMIT 0 , $posts_num “;, g% n$ t( l2 ]8 J4 b9 z
$posts = $wpdb->get_results($sql);6 G/ T& B" ]- m& P& X8 m) e
$output = “”;
& `6 E& R0 @- ] foreach ($posts as $post){
, V6 x6 o+ \% q $output .= “n<li><a href= “”.get_permalink($post->ID).”" rel=”bookmark” title=”".$post->post_title.” (“.$post->comment_count.”条评论)” >”. $post->post_title.”</a></li>”;
2 X- F+ ?* i7 \6 U$ L _ }
! g. i+ W' B! ]4 ~: U6 k echo $output;# L2 P N7 z! v. ]6 A
}
- Q# i/ m) `6 L& y* q其中 $posts_num=10, $days=300 是显示日志的数量和统计的天数,这里是指统计300天内最热门的10篇。
# c; W% e7 \+ H9 N! ?+ P3 M; F1 J* N; Q4 f" @) ~; j: w
然后在你需要调用热门日志的地方插入- <?php simple_get_most_viewed(); ?>
复制代码 9 f: d% q+ o u0 ]6 ?8 Z0 L
|
|