您当前的位置:首页 > 网站建设笔记 >

ecshop商品详细页的上一个商品下一个商品修正并输出商品名称

0
<?php
//在根目录的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 ORDER BY goods_id DESC LIMIT 1");
if(!empty($prev_gid))
{
    $prev_good["url"]=build_uri("goods", array("gid"=>$prev_gid["goods_id"]), $goods["goods_name"]);
    $prev_good["goods_name"]=$prev_gid["goods_name"];
    $smarty->assign("prev_good", $prev_good);
}
$next_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 ORDER BY goods_id ASC LIMIT 1"); 
if(!empty($next_gid))
{
    $next_good["url"]=build_uri("goods", array("gid"=>$next_gid["goods_id"]), $goods["goods_name"]);
    $next_good["goods_name"]=$next_gid["goods_name"];
    $smarty->assign("next_good", $next_good);
}

//在模板文件里的代码如下
{if $prev_good}
<a href="{$prev_good.url}">{$prev_good.goods_name}</a>
{/if}
{if $next_good}
<a href="{$next_good.url}">{$next_good.goods_name}</a>
{/if}
?>

建站咨询

在线咨询真诚为您提供专业解答服务

咨询热线

137 1731 25507×24小时服务热线

微信交流

二维码终于等到你,还好我没放弃
返回顶部