这篇文章主要介绍了WordPress查询某年某月文章的SQL语句,需要的朋友可以参考下
利用$wpdb自定义查询可以调用某年下的月份归档, 例如调用2014年月份归档的代码如下所示。
复制代码
代码如下:// Get archive by year
global $wpdb, $wp_locale;
$year = 2014;
$query = "SELECT DISTINCT MONTH(post_date) AS `month` FROM $wpdb->posts WHERE `post_type` = 'post' AND `post_status` = 'publish' AND YEAR(post_date) = $year ORDER BY `month` DESC";
$months = $wpdb->get_results($query);
echo '
global $wpdb, $wp_locale;
$year = 2014;
$query = "SELECT DISTINCT MONTH(post_date) AS `month` FROM $wpdb->posts WHERE `post_type` = 'post' AND `post_status` = 'publish' AND YEAR(post_date) = $year ORDER BY `month` DESC";
$months = $wpdb->get_results($query);
echo '
- ';
- '.sprintf('%d', $year).'';
echo '- ';
- '.$text.' ';
foreach( $months as $month ) {
$text = sprintf(__('%1$s'), $wp_locale->get_month($month->month));
echo '
}
echo '
echo '
输出如下：
复制代码
代码如下:以上就是WordPress查询某年某月文章的SQL语句的详细内容，更多请关注0133技术站其它相关文章！
