ECSHOP二次開發(fā)工作之如何給商品增加一個新字段，來錄入一些新的內(nèi)容。

下面我們結(jié)合ecshop后臺“商品編輯”、“商品錄入”來談?wù)勅绾谓oecshop商品增加一個新字段，假設(shè)我們將這個新字段命名為 other_col

1、首先要修改數(shù)據(jù)表結(jié)構(gòu)，給表 ecs_goods 增加新字段：other_col，

       進(jìn)入ECSHOP后臺 》數(shù)據(jù)庫管理 》SQL查詢，輸入下面SQL語句，提交。注意如果你的數(shù)據(jù)表前綴不是ecs_ 請自行修改之

     alter table ecs_goods add column other_col varchar(64);

2、在ecshop后臺的admin emplatesgoods_info.htm中增加以下代碼．

------------------------------------------------------------------------------------------------

            自定義字段

------------------------------------------------------------------------------------------------

3、在admin/goods.php的elseif ($_REQUEST['act'] == 'insert' || $_REQUEST['act'] == 'update')里面增加以下程序

------------------------------------------------------------------------------------------------

     $sql = "INSERT INTO " . $ecs->table('goods') . " (goods_name, goods_name_style, goods_sn, " .

                    "cat_id, brand_id, shop_price, market_price, is_promote, promote_price, " .

                    "promote_start_date, promote_end_date, goods_img, goods_thumb, original_img, keywords, goods_brief, " .

                    "seller_note, goods_weight, goods_number, warn_number, integral, give_integral, is_best, is_new, is_hot, " .

                    "is_on_sale, is_alone_sale, is_shipping, goods_desc, add_time, last_update, goods_type, rank_integral, suppliers_id,other_col)" .

                "VALUES ('$_POST[goods_name]', '$goods_name_style', '$goods_sn', '$catgory_id', " .

                    "'$brand_id', '$shop_price', '$market_price', '$is_promote','$promote_price', ".

                    "'$promote_start_date', '$promote_end_date', '$goods_img', '$goods_thumb', '$original_img', ".

                    "'$_POST[keywords]', '$_POST[goods_brief]', '$_POST[seller_note]', '$goods_weight', '$goods_number',".

                    " '$warn_number', '$_POST[integral]', '$give_integral', '$is_best', '$is_new', '$is_hot', '$is_on_sale', '$is_alone_sale', $is_shipping, ".

                    " '$_POST[goods_desc]', '" . gmtime() . "', '". gmtime() ."', '$goods_type', '$rank_integral', '$suppliers_id','$_POST[other_col]')";

" other_col = '$_POST[other_col]', " .

------------------------------------------------------------------------------------------------

      這樣就完成了在ECSHOP后臺錄入和修改新字段的功能了。

      下面再來說一下前臺調(diào)用的方法：

      直接在模板文件或者  lbi文件里 這么調(diào)用即可 {$goods.other_col}

掃描二維碼手機(jī)查看該文章