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

實現ecshop分類下隨機顯示商品，打破后臺規定的按照上架時間，價格、等先后順序排序，讓很多人上傳

完畢產品，第一頁總是顯示同類商品，如何修改ecshop隨機顯示產品分類頁面下的產品，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()”;

即可實現ecshop分類下的產品隨機顯示了，但是前提是，到后臺清空緩存來實現，不能每次刷新都隨機，否

則服務器會受不了的，這樣就實現了和首頁精品、新品、促銷等欄目同樣的功能。

通過ecshop清空緩存來實現產品的隨機，隨機顯示竟然會占用服務器過多資源。所以不建議這樣優化