hi i want to show author comment count in author page. this code can display current user comment count but i dont want current user i need any user please help me

/* user commnet count */
    function commentCount() {
        global $wpdb, $current_user;
        get_currentuserinfo();
        $userId = $current_user->ID;

        $count = $wpdb->get_var('
                 SELECT COUNT(comment_ID) 
                 FROM ' . $wpdb->comments. ' 
                 WHERE user_id = "' . $userId . '"');
        echo 'Şərh sayı ' . $count ;
    }
      <?php commentCount(); ?>

hi i want to show author comment count in author page. this code can display current user comment count but i dont want current user i need any user please help me

/* user commnet count */
    function commentCount() {
        global $wpdb, $current_user;
        get_currentuserinfo();
        $userId = $current_user->ID;

        $count = $wpdb->get_var('
                 SELECT COUNT(comment_ID) 
                 FROM ' . $wpdb->comments. ' 
                 WHERE user_id = "' . $userId . '"');
        echo 'Şərh sayı ' . $count ;
    }
      <?php commentCount(); ?>

• users
• comments
• author
• count

Share Improve this question asked Feb 19, 2020 at 9:10 Gidromasservis QSCGidromasservis QSC 3311 silver badge1010 bronze badges

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 1

all you have to do is to add an param:

/* user commnet count */
function get_comment_count( $user_ID ) {
    global $wpdb;

    $count = $wpdb->get_var(
        $wpdb->prepare( "SELECT COUNT(comment_ID) FROM {$wpdb->comments} WHERE user_id = %d ", $user_ID )
    );
    return $count;
}
<?php echo get_comment_count( <USER_ID> ); ?>

PS. I've added some proper escaping in your query also, so this code is not vulnerable any more...

But you can also use...

WordPress already has its own way of doing it, so you don't have to reinvent the wheel... You can use:

$count = get_comments( array(
    'user_id' => <USER_ID>, // include only comments by this user
    'count' => true // it will return only count of comments and not the comments
) );
echo $count;