How to Get Current User's Post and Comment Count in WordPress

When developing WordPress author pages, retrieving author-related data such as post count and comment count is a common requirement. WordPress provides built-in functions or database queries to obtain this information. This guide explains how to get the current user's post count and comment count.

Get the Current User ID

Before fetching user data, you typically need the user ID. For logged-in users, use one of these methods:

// Method 1: Use WordPress function to get current logged-in user ID
$user_id = get_current_user_id();

// Method 2: Use global variable (ensure it's defined in user context)
global $current_user;
$user_id = $current_user->ID;

Note: get_current_user_id() is the recommended and secure method. It returns the current logged-in user's ID, or 0 if the user is not logged in.

Get User's Post Count

WordPress provides the count_user_posts() function to count posts published by a specific user.

// Count posts for a given user ID (defaults to 'post' type)
$post_count = count_user_posts( $user_id );

// To count a custom post type, pass the second parameter
$custom_post_count = count_user_posts( $user_id, 'your_custom_post_type' );

Explanation: This function counts 'post' type items by default. To count pages or custom post types, specify the post type parameter.

Get User's Comment Count

WordPress doesn't have a built-in function for comment count, but you can query the database using the $wpdb class.

// Query total comments for a specific user
global $wpdb;
$comment_count = $wpdb->get_var(
    $wpdb->prepare(
        "SELECT COUNT(comment_ID) FROM {$wpdb->comments} WHERE user_id = %d",
        $user_id
    )
);
// Output comment count
echo $comment_count;

Important Notes:

1. Query Security: Always use $wpdb->prepare() for parameterized queries to prevent SQL injection.
2. Table Reference: Use {$wpdb->comments} to reference the comments table with the correct prefix.
3. Result Handling: $wpdb->get_var() returns a single value (the count). It returns 0 or NULL if the user has no comments.

Complete Example

Here's an example for an author page template:

// Get current author ID (works on author archive pages)
$author_id = get_the_author_meta( 'ID' );

// Get post count
$author_post_count = count_user_posts( $author_id );

// Get comment count
global $wpdb;
$author_comment_count = $wpdb->get_var(
    $wpdb->prepare(
        "SELECT COUNT(comment_ID) FROM {$wpdb->comments} WHERE user_id = %d",
        $author_id
    )
);

// Output results
echo 'Post Count: ' . $author_post_count . '
';
echo 'Comment Count: ' . $author_comment_count;

Using these methods, you can easily integrate author post and comment data into your theme to enhance author page displays.