帝国cms如何调取一段时间内的搜索词

正文概述管理员 2024-09-02 50

[e:loop={"select searchid,keyboard,result_num,searchtime from [!db.pre!]enewssearch where FROM_UNIXTIME(searchtime)>SUBDATE(NOW(),INTERVAL 26 DAY) order by onclick desc limit 10",10,24,0}]
<a href=" <?=$bqrs[newsurl]?>e/search/result/?searchid=<?=$bqr[searchid]?>" target="_blank"><?=$bqr[keyboard]?></a>(有<?=$bqr[result_num]?>条,<?=date('Y-m-d',$bqr[searchtime])?>）<br>
[/e:loop]

order by onclick desc 就是按搜索次数算的

数据表enewssearch 中的 onclick 为搜索次数