如何在ecshop中实现上一个,下一个的链接地址带上产品名称

修改goods.php文件里的如下代码:

/* 上一个商品下一个商品 */

        $prev_gid = $db->getRow("SELECT goods_id,goods_name FROM " .$ecs->table('goods'). " WHERE cat_id=" . $goods['cat_id'] . " AND goods_id > " . $goods['goods_id'] . " AND is_on_sale = 1 AND is_alone_sale = 1 AND is_delete = 0 LIMIT 1");

        if (!empty($prev_gid))

        {

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

            $smarty->assign('prev_good', $prev_good);//上一个商品

        }

        $next_gid = $db->getone("SELECT max(goods_id) FROM " . $ecs->table('goods') . " WHERE cat_id=".$goods['cat_id']." AND goods_id < ".$goods['goods_id'] . " AND is_on_sale = 1 AND is_alone_sale = 1 AND is_delete = 0");

        if (!empty($next_gid))

        {

            $next_good['goods_name'] = $db -> getOne("select goods_name from ".$ecs->table('goods')." where goods_id =".$next_gid);        

            $next_good['url'] = build_uri('goods', array('gid' => $next_gid),$next_good['goods_name']);

            $smarty->assign('next_good', $next_good);//下一个商品

posted @ 2012-09-06 09:34  longailili  阅读(202)  评论(0)    收藏  举报