|
|
楼主 |
发表于 2014-1-3 19:23:57
|
显示全部楼层
本帖最后由 hardrock 于 2014-1-3 19:27 编辑 % s2 d E$ Z. A, _9 ?; q( P: W6 b
# |# O5 o1 ]& ^WordPress不用插件如何调用热门日志http://www.bluehostdemon.com/how-to-get-most-viewed-post.html 2013-11-05 H! A& o0 P9 e/ v1 E0 m* f7 L
& B |4 b9 y- K) G
首先打开function.php,添加一段代码:# D8 W7 Y$ t. X) Q; {* r
function simple_get_most_viewed($posts_num=10, $days=300){
! H) N3 y1 i4 Q+ \4 B global $wpdb;! y0 g& K3 M7 P) S3 o9 \3 z' \
$sql = “SELECT ID , post_title , comment_count! J$ s3 G( F, ^6 q& [9 K8 Z# [6 h
FROM $wpdb->posts
[) H( M, i1 B/ P- C8 g# U/ }1 l WHERE post_type = ‘post’ AND TO_DAYS(now()) – TO_DAYS(post_date) < $days! { v/ u+ D9 `' D
AND ($wpdb->posts.`post_status` = ‘publish’ OR $wpdb->posts.`post_status` = ‘inherit’)
/ m3 }# O0 |: y0 g ORDER BY comment_count DESC LIMIT 0 , $posts_num “;
; P, a/ U: m' W+ j $posts = $wpdb->get_results($sql);
0 c' B9 [+ O Z: b$ Q- F $output = “”;
5 `' J, y. p- D, ]% B) V5 N7 ^ foreach ($posts as $post){- I: N6 w8 d5 D7 G; z: c- z
$output .= “n<li><a href= “”.get_permalink($post->ID).”" rel=”bookmark” title=”".$post->post_title.” (“.$post->comment_count.”条评论)” >”. $post->post_title.”</a></li>”;
2 n/ _! o, a' Z }2 }( w" n3 A, E& j* ~
echo $output;
+ ~% [, g7 K7 m3 }% e }
8 Y) ^- q6 O# l: }其中 $posts_num=10, $days=300 是显示日志的数量和统计的天数,这里是指统计300天内最热门的10篇。
8 t& S X$ I- N
1 j! @; f8 B1 V+ F+ ^然后在你需要调用热门日志的地方插入- <?php simple_get_most_viewed(); ?>
复制代码 , h+ E3 N0 O, }' q) j4 v; w
|
|