PHP实现CSV文件的导入和导出类


            本文实例讲述了PHP实现CSV文件的导入和导出类。分享给大家供大家参考。具体如下：





<?php

/**

 * CSV 文件处理类

 */

class Csv{

  public $csv_array; //csv数组数据

  public $csv_str; //csv文件数据

  public function __construct($param_arr, $column){

    $this->csv_array = $param_arr;

    $this->path = $path;

    $this->column = $column;

  }

  /**

   * 导出

   * */

  public function export(){

    if(empty($this->csv_array) || empty($this->column)){

      return false;

    }

    $param_arr = $this->csv_array;

    unset($this->csv_array);

    $export_str = implode(',',$param_arr['nav'])."n";

    unset($param_arr['nav']);

    //组装数据

    foreach($param_arr as $k=>$v){

      foreach($v as $k1=>$v1){

        $export_str .= implode(',',$v1)."n";

      }

    }

    //将$export_str导出

    header( "Cache-Control: public" );

    header( "Pragma: public" );

    header("Content-type:application/vnd.ms-excel");

    header("Content-Disposition:attachment;filename=txxx.csv");

    header('Content-Type:APPLICATION/OCTET-STREAM');

    ob_start();   

   // $file_str= iconv("utf-8",'gbk',$export_str);

    ob_end_clean();

    echo $export_str;

  }

  /**

   * 导入

   * */

  public function import($path,$column = 3){

    $flag = flase;

    $code = 0;

    $msg = '未处理';

    $filesize = 1; //1MB

    $maxsize = $filesize * 1024 * 1024;

    $max_column = 1000;

 

    //检测文件是否存在

    if($flag === flase){

      if(!file_exists($path)){

        $msg = '文件不存在';

        $flag = true;

      }

    }

    //检测文件格式

    if($flag === flase){

      $ext = preg_replace("/.*.([^.]+)/","$1",$path);

      if($ext != 'csv'){

        $msg = '只能导入CSV格式文件';

        $flag = true;

      }

    }

    //检测文件大小

    if($flag === flase){

      if(filesize($path)>$maxsize){

        $msg = '导入的文件不得超过'.$maxsize.'B文件';

        $flag = true;

      }

    }

    //读取文件

    if($flag == flase){

      $row = 0;

      $handle = fopen($path,'r');

      $dataArray = array();

      while($data = fgetcsv($handle,$max_column,",")){

        $num = count($data);

        if($num < $column){

          $msg = '文件不符合规格真实有：'.$num.'列数据';

          $flag = true;

          break;

        }

        if($flag === flase){

          for($i=0;$i<3;$i++){

            if($row == 0){

              break;

            }

            //组建数据

            $dataArray[$row][$i] = $data[$i];

          }

        }

        $row++;

      }

    }

    return $dataArray;

  }

}

$param_arr = array(

'nav'=>array('用户名','密码','邮箱'),

array(0=>array('xiaohai1','123456','xiaohai1@zhongsou.com'),

   1=>array('xiaohai2','213456','xiaohai2@zhongsou.com'),

   2=>array('xiaohai3','123456','xiaohai3@zhongsou.com')

));

$column = 3;

$csv = new Csv($param_arr, $column);

//$csv->export();

$path = 'C:\Documents and Settings\Administrator\Temp\txxx.csv';

$import_arr = $csv->import($path,3);

var_dump($import_arr);

?>



希望本文所述对大家的php程序设计有所帮助。