php cl 环境下上传csv文件并写入数据库

        //获取上传过来的文件
        $file=$_FILES['file'];

        $max_size="2000000"; //最大文件限制（单位：byte）
        $fname=$file['name'];
        //提取文件后缀，判断文件类型
        $ftype=strtolower(substr(strrchr($fname,'.'),1));
        //文件格式
        $uploadfile=$file['tmp_name'];//获取缓存文件

        //仅接收POST
        if($_SERVER['REQUEST_METHOD']=='POST'){
         if(is_uploaded_file($uploadfile)){
                //文件过大
            if($file['size']>$max_size){
                $this->response(false, 200, 'Import file is too large!');
                return;
            }
                //文件名不对
            if($ftype!='csv'){
                $this->response(false, 200, 'Import file type is error!');
                return;
            }
        }else{
            $this->response(false, 200, 'The file is not empty!');
            return;
        }
    }

    //load数据库
    $this->load->database();

    $row=0;//记录行数
    $filename=$file['tmp_name'];

    //使用 fopen打开文件
    $handle=fopen($filename,'r');//打开文件

    //使用 fgetcsv 获取每一行的数据
    while(!feof($handle) && $data=fgetcsv($handle,1000,',')){
      $arr_result=array();
      if($row==0){//跳过第一行
         $row++;
         continue;
     }
     if($row>0 && !empty($data)){
        $num=count($data);
        for($i=0;$i<$num;$i++){
            array_push($arr_result,$data[$i]);
        }

        $sql = "INSERT INTO `company_pre_registration`
        (ordinal,account,companyName,address,legalRepresentative,representativeTel,contactMan,contactPhone,email)
        VALUES (?,?,?,?,?,?,?,?,?)";

        //csv 内容的数据顺序都是一开始规定好的0-8

        //GBK转码问题 
        $ordinal = iconv('gb2312','utf-8',$arr_result[0]);
        $account = iconv('gb2312','utf-8',$arr_result[1]);
        $companyName = iconv('gb2312','utf-8',$arr_result[2]);
        $address = iconv('gb2312','utf-8',$arr_result[3]);
        $legalRepresentative = iconv('gb2312','utf-8',$arr_result[4]);
        $representativeTel = iconv('gb2312','utf-8',$arr_result[5]);
        $contactMan = iconv('gb2312','utf-8',$arr_result[6]);
        $contactPhone = iconv('gb2312','utf-8',$arr_result[7]);
        $email = iconv('gb2312','utf-8',$arr_result[8]);

        $result = $this->db->query($sql, array($ordinal,$account,$companyName,$address,$legalRepresentative,$representativeTel,$contactMan,$contactPhone,$email));

        // $result = $this->db->query($sql, array($arr_result[0],$arr_result[1],$arr_result[2],$arr_result[3],$arr_result[4],$arr_result[5],$arr_result[6],$arr_result[7],$arr_result[8]));
      //$name = iconv('gb2312','utf-8',$arr_result[1]);
      //$sex = iconv('gb2312','utf-8',$arr_result[2]);
      //echo $sql;

        if(!$result){
            $this->response(false, 200, 'insert error!');
            return;
        }
    }
    $row++;
    }
    fclose($handle);

    $this->response(true, 200, null);
    return;