X

Total Number of Comments

Snippets by IsItWP

Do you want to get all comments and display the count on your WordPress page? While there’s probably a plugin for this, we have created a quick code snippet that you can use to display the total number of comments in WordPress.

Instructions:

All you have to do is add this code to your theme’s single.php file or where you want to show the total number of comments:

<?php 
$numcomms = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->comments WHERE comment_approved = '1'"); 
if (0 < $numcomms) {
	$numcomms = number_format($numcomms); 
	echo "There's ".$numcomms." total comments on my blog";
}
?>

Note: If this is your first time adding code snippets in WordPress, then please refer to our guide on how to properly add code snippets in WordPress, so you don’t accidentally break your site.

If you liked this code snippet, please consider checking out our other articles on the site like: 24 best WordPress education themes and how to secure your WordPress forms.

Comments  Leave a Reply

  1. Sweet 🙂

Add a Comment

We're glad you have chosen to leave a comment. Please keep in mind that all comments are moderated according to our privacy policy, and all links are nofollow. Do NOT use keywords in the name field. Let's have a personal and meaningful conversation.

WordPress Launch Checklist

The Ultimate WordPress Launch Checklist

We've compiled all the essential checklist items for your next WordPress website launch into one handy ebook.
Yes, Send Me the Free eBook!