可复用的PHP类库（二）：csv操作类

请点击后面地址下载：csv操作类

使用说明如下：

1.生成csv文件

代码

require   " ./include/csvdatafile.php " ; 

set_time_limit ( 200 );
header ( " Content-type: application/RFC822 " );
header ( ' Content-Disposition: attachment; filename=export.csv ' );

$arr_export_titles   =   array ("学生编号","学号","学生姓名");

 

$csvfile   =   new  csvDataFile( "" ,   " , " ,   " w " );
echo   $csvfile -> printline( $arr_export_titles );
// 方法一
$print_data1 []  =   1 ;
$print_data1 []  =   " 039413301 " ;
$print_data1 []  =   " 张三 " ;
echo   $csvfile -> printline( $print_data1 );

$print_data2 []  =   2 ;
$print_data2 []  =   " 039413302 " ;
$print_data2 []  =   " 李四 " ;
echo   $csvfile -> printline( $print_data2 );


$print_data3 []  =   3 ;
$print_data3 []  =   " 039413303 " ;
$print_data3 []  =   " 王五 " ;
echo   $csvfile -> printline( $print_data3 );


// 方法二
$print_data [ 1 ][]  =   1 ;
$print_data [ 1 ][]  =   " 039413301 " ;
$print_data [ 1 ][]  =   " 张三 " ;
$print_data [ 2 ][]  =   2 ;
$print_data [ 2 ][]  =   " 039413302 " ;
$print_data [ 2 ][]  =   " 李四 " ;
$print_data [ 3 ][]  =   3 ;
$print_data [ 3 ][]  =   " 039413303 " ;
$print_data [ 3 ][]  =   " 王五 " ;
echo   $csvfile -> printcsv( $print_data );

  

2.打开csv读数据 

代码

require   " ./include/csvdatafile.php " ;

$filename   =   " E:/development/csvfile/datefile.csv " ;

//  Read file source
$handle   =   fopen ( $filename ,   " r " );
$contents   =   fread ( $handle ,   filesize ( $filename ));
fclose ( $handle );

//  format content for special chars
$contents   =  @ addslashes ( $contents );
$contents   =  @ str_replace ( ' \, ' ,   ' \ , ' ,   $contents );
$contents   =  @ stripslashes ( $contents );

//  Write to new file
$handle   =  @ fopen ( $filename ,   " w " );
@ fwrite ( $handle ,   $contents );
@ fclose ( $handle );

$fd   =  @ fopen ( $filename ,   " rb " );
$first_line   =   str_replace ( '  , ' , ' , ' , str_replace ( ' " ' , '' , trim (@ fgets ( $fd ,   1000 )))) ;
@ fclose ( $fd );

if ( $first_line   !=   " 学生编号,学号,学生姓名 " ) {
         $pass   =   false ;
}

if ( $pass ){
         $csv   =   new  csvDataFile( $filename );
         while ( $csv -> next_Row()) {
                 $userid   =   trim ( $csv -> f( ' 学生编号 ' ));
                 $classno   =   trim ( $csv -> f( ' 学号 ' ));
                 $username   =   trim ( $csv -> f( ' 学生姓名 ' ));
        }
}

 

转载于:https://www.cnblogs.com/xiaosuo/archive/2009/12/14/1623803.html