我正试图调查博客上发布的帖子总数与收到的流量之间的相关性。我认为这不是一项艰巨的任务，但我使用Wordpress进行编码的经验几乎为零。
我想它应该像foreach一样，循环所有帖子并列出每个帖子的发布日期。然后按发布日期对其进行排序，然后统计已发布帖子的数量。
我的问题清楚吗？
我如何才能获得按日期发布的帖子数量的表格？
3 个回复
SO网友:jjarolim
imho最快的方法是创建自定义sql语句：
global $wpdb;
$rows = $wpdb->query(\'SELECT DATE(post_date) AS date, COUNT(*) AS count FROM \' . $wpdb->posts . \' GROUP BY DATE(post_date) ORDER BY DATE(post_date)\');
foreach ($rows as $row) {
echo $row->date . \': \' . $row->count . \'<br>\';
}
SO网友:Tom J Nowell
您将要使用WP_Query, along with the data parameters
e、 g.年份：
$years = array( 2015,2014,2013,2012 );
echo \'<table>\';
foreach ( $years as $year ) {
$q = new WP_Query( array(
\'year\' => $year,
\'fields\' => \'ids\'
) );
echo \'<tr><td>\'.$year.\'</td><td>\'. $q->found_posts.\'</td></tr>\';
}
echo \'</table>\';
SO网友:Revious
这个答案将整合jjarolim的答案
正确的整个查询是
SELECT DATE(post_date) AS date, concat(post_title) titles, COUNT(*) AS count
FROM wp_posts
WHERE post_status = \'publish\'
AND post_parent = 0
AND post_type = \'post\'
GROUP BY DATE(post_date)
ORDER BY DATE(post_date)
结束