![\"WordPress](\"http:\/\/www.bin-co.com\/blog\/wp-content\/uploads\/2009\/03\/halo_wordpress.jpg\" "\\"WordPress")
<\/p>\n<\/p>\n
A list of the popular posts<\/strong> of the blog is a standard feature in many blogs. There are quite a few plugins that offer this feature…<\/p>\n Now, lets see how to do it without using a plugin. In case you are new to this blog, I am currently working on the Plugin Killer Series<\/a> – a series of post in which I explain how to duplicate the functionality provided by some wordpress plugins – without having to install the plugin.<\/p>\n These plugins work by adding a view counter for each post<\/strong> – whenever a user visits a page, it will increment the count for that page by one. Unfortunately, WordPress does not provide this feature. But there is another indicator for the popularity of a post – its comment count<\/strong>.<\/p>\n So the first step is to get the list of post with the most comments. To get that, we can use the following SQL statement…<\/p>\n This query will return just 10 posts. If you want more(or less) post, just change the number after LIMIT accordingly. The PHP code for executing the query and getting its result is…<\/p>\n Next step is to get the URL of each post. The recommended way of doing this is by using the ‘get_permalink<\/a>‘ function. Another thing we have to do is to map the result as an HTML list…<\/p>\n Note: The HTML part of the code may need to be changed – depending on your theme.<\/p>\n Add this code to the A list of the popular posts of the blog is a standard feature in many blogs. There are quite a few plugins that offer this feature. In case you are new to this blog, I am currently working on the Plugin Killer Series<\/a> – a series of post in which I explain how to duplicate the functionality provided by some wordpress plugins – without having to install the plugin.<\/p>\n<\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,21,25,28,31],"tags":[212,213,218,251,283,304,307],"class_list":["post-240","post","type-post","status-publish","format-standard","hentry","category-blogging","category-php","category-scripts","category-tutorial","category-wordpress","tag-plugin","tag-plugin-killer","tag-popular","tag-series","tag-top","tag-wordpress","tag-wp"],"_links":{"self":[{"href":"https:\/\/www.bin-co.com\/blog\/wp-json\/wp\/v2\/posts\/240","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bin-co.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bin-co.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bin-co.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bin-co.com\/blog\/wp-json\/wp\/v2\/comments?post=240"}],"version-history":[{"count":0,"href":"https:\/\/www.bin-co.com\/blog\/wp-json\/wp\/v2\/posts\/240\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.bin-co.com\/blog\/wp-json\/wp\/v2\/media?parent=240"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bin-co.com\/blog\/wp-json\/wp\/v2\/categories?post=240"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bin-co.com\/blog\/wp-json\/wp\/v2\/tags?post=240"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}\n
The Code<\/h2>\n
Getting Comment Count – SQL<\/h3>\n
SELECT id,post_title FROM wp_posts ORDER BY comment_count DESC LIMIT 0,10<\/code><\/pre>\nListing The Data – PHP\/SQL<\/h3>\n
$popular_posts = $wpdb->get_results(\"SELECT id,post_title FROM {$wpdb->prefix}posts ORDER BY comment_count DESC LIMIT 0,10\");\nforeach($popular_posts as $post) {\n\t\/\/ Do something with the $post variable\n}\n<\/code><\/pre>\nFinal Output as Links in a List – HTML\/PHP\/SQL<\/h3>\n
<li><h3>Popular Posts<\/h3>\n<ul class=\"bullets\">\n<?php \n$popular_posts = $wpdb->get_results(\"SELECT id,post_title FROM {$wpdb->prefix}posts ORDER BY comment_count DESC LIMIT 0,10\");\nforeach($popular_posts as $post) {\n\tprint \"<li><a href='\". get_permalink($post->id) .\"'>\".$post->post_title.\"<\/a><\/li>\\n\";\n}\n?>\n<\/ul>\n<\/li><\/code><\/pre>\nsidebar.php<\/code> file in your theme – and you are done!<\/p>\n","protected":false},"excerpt":{"rendered":"