帝国cms灵动标签调用指定某个时间段的信息(帝国cms灵动标签调用指定某个时间段的信息是什么)
主要是对这篇文章的补充https://www.moyublog.com/notes/317.html
1、某天发表的文章[e:loop={'news',10,18,0,'newstime='.to_time('2010-11-11 00:00:01').' and newstime='.to_time('2010-11 -11 23:59:59').''}]a href='?=$bqsr[titleurl]?' target='_blank'?=$bqr[title]?/a?=date('Y-m-d H:i:s',$bqr[ newstime])?br[/e:loop]
或(将to_time 替换为to_date)
[e:loop={'新闻',10,18,0,'新闻时间='.to_date('2016-07-31 00:00:01').'和newstime='.to_date('2016-08-31 23:59:59').' '}]a href='?=$bqsr[titleurl]?' target='_blank'?=$bqr[title]?/a?=date('Y-m-d H:i:s',$bqr[newstime])?br[/e:loop]
2、某段时间发表的文章[e:loop={'news',10,18,0,'newstime='.to_time('2016-07-31 00:00:01').' and newstime='.to_time('2016-08-31 23:59:59').''}]a href='?=$bqsr[titleurl]?' target='_blank'?=$bqr[标题]?/a?=date('Y-m-d H:i:s',$bqr [新闻时间])?br[/e:loop]
或者
!--[e:loop={'select * from [!db.pre!]ecms_news where newstime UNIX_TIMESTAMP('2016-06-01') and newstime UNIX_TIMESTAMP('2016-08-23') order by id desc limit 30' ,30,24,0}] --lia href='?=$bqsr[titleurl]?' target='_blank'?=DoTitleFont($bqr[titlefont],esub($bqr[title],28))? /a?=date('Y-m-d H:i:s',$bqr[newstime])?/li!--[/e:loop]--