php csv操作类代码
前端之家收集整理的这篇文章主要介绍了
php csv操作类代码，
前端之家小编觉得挺不错的，现在分享给大家，也给大家做个参考。
请点击后面地址下载：csv操作类
使用说明如下： 1.生成csv文件 <div class="codetitle"><a style="CURSOR: pointer" data="21827" class="copybut" id="copybut21827" onclick="doCopy('code21827')"> 代码如下:
<div class="codebody" id="code21827">
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[] = "039413
301";
$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][] = "039413
301";
$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读数据
代码 <div class="codetitle">
<a style="CURSOR: pointer" data="13541" class="copybut" id="copybut13541" onclick="doCopy('code13541')"> 代码如下: <div class="codebody" id="code13541">
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('学生姓名'));
}
}
