Dedecms 5.5站点信息调用标签代码

星速云小编 • 2022年8月9日上午9:11 • 织梦建站 • 阅读 7

Dedecms 5.5站点信息调用标签代码，有需要的拿去吧。

{dede:sql sql="SELECT count( * ) AS c FROM dede_archives WHERE pubdate > UNIX_TIMESTAMP( CURDATE( ) ) "}

<li class="count">今日更新：[field:c/] 篇</li>

{/dede:sql}

{dede:sql sql="Select count(ID) as c From dede_archives WHERE FROM_UNIXTIME(pubdate,'%m'😉=month(curdate())"}

<li class="count">当月更新：[field:c/] 篇</li>

{/dede:sql}

{dede:sql sql="select count(*) as c from dede_archives}

<li class="count">共有文章：[field:c/] 篇</li>

{/dede:sql}

{dede:sql sql="select sum(click) as c from dede_archives"}

<li class="count">总共阅读：[field:c/] 人次</li>

{/dede:sql}

{dede:sql sql="select count(mid) as c from dede_member "}

<li class="count">共有会员：[field:c/] 名</li>

{/dede:sql}

　　还可以指定栏目ID，例如：

{dede:sql sql="select count(*) as c from dede_archives where channel in(1,2,3,5,6,9)"}

<li class="count">共有文章：[field:c/] 篇</li>

{/dede:sql}