PHP完全自学手册(珍藏版) 中文pdf扫描版下载
无需选择分类,分类存在则选择不存在则添加
$cat_namearr=array($field_arr['cat_name1'],$field_arr['cat_name2'],$field_arr['cat_name3'],$field_arr['cat_name4'],$field_arr['cat_name5'],$field_arr['cat_name6'],$field_arr['cat_name7']);
$i=0;
$parent_id=0;
foreach ($cat_namearr as $cat_name){
if(!empty($cat_name)){
$cat_id= $db->getOne('SELECT cat_id FROM ' .$ecs->table('category'). " WHERE cat_name='".$cat_name."'");
if (!empty($cat_id)){
$parent_id = $db->getOne('SELECT cat_id FROM ' . $GLOBALS['ecs']->table('category') . " WHERE cat_name = '$cat_name'");
}
else{
$cat_arr['cat_name'] =$cat_name;
$cat_arr['parent_id'] =$parent_id;
$cat_arr['sort_order'] = 50;
$cat_arr['show_in_nav'] = 1;
$cat_arr['is_show'] = 1;
$cat_arr['grade'] = 0;
$db->autoExecute($ecs->table('category'), $cat_arr, 'INSERT');
$parent_id = $db->insert_id();
}
echo $parent_id.'-->';
echo $cat_id.'--><br>';
$field_arr['cat_id'] = $parent_id;
$i++;
}
else{
break ;
}
}
转载请注明:谷谷点程序 » ecshop后台上传zencart批量数据