|
|

楼主 |
发表于 2014-1-3 19:23:57
|
显示全部楼层
本帖最后由 hardrock 于 2014-1-3 19:27 编辑
9 b3 h5 l4 d7 U3 H! ~5 j. {
1 ]' D* N6 l$ xWordPress不用插件如何调用热门日志http://www.bluehostdemon.com/how-to-get-most-viewed-post.html 2013-11-05
4 G. {: o0 O3 u& u
- p6 b E$ G5 Y首先打开function.php,添加一段代码:. T+ A& |- T# E w/ d. ^! n
function simple_get_most_viewed($posts_num=10, $days=300){
1 x: |) {; e# V) [, t3 j global $wpdb;' _/ }$ W& v! Z
$sql = “SELECT ID , post_title , comment_count
9 J" T3 C+ M# [, M# L, C FROM $wpdb->posts9 I7 b3 j$ N+ e' Z8 L* Z7 P2 f9 Q
WHERE post_type = ‘post’ AND TO_DAYS(now()) – TO_DAYS(post_date) < $days
) k6 h; L- k7 ?/ L AND ($wpdb->posts.`post_status` = ‘publish’ OR $wpdb->posts.`post_status` = ‘inherit’); E9 S- x0 }! e5 o- c
ORDER BY comment_count DESC LIMIT 0 , $posts_num “;
8 ]: g X+ w+ `" X: q: ?- R# E $posts = $wpdb->get_results($sql);7 ]; G9 i: D0 m( O0 H& Y3 u( B
$output = “”;: _% P# N+ @, J6 h) ]8 e4 B
foreach ($posts as $post){/ G( D. C: h! H0 F/ S1 X
$output .= “n<li><a href= “”.get_permalink($post->ID).”" rel=”bookmark” title=”".$post->post_title.” (“.$post->comment_count.”条评论)” >”. $post->post_title.”</a></li>”;
9 a/ U% o$ A& Y { }5 C* m' D5 [! ~0 D' [4 L1 I$ x
echo $output;
' Q H/ p+ E1 ^$ ` }
2 E t0 ?. h$ w% n2 |1 ?其中 $posts_num=10, $days=300 是显示日志的数量和统计的天数,这里是指统计300天内最热门的10篇。
5 R2 X8 ]( H' F# q
+ Q. d, U/ u" r. x然后在你需要调用热门日志的地方插入- <?php simple_get_most_viewed(); ?>
复制代码 W3 K1 X$ w3 M1 P4 n* @
|
|