Sarathlal N

List our most commented posts as popular posts in WordPress

What is your opinion about popular posts widget in Blogs? They have any benefits in user interactions?

The popular posts list have certain values in blogs. Surely this list indicate that we keep a good community around us.

When we list our popular posts, I think new visitors can easily grab the spirits of our blog community because our readers make our popular posts.

In WordPress, we have too many good plugins to make such lists. But as a WordPress developer, I always like to use code snippets for such simple use.

Can we consider number of comments in post as an indication for popularity? If so, now we are going to make a popular posts list by listing most commented posts in our blog.

Just paste the following code anywhere in your theme files or make a new function & call it on theme files. To change the number of displayed posts, simply change the “5″ on line 3 to your desired number.

<h2>Popular Posts</h2>
<ul>
	<?php $result = $wpdb->get_results("SELECT comment_count,ID,post_title FROM $wpdb->posts ORDER BY comment_count DESC LIMIT 0 , 5");
	foreach ($result as $post) {
	setup_postdata($post);
	$postid = $post->ID;
	$title = $post->post_title;
	$commentcount = $post->comment_count;
		if ($commentcount != 0) { ?>

		<li><a href="<?php echo get_permalink($postid); ?>" title="<?php echo $title ?>">
		<?php echo $title ?></a> {<?php echo $commentcount ?>}</li>
	<?php } } ?>

</ul>

This code executes an SQL query to the WordPress database, using the $wpdb object, to get a list of the five posts with the most comments. The results are then wrapped in an unordered HTML list.

Recent Posts

  1. Automating Release Generation with GitHub Actions
  2. WP CLI Commands to Bulk Delete Entries in WordPress Database
  3. Split a Single CSV File into Multiple Files Using the Split Command - Bash
  4. Migrating code repo from BitBucket to GitHub
  5. Streamlining Development - Our Journey with Git, Bitbucket, and Jira

Your Questions / Comments

If you found this article interesting, found errors, or just want to discuss about it, please get in touch.