Shulou(Shulou.com)06/02 Report--

I would like to share with you the method of displaying the top 100 commentators according to the number of comments. I believe most people don't know much about it, so share this article for your reference. I hope you will learn a lot after reading this article. Let's take a look at it!

If you want to see which blogger on your blog has the most comments and the last comment time, the following code will help you achieve this function.

You can add the following code to the current theme functions.php:

Function top_comment_authors ($amount = 100) {global $wpdb; $prepared_statement = $wpdb- > prepare ('SELECT COUNT (comment_author) AS comments_count, comment_author, comment_author_url, MAX (comment_date) as last_commented_date FROM'. $wpdb- > comments.' WHERE comment_author! = "" AND comment_type = "" AND comment_approved = 1 GROUP BY comment_author ORDER BY comments_count DESC, comment_author ASC LIMIT% dwells, $amount); $results = $wpdb- > get_results ($prepared_statement); $output =''; foreach ($results as $result) {$output. ='. $result- > comment_author.' Total'. $result- > comments_count.' Human_time_diff (strtotime ($result- > last_commented_date)). Before';} $output. ='; echo $output;}

Call code:

Add the code to the WordPress theme template in place, where the number 100 controls the number displayed.

The above is all the content of the method of showing the top 100 commentators by the number of comments. Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.