關于ecshop獲取點擊人氣排行榜，具體如下：

兩部分。index.php和lib_goods.php

關于涉及到index.dwt的，請將按銷量排行的改為from = top_hots_all

index.php增加

$smarty->assign('top_hots_all', get_top10_hot(0)); // 全部人氣排行

/**

lib_goods.php lib庫增加函數（children取得子類產品id）

* 調用當前人氣排行榜

*按點擊排列 i<10 顯示10個

* @access public

* @param string $cats 查詢的分類

* @return array

*/

function get_top10_hot($cats)

{

if (empty($cats))

{

$children = '';

}

else

{

$children = "WHERE ".get_children($cats);

}

$sql = 'SELECT * ' .

' FROM ' . $GLOBALS['ecs']->table('goods') .' g '.

" $children" .

' ORDER BY click_count DESC LIMIT 0 , 10';

$hot = $GLOBALS['db']->getALL($sql);

for ($i = 0; $i < 10; $i++)

{

$hot[$i]['short_name'] = $GLOBALS['_CFG']['goods_name_length'] > 0 ?

sub_str($hot[$i]['goods_name'], $GLOBALS['_CFG']['goods_name_length']) : $hot[$i]['goods_name'];/*$hot[$i]['goods_name'];*/

$hot[$i]['url'] = build_uri('goods', array('gid' => $hot[$i]['goods_id']), $hot[$i]['goods_name']);

$hot[$i]['name'] = $hot[$i]['goods_name'];

}

return $hot;

}

以上就是本文章全部內容，希望對大家有所幫助。