|
请点击后面地址下载：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[] = "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读数据 代码
<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('学生姓名'));
}
}
（编辑：李大同）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
