If you want the total count of all the published posts in a particular category you can try this.
$all_posts = new WP_Query( array( 'posts_per_page' => -1, 'post_status' => 'publish', 'cat' => 3 ) );
echo $all_posts->post_count;
or
$all_posts = new WP_Query( array( 'posts_per_page' => -1, 'post_status' => 'publish', 'category_name' => 'uncategorized' ) );
echo $all_posts->post_count;
Just make sure to replace the ‘category_name’ or ‘cat’ with desired category.
Related Posts:
- When should you use WP_Query vs query_posts() vs get_posts()?
- Wp get all the sub pages of the parent using wp query
- Return only Count from a wp_query request?
- How to query for most viewed posts and show top 5
- WP_Query vs get_posts
- Query Custom Meta Value with Increment
- Get posts by meta data OR title
- Perform query with meta_value date
- WP_Query ordered by custom field that is a date string?
- How to make an activities stream mixing posts and comments?
- Pass the same object to multiple widgets in a template with one query
- Retrieve or Query Pages by ID
- How do you query wordpress posts using a math formula between multiple meta field values?
- How to implement time filter to show random post 1 month for one category and 3 months for other categories
- Page navigation doesn’t show when query category
- How To Get Some Data From WordPress Database Using WordPress $wpdb Query?
- How to correctly pass values to wpdb->prepare()?
- How to query a custom post type with a taxonomy filter but display post type archive page?
- Change query_posts to WP_Query in page but does not work
- Iterating through $wpdb query without using get_results for large query results
- Slow page loads due to WordPress Core Query
- Query Page Content From Theme Options?
- How can I override one post and make it display content for another post?
- Include current post into loop
- WordPress query posts with multiple post_meta data
- Filter post query to only show direct children of category
- Should I reset $wp_query?
- Why doesn’t my WP Meta Query return any results?
- Disable (or limit) queries when certain content (or data) is not needed (or showed)
- Filter products on category AND tag
- Any way to use FETCH_KEY_PAIR with $wpdb?
- pre_user_query vs pre_get_posts
- Get posts that match defined arrays of tags
- Doing $wpdb->get_results returns NULL, doing the same query in my DB returns correct value
- I need query_posts() to order results first by a meta value and then by post ID
- How to show post title in content editor in backend?
- My entry results are not consistently alphabetized
- Merge two queries and remove duplicate
- wpdb get_results() returns only 2 rows
- Ordering Posts by parent category, name ascending
- Optimising specific Query with ACF meta objects
- How to organize a WP_Query’s list of posts by category and display category title?
- When should you use WP_Query vs query_posts() vs get_posts()?
- How to query post ids liked by the Author
- WordPress Query showing multiple titles
- Query Posts by date range with fixed beginning and end
- custom query to get posts
- How much does $wpdb->prepare(), then $wpdb->query() VS straight $wpdb->query(), can slow down the load time of whole page
- how to use transient method?
- Modify WordPress Search
- When to use WP_query(), query_posts() and pre_get_posts
- Get post ids from WP_Query?
- How to print the excuted sql right after its execution
- Nested meta_query with multiple relation keys
- order by numeric value for meta value
- Some doubts about how the main query and the custom query works in this custom theme?
- Pagination with custom SQL query
- WP Query where title begins with a specific letter
- WP_Comment_Query pagination, delving into the unknown
- Usage of the new “posts_clauses” filter in WordPress 3.1?
- Make a WP Query search match exactly the search term
- Using OR conditions in meta_query for query_posts argument
- WP_Query: query posts by ids from array?
- Changing the meta_query of the main query based on custom query_vars and using pre_get_posts
- Query Posts in a Predefined Order
- Sort posts by category name and title
- how does $wpdb differ to WP_Query?
- Order posts by ID in the given order
- How to uniquely identify queries?
- What is the most efficient way of querying posts based on visits and date for current day?
- Custom WP_Query order by post_meta and (author) user_meta
- Query WooCommerce orders where meta data does not exist
- Query Multiple Post types each with own meta query
- WP_Query for WooCommerce Products
- pre_get_posts with get_posts
- Is it true $wpdb->get_results is faster than WP_Query in most cases?
- Get posts by menu ID
- Get the number of posts from the current page results
- WordPress Custom Query to show posts from last x years
- Query causing load because of SQL_CALC_FOUND_ROWS post counting?
- author.php with ACF and CPTs
- Export wordpress table to excel
- Problem with ‘post__not_in’
- When should you use wp_reset_postdata vs wp_reset_query?
- How to know which one is the main query?
- Use WP_Query with a custom SQL query
- Identify which loop you are hooking into; primary or secondary?
- Using is_main_query to select custom post type on certain page
- get query’s query string
- Meta Query with date and time on the same Day before given time
- get_the_title($postID) OR get_the_title()?
- Duplicate Queries
- How to query for a week using key => value WP_Query argument notation?
- Display Posts by modifying the where clause only for my query
- Finding all results from database within 500 miles of the given latitude and longitude [closed]
- Show only oldest post by author
- Order posts by tags count?
- How can I connect to another WP database and use WP_Query?
- SQL query equivalent to WP User Query
- How do I create my own nested meta_query using posts_where / posts_join?