WordPress如何在首页显示所有文章评论

来自:互联网
时间:2018-08-29
阅读:

要想在博客首页调用所有文章的评论,请在需要的地方加入以下代码:

<aside id=comments>
<h3>最新评论</h3>
<?php global $wpdb;
$sql = "SELECT DISTINCT ID, post_title, post_password, comment_ID,
comment_post_ID, comment_author, comment_date, 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 = "" AND comment_author != "freexyz"
ORDER BY comment_date DESC
LIMIT 10 ";
$comments = $wpdb->get_results($sql);
$output = $pre_HTML;
foreach ($comments as $comment) {
$output .= "<dl><dt><small>$comment->comment_date</small><a href="". get_permalink($comment->ID)."#comment-".$comment->comment_ID."" title="".$comment->post_title."">".strip_tags($comment->comment_author).":</a></dt><dd>". strip_tags($comment->com_excerpt)."[...]</dd></dl>";
} $output .= $post_HTML;
echo $output;
?>
</aside>

在WHERE条件最后一条,我加了 AND comment_author != ‘freexyz’,表示,评论者不包括freexyz,也就是本站名称,这里改成你自己的用户名即可。如果希望现实自己的评论,就去掉这个条件。

返回顶部
顶部