dedecms怎么获取当前栏目及所有子栏目的文章数量?
以下代码用来解决查询当前栏目及当前栏目下所有子栏目的文章总数,添加到/include/common.func.php
或者/include/extend.func.php中,然后在模板中调用getTotalArcByTid(1)。
推荐学习:织梦cms
代码如下:
functiongetTotalArcByTid($tid,$level=TRUE){global$dsql;$level==TRUE&&$tid=GetSonTypeID($tid);$sql="SELECTcount(id)astotalfrom`dede_archives`wheretypeidin($tid)";$result=$dsql->GetOne($sql);return$result['total'];}functionGetSonTypeID($tid){global$dsql;$dsql->SetQuery("SelectidFrom`dede_arctype`wherereidin($tid)Andishidden<>1orderbysortrank");$dsql->Execute($tid);$typeid='';while($row=$dsql->GetObject($tid)){$typeid.="{$row->id},";$typeid.=GetSonTypeID($row->id);}returntrim($typeid,',');}