PHP批量导出导入CSV文件实现原码

 //导出CSV文件
 function export(){
   $str = "ID,帐号\n";
    $str = iconv('utf-8','gb2312',$str);
    $result = mysql_query("select * from user");   
    while($row=mysql_fetch_array($result)){    
        $id 	  = iconv('utf-8','gb2312',$row['id']);
        $user     = iconv('utf-8','gb2312',$row['user']);
        $str .= $id.",".$user."\n";
    }   
    $filename = date('Ymd').'.csv';
    export_csv($filename,$str);
    }


//导出CSV文件方法
function export_csv($filename,$data) {
    header("Content-type:text/csv");
    header("Content-Disposition:attachment;filename=".$filename);
    header('Cache-Control:must-revalidate,post-check=0,pre-check=0');
    header('Expires:0');
    header('Pragma:public');
    echo $data;
}

//导入数据据CSV文件
function input_csv($handle) {
 $out = array ();
 $n = 0;
 while ($data = fgetcsv($handle, 10000)) {
  $num = count($data);
  for ($i = 0; $i < $num; $i++) {
       $out[$n][$i] = $data[$i];
  }
  $n++;
 }
 return $out;
}

if ($action == 'import') { //导入CSV
 $filename = $_FILES['file']['tmp_name'];
 if (empty ($filename)) {
  echo '请选择要导入的CSV文件！';
  exit;
 }
 $handle = fopen($filename, 'r');
 $result = input_csv($handle); //解析csv
 $len_result = count($result);
 if($len_result==0){
  echo '没有任何数据！';
  exit;
 }
 for ($i = 1; $i < $len_result; $i++) { //循环获取各字段值
  $id = $result[$i][0]; //中文转码
  $shr = iconv('gb2312', 'utf-8', $result[$i][1]);
  $dz = iconv('gb2312', 'utf-8', $result[$i][2]);
  $sql = "update list set dh=$dh,zt=".$zt.",kd='".$kd."' where id =".$id; 
  $query = mysql_query($sql) or die('cw'.mysql_error());//批量修改数据表中
 }
 fclose($handle); //关闭指针
 if($query){
  echo '导入成功！';
 }else{
  echo '导入失败！';
 }
 ｝