update_posts_count() │ WP 3.0.0

Updates a blog's post count.

WordPress MS stores a blog's post count as an option so as to avoid extraneous COUNTs when a blog's details are fetched with get_site(). This function is called when posts are published or unpublished to make sure the count stays current.

No Hooks.

Return

null. Nothing (null).

Usage

update_posts_count( $deprecated );

$deprecated(string)

Not used.
Default: ''

Notes

• Global. wpdb. $wpdb WordPress database abstraction object.

Changelog

update_posts_count() update posts count code ^{WP 6.5.2}

function update_posts_count( $deprecated = '' ) {
	global $wpdb;
	update_option( 'post_count', (int) $wpdb->get_var( "SELECT COUNT(ID) FROM {$wpdb->posts} WHERE post_status = 'publish' and post_type = 'post'" ) );
}