之前我的博客的最新评论一直是调用系统自带的,不支持头像,也不是那么美观,今天花费了差不多一个半小时找资料和改代码,终于将最新评论完美代码化,并进行了美化,效果如右,有兴趣的朋友也可以试着修改下自己的哦。(网上的代码不能显示出被评论的文章,我稍微修改了下,嘻嘻。。。。。。)
我的最终代码如下:
<h2>最新评论</h2>
<ul>
<?php
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,comment_author_email, SUBSTRING(comment_content,1,16) 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 user_id=’0′ ORDER BY comment_date_gmt DESC LIMIT 6″;
$comments = $wpdb->get_results($sql);
$output = $pre_HTML;
foreach ($comments as $comment)
{$output .= “\n<li><div id=sideavatar>”.get_avatar(get_comment_author_email(‘comment_author_email’), 48).”</div><div id=comment_anthor><span>”.strip_tags($comment->comment_author). “</span>发表于<a href=\”" . get_permalink($comment->ID) .”#comment-” . $comment->comment_ID . “\” title=\”on ” .$comment->post_title .”\” >”
. strip_tags($comment->post_title ).”:</a></div>”
. “<div id=comment_excerpt>” . strip_tags($comment->com_excerpt).”…</div></li>”;}
$output .= $post_HTML;
echo $output;?>
</ul>