phpcms V9 收藏量統(tǒng)計全站排行代碼，可獲取用戶ID，文章title，URL及收藏時間數(shù)據(jù)信息
{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}
鄂公網(wǎng)安備 42090202000212號