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