您现在的位置是：首页 > 教程 > 帝国CMS教程帝国CMS教程
帝国CMS自定义列表怎么按时间调用
怀蕊2023-05-18 17:55:22帝国CMS教程已有人查阅
导读帝国CMS自定义列表按时间调用，演示代码按8小时、24小时、7天、30天、365天时间调用，大家可以参照代码按实际情况修改3600*72=72小时
8小时内
select count(*) as total from [!db.pre!]ecms_news where unix_timestamp(now())-newstime<3600*720
select * from [!db.pre!]ecms_news where unix_timestamp(now())-newstime<3600*720 order by onclick desc
24小时内
select count(*) as total from [!db.pre!]ecms_news where unix_timestamp(now())-newstime<3600*2400
select * from [!db.pre!]ecms_news where unix_timestamp(now())-newstime<3600*2400 order by onclick desc
7天内
select count(*) as total from [!db.pre!]ecms_news where unix_timestamp(now())-newstime<3600*7*24
select * from [!db.pre!]ecms_news where unix_timestamp(now())-newstime<3600*7*24 order by onclick desc
一个月
select count(*) as total from [!db.pre!]ecms_news where unix_timestamp(now())-newstime<3600*30*24
select * from [!db.pre!]ecms_news where unix_timestamp(now())-newstime<3600*30*24 order by onclick desc
一年
select count(*) as total from [!db.pre!]ecms_news where unix_timestamp(now())-newstime<3600*365*24
select * from [!db.pre!]ecms_news where unix_timestamp(now())-newstime<3600*365*24 order by onclick desc
本文标签：
很赞哦！ ()
下一篇：帝国tag按分类调用的方法
相关文章
随机图文
| 留言与评论 （共有 条评论） |
