php调用文章至首页,[转载]wordpress首页如何调用最新文章等代码

显示最新文章<?php

query_posts('showposts=5'); ?>

?>

href="<?php the_permalink()

?>"><?php the_title();

?>

显示热评文章<?php

$result = $wpdb->get_results("SELECT

comment_count,ID,post_title FROM $wpdb->posts ORDER

BY comment_count DESC LIMIT 0 , 10");

foreach ($result as $topten) {

$postid = $topten->ID;

$title = $topten->post_title;

$commentcount = $topten->comment_count;

if ($commentcount != 0) { ?>

href="<?php echo get_permalink($postid);

?>" title="<?php echo $title

?>"><?php echo $title

?>

显示最新评论

global $wpdb;

$sql = "SELECT DISTINCT ID, post_title, post_password,

comment_ID,

comment_post_ID, comment_author, comment_date_gmt,

comment_approved,

comment_type,comment_author_url,

SUBSTRING(comment_content,1,30) AS com_excerpt

FROM $wpdb->comments

LEFT OUTER JOIN $wpdb->posts ON

($wpdb->comments.comment_post_ID =

$wpdb->posts.ID)

WHERE comment_approved = '1' AND comment_type = '' AND

post_password = ''

ORDER BY comment_date_gmt DESC

LIMIT 10";

$comments = $wpdb->get_results($sql);

$output = $pre_HTML;

$output .= "n

• ";

foreach ($comments as $comment) {

$output .=

"n

".strip_tags($comment->comment_author)

.":" . "

get_permalink($comment->ID) .

"#comment-" . $comment->comment_ID . "" title="on

" .

$comment->post_title . "">" .

strip_tags($comment->com_excerpt)

."

";

}

$output .= "n

";

$output .= $post_HTML;

echo $output;?>

显示文章分类

Categories

?>

显示Wordpress标签云

wp_tag_cloud('smallest=8&largest=36&');

?>

显示归档

Archives

?>

在侧栏显示页面列表

Pages

?>