Wouldn’t it be nice to be able to display the total number of posts published on your WordPress blog? WordPress don’t have a function to do that by default, but happilly this hack is here to help.
Here's the code: We're using the $wpdb object to make a custom query to WordPress database:
$numposts = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->posts WHERE post_status = 'publish'");
if (0 < $numposts) $numposts = number_format($numposts);
Right now, the $numposts variable contains the total number of posts. You now just have to display it where you want:
<?php echo $numposts.' has been published since January 12, 2008'; ?>
Thanks to Perishable Press for this great hack!
If you enjoyed this article, please consider sharing it!
Leave a Comment
- ModThemessave 15% off your purchase […]
- Zidalgo Themessave 20% on your order […]
- WooThemessave 20% on your purchase […]
- Autobloggedsave $40 on multi-site licence […]
- Kreative Themessave 50% on your purchase […]
- Smarter Themesave $5 on your order […]
- Classipress Themesave 20% on your purchase […]
- ReviewAZONsave $15 on your order […]
- Headway Themeget 20% off your licence […]
- Gorilla Themesget 10%off any theme […]
On Twitter : RT @perishable Custom CSS Per Post: I’ve long been a fan of “art directing” posts. That is, to apply unique CSS st... http://bit.ly/aikpqN
Theme & content : Copyright © 2008 - 2010 Jean-Baptiste Jung. Graphic art by GreenBubbles.org.ua, all right reserved.
28 Responses
Excellent recipe! Thanks for sharing this!
Is it possible to display the total number of comments, categorie and tags? And even better: How many posts today?
@Dan: Good idea, I’ll think about it for a new recipe
Can you provide a little more detail for us beginners. Where does each of these blocks of code go?
@Larry: No problem: The first code snippet define a php variable, and the second display the result of this variable.
So, you got to paste both theses codes in your template, where you want “X posts since I launched my blog” to appear.
Let me know if you have trouble.
Hi, just to mention that the first snippet of code isn’t inside a php thingy. It took me a while to notice it and it was driving me nuts to put it in my template. But, also, I’m no programmer. It works for me.
@V for Vancouver: you’re right, experimented programmer will notice instantly but that may be hard for novices. I’m correcting it
Hello
it is possible to limit this query at only one category?
if yes, how to do that?
++
Can be done with native function
http://codex.wordpress.org/Function_Reference/wp_count_posts
@Rarst: I know, but this function was introduced with WP 2.7 I think. Back in october when I wrote this recipe, WP 2.7 wasn’t released
@Jean-Baptiste Jung
Yeah, I know it’s recent. Just think it’s worth to keep recipes updated with easiest way to do something instead of keeping legacy code.
Thanks Rarst for pointing out that with 2.7 comes a function for post counting.
Very nice but you are now counting page and posts.
Better us this.
get_var(“SELECT COUNT(*) FROM $wpdb->posts WHERE post_status = ‘publish’ AND post_type = ‘post’”);
if (0
greetz
Very nice but you are now counting page and posts.
Better us this.
$numposts = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->posts WHERE post_status = 'publish' AND post_type = 'post'");if (0 < $numposts) $numposts = number_format($numposts);
greetz
I think there is a plug in for that?
What if you wanted to exclude a specific category? I’ve tried adding AND post_category != ‘3′ but it didn’t work. Am I supposed to use something else?
Sorry guys but this QS sux. WordPress puts %autosave%, %revision% and page in the same bag so you’ll never get correct result. In spite of the fact that there’s built-in function which does the same job, here’s my version of displaying total num of posts
$numposts = $wpdb->get_var( “SELECT COUNT(*) FROM $wpdb->posts WHERE post_status = ‘publish’ AND post_type = ‘post’ AND post_name NOT LIKE ‘%revision%’ AND post_name NOT LIKE ‘%autosave%’” );
ok. and code from numbers of post publised today ?
Trackbacks: