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}