dedecms自动获取更新了多少篇文章
废话不多说, 直接上代码
今日更新:
{dede:SQL SQL="SELECT count(ID) AS c FROM dede_archives WHERE pubdate > UNIX_TIMESTAMP(CURDATE())"}更新: [field:c/]篇文章{/dede:SQL}
一周更新:
{dede:SQL SQL="SELECT count(ID) AS c FROM dede_archives WHERE pubdate > UNIX_TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 1 WEEK))"}更新: [field:c/]篇文章{/dede:SQL}
一月更新:
{dede:SQL SQL="SELECT count(ID) AS c FROM dede_archives WHERE pubdate > UNIX_TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 1 MONTH))"}更新: [field:c/]篇文章{/dede:SQL}
一年更新:
{dede:SQL SQL="SELECT count(ID) AS c FROM dede_archives WHERE pubdate > UNIX_TIMESTAMP(DATE_SUB(CURDATE(), INTERVAL 1 YEAR))"}更新: [field:c/]篇文章{/dede:SQL}
转载请注明来源: dedecms获取今日更新多少篇文章 - 朱凯博客
支付宝
微信