fromtheold asked: “How to display how many post have been published today?”

One of my readers, fromtheold, asked me how he can display how many post have been published today on his blog, just as the popular blog Lifehacker. Here’s how to do it.

For this recipe, we'll have to mix two recipe I posted here this week. The first one is How to: Display today’s posts and the second is How to: Display the total number of posts on your WordPress blog.

The first thing to do is to get today's date, and then create another variable containing today's date - 24 hours. Then, we just have to send a SQL request to the database by using the $wpdb->get_var() method.

<?php
$today = date("Y-m-d H:i:s"); //Today's date
$daysago = date("Y-m-d H:i:s",strtotime(date('Y-m-j H:i:s')) - (1 * 24 * 60 * 60));  //Today - 1 day

$numposts = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->posts WHERE post_status = 'publish' AND post_date BETWEEN '$daysago' AND '$today'");

if ($numposts >0) {
    echo $numposts.' posts published today';
} else {
    echo "No posts published today";
?>