今天小編給大家介紹一篇文章，叫做修改ecshop隨機(jī)顯示產(chǎn)品分類頁面下的產(chǎn)品，分享給大家供大家參考。具體如下：

實(shí)現(xiàn)ecshop分類下隨機(jī)顯示商品，打破后臺(tái)規(guī)定的按照上架時(shí)間，價(jià)格、等先后順序排序，讓很多人上傳

完畢產(chǎn)品，第一頁總是顯示同類商品，如何修改ecshop隨機(jī)顯示產(chǎn)品分類頁面下的產(chǎn)品，A5源碼告訴你方法：

1、下載ecshop并備份你的根目錄下的文件category.php文件

2、找到如下代碼部分，大約在450行：

/* 獲得商品列表 */

$sql = ‘SELECT g.goods_id, g.goods_name, g.goods_name_style, g.market_price, g.is_new, g.is_best, g.is_hot, g.shop_price AS org_price, ‘ .

“IFNULL(mp.user_price, g.shop_price * ‘$_SESSION[discount]‘) AS shop_price, g.promote_price, g.goods_type, ” .

‘g.promote_start_date, g.promote_end_date, g.goods_brief, g.goods_thumb , g.goods_img ‘ .

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

‘LEFT JOIN ‘ . $GLOBALS['ecs']->table(‘member_price’) . ‘ AS mp ‘ .

“ON mp.goods_id = g.goods_id AND mp.user_rank = ‘$_SESSION[user_rank]‘ ” .

“WHERE $where $ext ORDER BY $sort $order”;

替換修改為

$zz=1;

$sql = ‘SELECT g.goods_id, g.goods_name, g.goods_name_style, g.market_price, g.is_new, g.is_best, g.is_hot, g.shop_price AS org_price, ‘ .

“IFNULL(mp.user_price, g.shop_price * ‘$_SESSION[discount]‘) AS shop_price, g.promote_price, g.goods_type, ” .

‘g.promote_start_date, g.promote_end_date, g.goods_brief, g.goods_thumb , g.goods_img ‘ .

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

‘LEFT JOIN ‘ . $GLOBALS['ecs']->table(‘member_price’) . ‘ AS mp ‘ .

“ON mp.goods_id = g.goods_id AND mp.user_rank = ‘$_SESSION[user_rank]‘ ” .

“WHERE $where $ext”;

$sql .= $zz == 0 ? ” $order” : ” ORDER BY RAND()”;

即可實(shí)現(xiàn)ecshop分類下的產(chǎn)品隨機(jī)顯示了，但是前提是，到后臺(tái)清空緩存來實(shí)現(xiàn)，不能每次刷新都隨機(jī)，否

則服務(wù)器會(huì)受不了的，這樣就實(shí)現(xiàn)了和首頁精品、新品、促銷等欄目同樣的功能。

通過ecshop清空緩存來實(shí)現(xiàn)產(chǎn)品的隨機(jī)，隨機(jī)顯示竟然會(huì)占用服務(wù)器過多資源。所以不建議這樣優(yōu)化