php csv,php csv操作类代码

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

}

}