<?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
执行