PHP实现CSV文件的导入和导出类-php手册-php.cn

Home

php教程

php手册

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

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 13, 2016 am 09:10 AM

csvphpmainandaccomplishimportExportdocumentarticleofkind

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

这篇文章主要介绍了PHP实现CSV文件的导入和导出类,实例分析了php针对csv文件的操作技巧,非常具有实用价值,需要的朋友可以参考下

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

100

101

102

103

104

105

106

107

108

109

110

111

112

113

/**

* 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

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

$flag = true;

break;

}

if($flag === flase){

for($i=0;$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程序设计有所帮助。

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn