时时商务社区

标题: php csv操作类代码 [打印本页]

作者: 新格网络 时间: 2018-2-14 09:01

         请点击后面地址下载：csv操作类
使用说明如下：
1.生成csv文件
[U]复制代码[/U] 代码如下:
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读数据
代码
[U]复制代码[/U] 代码如下:
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导出MySQL数据到Excel文件(fputcsv)

基于PHP读取csv文件内容的详解

基于php导出到Excel或CSV的详解(附utf8、gbk 编码转换)

php对csv文件的读取,写入,输出下载操作详解

php导入csv文件碰到乱码问题的解决方法

PHP按行读取、处理较大CSV文件的代码实例

详解PHP导入导出CSV文件

php使用fgetcsv读取csv文件出现乱码的解决方法

php将csv文件导入到mysql数据库的方法

利用PHP生成CSV文件简单示例

欢迎光临时时商务社区 (http://bbs.4435.cn/)