ecshop 在商品类表页添加类似于精品自定义字段.docVIP

目前在做自己的博客 HYPERLINK / 爱T-blog web开发、分享 与爱T们技术交流 在商品列表页添加自定义字段( HYPERLINK / 爱T-blog) 1、首先要修改数据表结构，给表 ecs_goods 增加新字段：other_col，进入ECSHOP后台 》数据库管理 》SQL查询，输入下面SQL语句，提交。注意如果你的数据表前缀不是ecs_ 请自行修改之alter table ecs_goods add column other_col varchar(64);2. 打开admin/goods.php在/* 处理商品数据 */那里 $is_hot = isset($_POST[is_hot]) ? 1 : 0;（大约803行）$other_col = isset($_POST[other_col]) ? 1 : 0; 在 /* 入库 */添加 /* 入库 */if ($is_insert){if ($code == ”){$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, other_col,” .“is_on_sale, is_alone_sale, is_shipping, goods_desc, add_time, last_update, goods_type, rank_integral, suppliers_id)” .“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’,$other_col’, ‘$is_on_sale’, ‘$is_alone_sale’, $is_shipping, “.” ‘$_POST[goods_desc]‘, ‘” . gmtime() . “‘, ‘”. gmtime() .”‘, ‘$goods_type’, ‘$rank_integral’, ‘$suppliers_id’)”;}else{$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, other_col,is_real, ” .“is_on_sale,