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:

get recent comments without wordpress plugin

get recent comments without wordpress plugin

Written by Purab

My name is Purab, Here is my Personal Blog: wpapi.com. I contributor of many wordpress plugins and Drupal Modules. I am core developer of Drupal. Connect to on LinkedIn or Follow @purab on Twitter or Follow me on Google+ or Write Mail to purabdk@gmail.com or Chat with me on Skype : purabdk

This article has 7 comments

  1. myskylover Reply

    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 .

    • sony Reply

      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”);

  2. Andrew Reply

    What do I have to change to show the comment content not the title of the article on wich is the comment.
    Thanks

  3. Maya Reply

    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?

  4. Electrolux servisi Reply

    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 .

Leave a Comment

Your email address will not be published. Required fields are marked *