count_many_users_posts() – Function | Developer.WordPress.org

Gets the number of posts written by a list of users.

Parameters

$usersint[]required: Array of user IDs.
$post_typestring|string[]optional: Single post type or array of post types to check. Defaults to 'post'.
Default:'post'
$public_onlybooloptional: Only return counts for public posts. Defaults to false.
Default:false

Return

string[] Amount of posts each user has written, as strings, keyed by user ID.

Source

function count_many_users_posts( $users, $post_type = 'post', $public_only = false ) {
	global $wpdb;

	$count = array();
	if ( empty( $users ) || ! is_array( $users ) ) {
		return $count;
	}

	$userlist = implode( ',', array_map( 'absint', $users ) );
	$where    = get_posts_by_author_sql( $post_type, true, null, $public_only );

	$result = $wpdb->get_results( "SELECT post_author, COUNT(*) FROM $wpdb->posts $where AND post_author IN ($userlist) GROUP BY post_author", ARRAY_N );
	foreach ( $result as $row ) {
		$count[ $row[0] ] = $row[1];
	}

	foreach ( $users as $id ) {
		if ( ! isset( $count[ $id ] ) ) {
			$count[ $id ] = 0;
		}
	}

	return $count;
}

View all references View on Trac View on GitHub

Uses	Description
get_posts_by_author_sql()`wp-includes/post.php`	Retrieves the post SQL based on capability, author, and type.
wpdb::get_results()`wp-includes/class-wpdb.php`	Retrieves an entire SQL result set from the database (i.e., many rows).

Used by	Description
WP_Users_List_Table::display_rows()`wp-admin/includes/class-wp-users-list-table.php`	Generates the list table rows.

Changelog

Version	Description
3.0.0	Introduced.

User Contributed Notes

Skip to note 2 content

Codex 9 years ago

You must log in to vote on the helpfulness of this noteVote results for this note: 0You must log in to vote on the helpfulness of this note
Returns the post counts for a list of user IDs.
```
$users = array( 1, 3, 9, 10 );
$counts = count_many_users_posts( $users );
echo 'Posts made by user 3: ' . $counts[3];
```
Output:
```
Posts made by user 3: 143
```
Log in to add feedback

count_many_users_posts( int[] $users, string|string[] $post_type = ‘post’, bool $public_only = false ): string[]

In this article

Parameters

Return

Source

Changelog

User Contributed Notes

count_many_users_posts( int[] $users, string|string[] $post_type = ‘post’, bool $public_only = false ): string[]

In this article

Parameters

Return

Source

Related

Changelog

User Contributed Notes