phpcms V9 收藏量統計全站排行代碼，可獲取用戶ID，文章title，URL及收藏時間數據信息
{pc:get sql="select *, count(*) as count f rom v9_favorite where adddate >=DATE_SUB (CUR DATE(), INTERVAL WEEKDAY(CURDATE()) DAY) group by title order by count(*) desc" return="data" num="9"}
{loop $data $key $val}
{$val[title]} {$val[count]}
{/loop}
{/pc}
{pc:get sql="select *, count(*) as count f rom v9_favorite where adddate >=DATE_SUB (CUR DATE(), INTERVAL WEEKDAY(CURDATE()) DAY) group by title order by count(*) desc" return="data" num="9"}
{loop $data $key $val}
{$val[title]} {$val[count]}
{/loop}
{/pc}
鄂公網安備 42090202000212號