<?PHP//Select Member_name user_name,member_mobile mobile_phone,member_email email,member_passwd old_psd from Shopjl_ member//adding branding to merchantsHeader("content-type:text/html; Charset=utf-8 ");$con=mysql_connect("localhost", "root", "root");mysql_query("SET NAMES ' UTF8 '");mysql_select_db("XXX",$con);$result=mysql_query("Select A.goods_name,a.goods_price,a.store_id,a.goods_body,a.member_id,a.goods_image,a.gc_name,dsc_merchants _shop_information.user_idfrom (select shopjl_goods.goods_name,shopjl_goods.goods_price,shopjl_goods.store_id, Shopjl_goods_common.goods_body,shopjl_store.member_id,shopjl_goods.goods_image,shopjl_goods_common.gc_name from Shopjl_goods left join Shopjl_goods_common on shopjl_goods.goods_commonid = Shopjl_goods_common.goods_commonid lef T join Shopjl_store on shopjl_goods.store_id = shopjl_store.store_id) A LEFT join dsc_merchants_shop_information on A.S tore_id = Dsc_merchants_shop_information.fleam_sid"); while($row=Mysql_fetch_array($result)) { $row[' goods_img_url '] = ' http://www.gnb360.com/data/upload/shop/store/goods/'.$row[' store_id ']. ' /‘.$row[' Goods_image '].; $data[] =$row; } /*echo "<pre>"; Print_r ($data); */ foreach($data as $key=$value){ mysql_query("INSERT into ' gannongbaoss '. ' Dsc_goods ' (Goods_name, Goods_name_style, GOODS_SN, Bar_code, cat_id, User_cat, 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, Goods_shipai, user_id, Model_price, Model_inventory, Model_attr, Review_status, Group_number, Store_new, Store_hot, Store_best, Goods_product_tag, Is_xiangou, Xiangou_num, Xiangou_start_date, Xiangou_end_date, Largest_amount, Pinyin_keyword,stages,stages_rate,g_class) VALUES (' ".$value[' Goods_name ']. "', ' + ', ', ', ', ' 1489 ', ' 0 ', ' 2330 ', '".$value[' Goods_price ']. "', '".$value[' Goods_price ']. "', ' 0 ', ' 0 ', ' 0 ', ' 0 ', '".$value[' Goods_img_url ']. "', '".$value[' Goods_img_url ']. "', ', ', ', ', ', ' 0 ', ' + ', ' 1 ', ' 0 ', ' 0 ', ' 0 ', ' 0 ', ' 0 ', ' 1 ', ' 1 ', 0, '".$value[' Goods_body ']. "' , ' 1480609138 ', ' 1480609138 ', ' 0 ', ' 0 ', ' 0 ', ', '".$value[' user_id ']. "', ' 0 ', ' 0 ', ' 0 ', ' 1 ', ' 0 ', ' 0 ', ' 0 ', ' 0 ', ', ' 0 ', ' 0 ', ' 0 ', ' 0 ', ' 0 ', ' shangpinmingcheng ', ', ', '".$value[' Gc_name ']. "); }?>
SHOPNC import Commodity to big business create