PHP class code for importing and exporting CVS files. Through this custom PHP class, the conversion of database data and CVS files can be realized
- /**
- *CSV file processing class
- */
- class Csv{
- public $csv_array; //csv array data
- public $csv_str; //csv file data
-
- public function __construct($param_arr, $column){
- $this->csv_array = $param_arr;
- $this-> path = $path;
- $this->column = $column;
- }
-
- /**
- * Export
- **/
- 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']);
- //Assemble data
- foreach($param_arr as $k=>$v){
- foreach($v as $ k1=>$v1){
- $export_str .= implode(',',$v1)."n";
- }
- }
- //Export $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;
- }
-
- /**
- * Import
- **/
- public function import($path,$column = 3){
- $flag = flase;
- $code = 0;
- $msg = 'Unprocessed';
- $filesize = 1; //1MB
- $maxsize = $filesize * 1024 * 1024;
- $max_column = 1000;
-
- //Check whether the file exists
- if($flag === flase){
- if(!file_exists($path) ){
- $msg = 'File does not exist';
- $flag = true;
- }
- }
- //Detect file format
- if($flag === flase){
- $ext = preg_replace("/.*. ([^.]+)/","$1",$path);
- if($ext != 'csv'){
- $msg = 'Only CSV format files can be imported';
- $flag = true;
- }
- }
-
- //Detect file size
- if($flag === flase){
- if(filesize($path)>$maxsize){
- $msg = 'Imported files must not exceed'.$maxsize. 'B file';
- $flag = true;
- }
- }
-
- //Read file
- if($flag == flase){
- $row = 0;
- $handle = fopen($path,'r' );
- $dataArray = array();
- while($data = fgetcsv($handle,$max_column,",")){
- $num = count($data);
- if($num < $column) {
- $msg = 'The file does not meet the specifications. True: '.$num.' column data';
- $flag = true;
- break;
- }
-
- if($flag === flase){
- for($ i=0;$i<3;$i++){
- if($row == 0){
- break;
- }
- //Build data
- $dataArray[$row][$i] = $data[$i ];
- }
- }
- $row++;
- }
- }
-
- return $dataArray;
- }
- }
-
- $param_arr = array(
- 'nav'=>array('username','password',' Email'),
- 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 SettingsAdministratorLocal SettingsTemptxxx.csv';
- $import_arr = $csv->import($path,3);
- var_dump($ import_arr);
-
- ?>
Copy code
|