帝国CMS灵动标签调用指定时间段的信息
帝国CMS灵动标签怎么调用指定时间段的信息呢?1、某天发布的文章:[e:loop={&#39;news&#39;,10,18,0,&#39;newstime>=&#39;.to_time(&#39;2010-11-1100:00:01&#39;).&#39;andnewstime<=&#39;.to_time(&#39;2010-11-1123:5……
1、某天发布的文章:
[e:loop={'news',10,18,0,'newstime>='.to_time('2010-11-1100:00:01').'andnewstime<='.to_time('2010-11-1123:59:59').''}]<ahref="<?=$bqsr[titleurl]?>"target="_blank"><?=$bqr[title]?></a><?=date("Y-m-dH:i:s",$bqr[newstime])?><br>[/e:loop]
或 (to_time 换成 to_date):
[e:loop={'news',10,18,0,'newstime>='.to_date('2016-07-3100:00:01').'andnewstime<='.to_date('2016-08-3123:59:59').''}]<ahref="<?=$bqsr[titleurl]?>"target="_blank"><?=$bqr[title]?></a><?=date("Y-m-dH:i:s",$bqr[newstime])?><br>[/e:loop]
2、某一段时间发布的文章
[e:loop={'news',10,18,0,'newstime>='.to_time('2016-07-3100:00:01').'andnewstime<='.to_time('2016-08-3123:59:59').''}]<ahref="<?=$bqsr[titleurl]?>"target="_blank"><?=$bqr[title]?></a><?=date("Y-m-dH:i:s",$bqr[newstime])?><br>[/e:loop]
或者:
<!--[e:loop={"select*from[!db.pre!]ecms_newswherenewstime>UNIX_TIMESTAMP('2016-06-01')andnewstime<UNIX_TIMESTAMP('2016-08-23')orderbyiddesclimit30",30,24,0}]--><li><ahref="<?=$bqsr[titleurl]?>"target="_blank"><?=DoTitleFont($bqr[titlefont],esub($bqr[title],28))?></a><?=date("Y-m-dH:i:s",$bqr[newstime])?></li><!--[/e:loop]-->
好了,以上这个问题就搞定了!
标签指定时间