|
|

楼主 |
发表于 2014-1-3 19:23:57
|
显示全部楼层
本帖最后由 hardrock 于 2014-1-3 19:27 编辑
! W, q: C3 z: v6 R; E k
* _2 N) F, G. F5 kWordPress不用插件如何调用热门日志http://www.bluehostdemon.com/how-to-get-most-viewed-post.html 2013-11-05
3 b3 Z2 E& V" F) C: p' k- V1 B0 j( m1 F. z( F$ ^- Y
首先打开function.php,添加一段代码:
; Q9 W: H" N! u4 a0 W& Y function simple_get_most_viewed($posts_num=10, $days=300){/ o8 a/ u$ y" D2 g1 A2 R* e. G2 P
global $wpdb;
' J9 d2 k+ y" r$ X2 v* [! V8 L $sql = “SELECT ID , post_title , comment_count1 ~( \7 z0 { x% V
FROM $wpdb->posts; b9 d7 Q( p3 A: b r8 ?# m) i" \
WHERE post_type = ‘post’ AND TO_DAYS(now()) – TO_DAYS(post_date) < $days
$ _8 H- U) t- y" n% t G6 \0 e) n7 Z/ w4 a AND ($wpdb->posts.`post_status` = ‘publish’ OR $wpdb->posts.`post_status` = ‘inherit’)
( I2 H* r1 B- x+ |! y U ORDER BY comment_count DESC LIMIT 0 , $posts_num “;: `3 T; P" m$ r
$posts = $wpdb->get_results($sql);
3 Z$ A' p$ S. y7 K4 T $output = “”; S2 Q# M' ~" K+ c2 x2 E! ?
foreach ($posts as $post){
" `1 Y3 B4 U! a, T0 V5 K6 Q $output .= “n<li><a href= “”.get_permalink($post->ID).”" rel=”bookmark” title=”".$post->post_title.” (“.$post->comment_count.”条评论)” >”. $post->post_title.”</a></li>”;) b& ?' Q" n% @5 Z' v! V" ^
}" U, L1 C5 ~ y5 f o
echo $output;% Q6 Q6 {% q+ [ N2 C
} ; D. H6 `$ ~) {) c
其中 $posts_num=10, $days=300 是显示日志的数量和统计的天数,这里是指统计300天内最热门的10篇。: c; o* ?0 L( ]1 R5 `% G4 c
. U! b" y `+ }4 t; z& f3 E然后在你需要调用热门日志的地方插入- <?php simple_get_most_viewed(); ?>
复制代码 / M8 D X, w7 u1 p# w1 N
|
|