{"id":6454,"date":"2016-02-02T19:58:35","date_gmt":"2016-02-03T00:58:35","guid":{"rendered":"https:\/\/themespress.ca\/?p=6454"},"modified":"2022-09-21T17:41:23","modified_gmt":"2022-09-21T21:41:23","slug":"display-the-total-number-of-products","status":"publish","type":"post","link":"https:\/\/themespress.ca\/en\/display-the-total-number-of-products\/","title":{"rendered":"Display the total number of Products"},"content":{"rendered":"
\n\t
\n\t\t
\n\t\t\t

You have created a Post Meta or Post Type called Products and now want to display the number of products with Count Post Meta or Count Post type\u2026<\/p>\n\n\t\t<\/div>\n\t<\/div>\n

Displaying the Count Post meta or Post type<\/h2>\n\t
\n\t\t
\n\t\t\t

First we have to look at the Post Meta. Let’s say your meta key is called votes. Add it wherever you want to display the vote count.<\/p>\n\n\t\t<\/div>\n\t<\/div>\n

<?php \n\/\/ On définit le Meta Key a utiliser. \n$meta_key = 'votes'; \n\/\/ On questionne la Base de données et on fait le Compte et on le place dans une variable. \n$votescount = $wpdb->get_var( $wpdb->prepare(\n"SELECT sum(meta_value) FROM $wpdb->postmeta WHERE meta_key = %s",\n$meta_key));\necho "<span class='votescounts'>{$votescount}<\/span>";\n?><\/pre><\/div>\n\t
\n\t\t
\n\t\t\t
Now we can use a hook that will display the exact number of your Products post type. Here’s the function to use in your functions.php file:<\/p>\n\n\t\t<\/div>\n\t<\/div>\n
function theme_count_products() {\n\t$products = new WP_Query(array( 'post_type' => 'products' ));\n\tif ($products->have_posts()) {\n\t$count_posts = wp_count_posts('products')->publish;\n\tif ( $count_posts == "$count_posts" ) {\n\techo "<span class='count-products'>$count_posts<\/span>"; }\n \n\t}\n}<\/pre><\/div>\n\t
\n\t\t
\n\t\t\t
You can use it in the template of your choice.<\/p>\n\n\t\t<\/div>\n\t<\/div>\n
<?php echo theme_count_products(); ?><\/pre><\/div>\n\t
\n\t\t
\n\t\t\t
WP Count Post<\/a><\/p>\n\n\t\t<\/div>\n\t<\/div>\n<\/div><\/div><\/div><\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"You have created a Post Meta or Post Type called Products and now want to display the number of products with Count Post Meta or Count Post type\u2026 Displaying the
Read More<\/a><\/div>","protected":false},"author":81,"featured_media":4477,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[283],"tags":[],"class_list":["post-6454","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorials"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/posts\/6454","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/users\/81"}],"replies":[{"embeddable":true,"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/comments?post=6454"}],"version-history":[{"count":0,"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/posts\/6454\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/media\/4477"}],"wp:attachment":[{"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/media?parent=6454"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/categories?post=6454"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/themespress.ca\/en\/wp-json\/wp\/v2\/tags?post=6454"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}