eyoucms常用數量SQL查詢標簽
2022-06-14
調用子欄目文章記錄數
{eyou:channelartlist typeid='總欄目id'}
{eyou:channel type="son"}
{$field.typename}<!-- 這是子欄目名稱 -->
{eyou:assign name="typeid" value="$field.typeid"}
<!-- 獲取欄目id變量 -->
{eyou:sql sql="SELECT count(typeid) AS count FROM ey_archives WHERE typeid= $typeid" cachetime='-1'}
<span>{$field.count}</span>
{/eyou:sql}
{/eyou:channel}
{/eyou:channelartlist}或更簡單的
{eyou:channel typeid='總欄目id'}
{$field.typename}-{$field.typeid|GetTotalArc=###}
{/eyou:channel}
統計搜索結果頁關鍵詞文章數量
位置:lists_search.htm
{eyou:assign name="keywords" value="$eyou.field.keywords"}
<!--通過自定義變量assign獲取關健詞-->
{eyou:sql sql="Select count(*) as AllNum from ey_archives where title like '%$keywords%'" cachetime='-1'}
{$field.AllNum}
<!--返回查詢數量為allNum字段-->
{/eyou:sql}
統計網站會員數量
{eyou:sql sql='SELECT count(users_id) AS count FROM ey_users WHERE is_activation = 1' cachetime='-1'}
{$field.count}
{/eyou:sql}
統計整站文章數量
{eyou:sql sql='Select count(*) as AllNum from ey_archives' cachetime='-1'}
{$field.AllNum}
{/eyou:sql}調用最新文章
相對用arclist列表中的typeid=''來指定,用SQL更方便吧。
{eyou:sql sql='SELECT aid FROM ey_archives order by aid desc limit 5' cachetime='-1'}
{eyou:arcview aid="$field.aid" id="field2"}
<li><a href="{$field2.arcurl}">{$field2.title}</a></li>
{/eyou:arcview}
{/eyou:sql}
詳情頁調用投稿者文章
{eyou:assign name='usersid' value='$eyou.field.users_id'/}
<!-- 獲取投稿者用戶ID -->
{eyou:sql sql='SELECT aid FROM ey_archives WHERE users_id = "$usersid" AND channel = "1"
order by aid desc limit 5' cachetime='-1'}
{eyou:arcview aid="$field.aid" id="field2"}
<li class="height"><a href="{$field2.arcurl}" target="_blank">{$field2.title}</a></li>
{/eyou:arcview}
{/eyou:sql}
<!-- 讀取該用戶ID的最近5篇文章,channel = "1"J是文章模型ID。 -->







