|
|
楼主 |
发表于 2014-1-3 19:23:57
|
显示全部楼层
本帖最后由 hardrock 于 2014-1-3 19:27 编辑
3 y# |' t1 A" i5 I* G' }# b7 O( F r. o9 R. `
WordPress不用插件如何调用热门日志http://www.bluehostdemon.com/how-to-get-most-viewed-post.html 2013-11-05
( g) S; ?; z7 A
$ w5 ^; _( e; l6 x1 u I6 T9 b$ H首先打开function.php,添加一段代码:5 E5 M; L/ R1 ^! i4 o0 x9 i8 e
function simple_get_most_viewed($posts_num=10, $days=300){
M5 r; N- t: Z global $wpdb;
K" R9 D5 {" d. q% [" O $sql = “SELECT ID , post_title , comment_count( l# a' g: t0 ]! F8 w2 @
FROM $wpdb->posts8 L+ Y5 @/ B5 d. {5 U
WHERE post_type = ‘post’ AND TO_DAYS(now()) – TO_DAYS(post_date) < $days8 E4 H/ l' P: a: Y. n1 m0 ?/ D
AND ($wpdb->posts.`post_status` = ‘publish’ OR $wpdb->posts.`post_status` = ‘inherit’)* A; ]& Q4 B1 G7 @# W
ORDER BY comment_count DESC LIMIT 0 , $posts_num “;8 s0 ~ z1 ~( b* d7 T
$posts = $wpdb->get_results($sql);3 _9 V3 k/ G1 F# Z$ [- A# J6 i
$output = “”;
) l5 Z1 e. s* {7 P: [. G% A ]* P5 N foreach ($posts as $post){
9 t$ u: ~; c1 d5 X9 J $output .= “n<li><a href= “”.get_permalink($post->ID).”" rel=”bookmark” title=”".$post->post_title.” (“.$post->comment_count.”条评论)” >”. $post->post_title.”</a></li>”;
3 B2 x4 I' J# V' e. X8 \) U }1 n. j! k9 ? d. t2 K
echo $output;, l, D; y. v" Z
} 4 p* D9 w/ M' g7 B9 {0 K! [
其中 $posts_num=10, $days=300 是显示日志的数量和统计的天数,这里是指统计300天内最热门的10篇。: ^. y7 N: k M5 s, e. Q/ z: J: P
7 C* [& L) N2 S' O- p( S
然后在你需要调用热门日志的地方插入- <?php simple_get_most_viewed(); ?>
复制代码 + w0 t, a6 N3 P' g: N
|
|