导数据方法
<?php // 写如sql语句 // 查询所有商品的信息及店铺信息 echo '<meta charset="utf-8">'; include './mysql.php'; /** * 执行简单的插入 * @access public * @parameter goal 目标表 * @parameter rest 来源表 * @parameter goal 来源字段 * import_insert('33hao_goods_class(gc_id,gc_name,gc_parent_id,gc_sort,level)','br_gcategory','cate_id,cate_name,parent_id,sort_order,level'); * @return array */ function import_insert($goal,$rest,$resc,$where=''){ $model = new mysql("localhost","root","root","aumall"); $sql = "INSERT INTO {$goal} SELECT {$resc} FROM {$rest} {$where}"; $result = $model ->query($sql); } // 先插入商品goods_common 后续在插入goods //goods_common没有 spec_name spec_value brand_id brand_name type_id goods_image goods_body goods_attr goods_specname goods_marketprice goods_costprice goods_discount goods_serial goods_storage_alarm transport_id areaid_1 // areaid_2 goods_stcids plateid_top plateid_bottom, $str1 ="33hao_goods_common(goods_name,gc_id,gc_id_1,gc_id_2,gc_id_3,gc_name,store_id,store_name,goods_state,goods_verify,goods_addtime,goods_price,goods_marketprice,goods_body)"; $str11 ="33hao_goods(goods_commonid,goods_name,gc_id,gc_id_1,gc_id_2,gc_id_3,store_id,store_name,goods_state,goods_verify,goods_addtime,goods_price,goods_marketprice,goods_storage)"; $str2 ="goods_name,cate_id,cate_id_1,cate_id_2,cate_id_3,cate_name,store_id,121,1,10,".time().",price,description"; $str22 ="goods_name,cate_id,cate_id_1,cate_id_2,cate_id_3,store_id,121,1,10,".time().",price,100"; $where ="where if_trade =1 and if_show=1 and g.store_id >0 and goods_id>240000";// <=30000 >50000<200000 >=200000 // echo $str2; // import_insert('33hao_brand(brand_id,brand_name,brand_recommend,brand_pic)','br_brand','brand_id,brand_name,recommended,brand_logo','where if_show=1'); // import_insert($str1,'br_goods',$str2,$where); // 查询出所有的goods信息 set_time_limit(0); $sql_goods = "select g.*,br_store.store_name from br_goods g JOIN br_store ON br_store.store_id=g.store_id {$where}"; $model = new mysql("localhost","root","root","aumall"); $result = $model ->query($sql_goods,1); if($result){ foreach ($result as $key => $value) { if(empty($value)){echo '导入结束!';return '121';} // 定义市场价格 $goods_marketprice =$value['price']+100; // 先插入goods_common表 $sql_gcom = "value('{$value['goods_name']}','{$value['cate_id']}','{$value['cate_id_1']}','{$value['cate_id_2']}','{$value['cate_id_3']}','{$value['cate_name']}','{$value['store_id']}','{$value['store_name']}',1,10,".time().",'{$value['price']}','{$goods_marketprice}','{$value['description']}')"; // 插入goods_common $sql_do = "INSERT INTO {$str1} {$sql_gcom}"; $result = $model ->query($sql_do); if(is_int($result) && !empty($result)){ echo $value['goods_name'].':<font color="green">导入商品公共表成功 -- </font>'; $sql_g= "value({$result},'{$value['goods_name']}','{$value['cate_id']}','{$value['cate_id_1']}','{$value['cate_id_2']}','{$value['cate_id_3']}','{$value['store_id']}','{$value['store_name']}',1,10,".time().",'{$value['price']}','{$goods_marketprice}',100)"; $sql_do_g = "INSERT INTO {$str11} {$sql_g}"; $result1 = $model ->query($sql_do_g); if($result1){ echo $value['goods_name'].':<font color="green">导入商品表成功 </font><br>'; file_put_contents('./seccess.txt', $value['goods_id']); }else{ echo $value['goods_name'].':<font color="red">导入商品表失败 </font><br>'; $handle = fopen('./log.txt','a+'); fwrite($handle,'失败--id:'.$value['goods_id'].'<br />'); fclose($handle); } }else{ $handle = fopen('./log_C.txt','a+'); fwrite($handle,'失败--id:'.$value['goods_id'].'<br />'); fclose($handle); } } } ?>
1,进入sql命令行
按住shift键调出mysql的命令格式
链接上数据库
mysql -uroot -proot
use shop
source E:\all.sql
执行