{"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":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t