php 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('学生姓名')); 
} 
}

更多php csv操作类代码相关文章请关注PHP中文网！

论小文

可靠的论文写作助手，包含11种学术写作类型，万字论文一键生成，可降重降AIGC，参考文献真实可标注，图表代码均可自定义添加。

下载