Need to show CPT count based on custom field WordPress

Arnav Joy answers:

so post will have custom field "start_rating" and its value be 5 for a post whose review is 5? and value will be 4 for a post whose review is 4 .. and so on...?

---

---

---

---

Dbranes answers:

You could try:

$reviews = new WP_Query(
array(
'fields' => 'ids',
'post_status' => 'publish',
'post_type' => 'reviews',
'posts_per_page' => 1,
'meta_query' => array(
array(
'key' => 'star_rating',
'value' => '5',
'compare' => '=',
)
)
)
);

echo $five_stars = $reviews->found_posts;


where the <em>found_posts</em> attribute returns the total number of posts found matching the query arguments.

We don't need to return more than a single post id, to get the <em>found_posts</em> value, so therefore I added <em>posts_per_page = 1</em> and <em>fields = ids</em>.

You can now easily modify this query to your needs.

Kyle answers:

Building on Dbranes solution, you may want to try to making the query into a function since you are using it more than once, by passing the star rating as an argument.

So using his code turned into a function:


function get_cpt_review_count( $stars ){

$reviews = new WP_Query(
array(
'fields' => 'ids',
'post_status' => 'publish',
'post_type' => 'reviews',
'posts_per_page' => 1,
'meta_query' => array(
array(
'key' => 'star_rating',
'value' => $stars,
'compare' => '=',
)
)
)
);

return $reviews->found_posts;

}


Then inside your templates or where you want to show the information you could do this:

echo 'There are '.get_cpt_review_count("5").' reviews with 5 stars';
echo 'There are '.get_cpt_review_count("4").' reviews with 4 stars';
echo 'There are '.get_cpt_review_count("3").' reviews with 3 stars';

---