Community Learn Tools Library Leisure

English

Home > Backend Development > PHP Tutorial > SQL statement for PHP articles to be archived by date (month and day)

SQL statement for PHP articles to be archived by date (month and day)

WBOY

Release： 2016-07-25 09:03:51

Original

1142 people have browsed it

select FROM_UNIXTIME(pubtime, '%Y-%m') as pubtime, count(*) as cnt from articles group by FROM_UNIXTIME(pubtime, '%Y-%m')

Copy code

PHP articles archived by date (day) SQL

select FROM_UNIXTIME(pubtime, '%Y-%m-%d') as pubtime, count(*) as cnt from articles group by FROM_UNIXTIME(pubtime, '%Y-%m-%d')

Copy code

Non-timestamp date format archive (date_format formatted date)

select date_format(`post_date`,'%Y%m%d') as pubtime, count(*) as cnt from wp_posts where `post_status`='publish' group by date_format( `post_date`,'%Y%m%d') order by `ID` desc
select date_format(`post_date`,'%Y%m%d') as pubtime,date_format(` post_date`,'%m month %d day') as shijian,count(*) as cnt from wp_posts where `post_status`='publish' group by date_format(`post_date`,'%Y%m%d') order by `ID` desc limit 0,7

Copy code

Related labels：

PHP文章按日期(月日)归档的sql语句

source：php.cn

Previous article：Four ways to get the client IP address in php Next article：Solutions to Chinese garbled characters in PHP

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn