ecshop首页调用商品详情或者其他商品内容

1.查询数据库确定商品详情字段goods_desc

2.找到lib_goods.php

在第290行sql查询添加查询字段g.goods_desc

代码如下

//取出所有符合条件的商品数据，并将结果存入对应的推荐类型数组中
        $sql = 'SELECT g.goods_id, g.goods_name, g.goods_name_style, g.market_price, g.shop_price AS org_price, g.promote_price, ' .
                "IFNULL(mp.user_price, g.shop_price * '$_SESSION[discount]') AS shop_price, ".
                "promote_start_date, promote_end_date, g.goods_brief, g.goods_thumb, g.goods_desc, g.goods_img, RAND() AS rnd " .
                '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]' ";

 在第316行找到

$goods[$idx]['brief']        = $row['goods_brief'];

添加如下代码

$goods[$idx]['desc']        = $row['goods_desc'];

 3.在需要调用的首页hot、new或者best等制定位置调用显示代码

{$goods.desc|truncate:200}

 truncate:200是指显示字数

 

4.如果是在首页制定分类下显示商品详情

修改的lib_goods.php代码位置是第404行function get_category_recommend_goods()处

$sql =  'SELECT g.goods_id, g.goods_name, g.goods_name_style, g.market_price, g.shop_price AS org_price, g.promote_price, ' .
                "IFNULL(mp.user_price, g.shop_price * '$_SESSION[discount]') AS shop_price, ".
                'promote_start_date, promote_end_date, g.goods_brief, g.goods_thumb, goods_img, b.brand_name ' .
            'FROM ' . $GLOBALS['ecs']->table('goods') . ' AS g ' .
            'LEFT JOIN ' . $GLOBALS['ecs']->table('brand') . ' AS b ON b.brand_id = g.brand_id ' .
            "LEFT JOIN " . $GLOBALS['ecs']->table('member_price') . " AS mp ".
                    "ON mp.goods_id = g.goods_id AND mp.user_rank = '$_SESSION[user_rank]' ".
            'WHERE g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 ' . $brand_where . $price_where . $ext;

 在477行出添加

$goods[$idx]['desc']        = $row['goods_desc'];

 首页对应位置调用即可

转载于:https://www.cnblogs.com/lonelystarxing/archive/2012/08/11/2631567.html