Showing the most recent comments is great for SEO purpose. Our code snippet will able to get recent comments without wordpress plugin in your wordpress site.
get recent comments without wordpress plugin
You can display the most recent comments of your entire blog without any wordpress plugin. Showing the most recent comments is great for SEO purpose. Your site will increase the visibility and people interaction. Socially you and your blog will became more famous. Using following code snippet you will be able to add the recent comments in your wordpress site.
I want to display the comments in footer area. I created following code. You can copy paste the code in your sidebar.php or footer.php file.
Using following code you are able to display recent comments with author’s gr-avatar also.
<?php
$total_comments = $wpdb->get_results("SELECT comment_date_gmt, comment_author, comment_ID, comment_post_ID, comment_author_email FROM $wpdb->comments WHERE comment_approved = '1' and comment_type != 'trackback' ORDER BY comment_date_gmt DESC LIMIT 10");
$comment_total = count($total_comments);
echo '<ul>';
for ($comments = 0; $comments < $comment_total; $comments++) {
echo "<div style='clear:both;width:355px;padding-top:3px;'><div style='float:left;width:35px;'>";
echo get_avatar($total_comments[$comments]->comment_author_email,$size='32',$default='<path_to_url>' );
echo "</div> <div style='width:320px;'>";
echo '<li>';
echo $total_comments[$comments]->comment_author . ' says ';
echo '<a href="'. get_permalink($total_comments[$comments]->comment_post_ID) . '#comment-' . $total_comments[$comments]->comment_ID . '">';
echo get_the_title($total_comments[$comments]->comment_post_ID);
echo '</a></li></div></div>';
}
echo '</ul>'
?>
My footer is looking like as follows:
your article is very amazing ,and i want to ask you a question : in my blog ,in the author page ,i just want to show the author’ s comment list ,how should i do .
Just use following code
$total_comments = $wpdb->get_results(“SELECT comment_date_gmt, comment_author, comment_ID, comment_post_ID, comment_author_email FROM $wpdb->comments WHERE comment_approved = ‘1’ and comment_author=’author name’ and comment_type != ‘trackback’ ORDER BY comment_date_gmt DESC LIMIT 10”);
What do I have to change to show the comment content not the title of the article on wich is the comment.
Thanks
HI! First of all great article!!
I have a question though…
In stead of showing the post the comments was made in I would like to show the actual comment from the person. How do I do that?
your article is very amazing ,and i want to ask you a question : in my blog ,in the author page ,i just want to show the author’ s comment list ,how should i do .
Use query_post
wow nice thank you for share ..