执行的顺序:
1)文件浏览框(选择文件使用)
选择好文件后
点击一个导入按钮的时候 ,把上面上传框里的csv文件以一个ID为文件名,上传到**/**文件夹下
2)读取这个文件夹下的csv的文件,转换成sql
3)然后再insert到数据库里但是中间的转换似乎除了问题,没有数据
请各位帮忙看看是不是哪里出了问题↓↓↓
if ($_FILES['csv_file_road']['tmp_name'] != '') {
$all_name = $_FILES['csv_file_road']['tmp_name'];
$file_name = $ADDRESS_CSV_COMMON_USER.'.csv';
if(!copy($all_name,CSVWAY.$file_name)){
$messageStack->add("文件上传失败", 'error');
return;
}
}
$handle = fopen (CSVWAY.$file_name,"r");
while ($data = fgetcsv ($handle, 5000, ",")) {
$row_num = $row_num+1;//now read csv row-num
$error_info = "";
if($row_num == 1){
 continue;
}
$num = count ($data);
if($num < 14){
continue;
}
for ($c1=0; $c1 < $num; $c1++) {
            $data[$c1] = mb_convert_encoding($data[$c1],'UTF-8',"GB2312,shift_jis");
          }
          
 $check_array['SUBJECT'] = trim($data['1']);
 $check_array['PERSONAL_NAME'] = trim($data['2']);
           $check_array['PERSONAL_SORT_KEY'] = trim($data['3']);
           $check_array['PERSONAL_SORT_KEY_ZH'] = trim($data['4']);
           $check_array['COMPANY_NAME'] = trim($data['5']);
           $check_array['COMPANY_SORT_KEY'] = trim($data['6']);
           $check_array['COMPANY_SORT_KEY_ZH'] = trim($data['7']);
           $check_array['SECTION_NAME'] = trim($data['8']);
           $check_array['ZIP_CODE'] = trim($data['9']);
           $check_array['PHYSICAL_ADDRESS'] = trim($data['10']);
           $check_array['COMPANY_TELEPHONE_NUMBER'] = trim($data['11']);
           $check_array['FACSIMILE_NUMBER'] = trim($data['12']);
           $check_array['POST_NAME'] = trim($data['13']);
           $check_array['URL'] = trim($data['14']);
           $check_array['TEL'] = trim($data['15']);
           $check_array['EMAIL_ADDRESS'] = trim($data['16']);
           $check_array['IMAGE'] = trim($data['17']);
           $check_array['DESCRIPTION'] = trim($data['18']);
           //echo $check_array['DESCRIPTION'];
          for($i=0;$i<count($_POST['ADDRESS_ID']);$i++){
$check_array['SUBJECT'] = trim($_POST['SUBJECT'][$i]);
$check_array['PERSONAL_NAME'] = trim($_POST['PERSONAL_NAME'][$i]);
$check_array['PERSONAL_SORT_KEY'] = trim($_POST['PERSONAL_SORT_KEY'][$i]);
$check_array['PERSONAL_SORT_KEY_ZH'] = trim($_POST['PERSONAL_SORT_KEY_ZH'][$i]);
$check_array['COMPANY_NAME'] = trim($_POST['COMPANY_NAME'][$i]);
$check_array['COMPANY_SORT_KEY'] = trim($_POST['COMPANY_SORT_KEY'][$i]);
$check_array['COMPANY_SORT_KEY_ZH'] = trim($_POST['COMPANY_SORT_KEY_ZH'][$i]);
$check_array['SECTION_NAME'] = trim($_POST['SECTION_NAME'][$i]);
$check_array['ZIP_CODE'] = trim($_POST['ZIP_CODE'][$i]);
$check_array['PHYSICAL_ADDRESS'] = trim($_POST['PHYSICAL_ADDRESS'][$i]);
$check_array['COMPANY_TELEPHONE_NUMBER'] = trim($_POST['COMPANY_TELEPHONE_NUMBER'][$i]);
$check_array['FACSIMILE_NUMBER'] = trim($_POST['FACSIMILE_NUMBER'][$i]);
$check_array['POST_NAME'] = trim($_POST['POST_NAME'][$i]);
$check_array['URL'] = trim($_POST['URL'][$i]);
$check_array['TEL'] = trim($_POST['TEL'][$i]);
$check_array['EMAIL_ADDRESS'] = trim($_POST['EMAIL_ADDRESS'][$i]);
$check_array['IMAGE'] = trim($_POST['IMAGE'][$i]);
$check_array['DESCRIPTION'] = trim($_POST['DESCRIPTION'][$i]);
}
}
文件上传是成功的