How to display number of posts for a given time frame in wordpress

Question

Hello guys,

I was hoping to get some ideas as how I can get a number of posts that have been posted on our blog BUT within a certain date range. I know how to get total number but need this extra functionality.

This is what I have for getting total number of posts:

$numposts = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->posts WHERE post_status = 'publish'");
if (0 < $numposts) $numposts = number_format($numposts);

Then I just echo out where ever I want to display that number

<?php if ( is_page('wordpress-numbers')) {
echo "<strong>".$numposts.' posts have been published since August 12, 2009'."</strong>";
}
?>

For example I want to know the number of posts in the last 7 days. Maybe use a datepicker of sorts?

Thanks,

Matt

Answer 1

Sure, you could do it by setting a date range in a custom query:

$today = date("Y-m-d");
$sevenDaysAgo = date("Y-m-d", mktime(0, 0, 0, date("m")  , date("d")-7, date("Y")));

$querystr = "
    SELECT wposts.*
    FROM $wpdb->posts wposts,
    WHERE wposts.post_date BETWEEN '" . $today . "' AND '" . $sevenDaysAgo . '" 
    AND wposts.post_type = 'post'
    ORDER BY wposts.post_date DESC
";

Answer 2

Okay thanks to Pat he got me thinking here and I came up with this:

$querystr = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->posts WHERE post_status = 'publish' AND post_type = 'post' AND post_date >= DATE_SUB(CURRENT_DATE, INTERVAL 7 DAY) LIMIT 0, 30");
if (0 < $querystr) $querystr = number_format($querystr);

Then I will just echo out the result:

echo "<strong>".$querystr.' posts have been published in the last 7 days'."</strong>";

The next thing I would like to do is add the ability to choose the start date then show results for those 7days.

Thanks again Pat