使用php创建csv文件 [英] Creating csv file with php
本文介绍了使用php创建csv文件的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想创建一个csv文件,但当我运行代码,它返回一个银行页面,没有csv文件。我使用PHP 5.
我使用下面的代码:
<?php
$ data = array('aaa,bbb,ccc,dddd',
'123,456,789',
'aaa,bbb');
$ fp = fopen('data.csv','w');
foreach($ data as $ line){
$ val = explode(,,$ line);
fputcsv($ fp,$ val);
}
fclose($ fp);
?>
谢谢!
解决方案
它是空白的,因为您正在写入文件
。您应该使用 php:// output
写入输出
,并发送头信息以指示其csv。 p>
示例
header('Content-Type:application / excel') ;
header('Content-Disposition:attachment; filename =sample.csv');
$ data = array(
'aaa,bbb,ccc,dddd',
'123,456,789',
'aaa,bbb'
);
$ fp = fopen('php:// output','w');
foreach($ data as $ line){
$ val = explode(,,$ line);
fputcsv($ fp,$ val);
}
fclose($ fp);
I want to create a csv file, but when I run the code, it returns a bank page and no csv file. I use PHP 5. I use the following code:
<?php
$data = array ('aaa,bbb,ccc,dddd',
'123,456,789',
'"aaa","bbb"');
$fp = fopen('data.csv', 'w');
foreach($data as $line){
$val = explode(",",$line);
fputcsv($fp, $val);
}
fclose($fp);
?>
Thank you!
解决方案
Its blank because you are writing to file
. you should write to output
using php://output
instead and also send header information to indicate its csv.
Example
header('Content-Type: application/excel');
header('Content-Disposition: attachment; filename="sample.csv"');
$data = array(
'aaa,bbb,ccc,dddd',
'123,456,789',
'"aaa","bbb"'
);
$fp = fopen('php://output', 'w');
foreach ( $data as $line ) {
$val = explode(",", $line);
fputcsv($fp, $val);
}
fclose($fp);
这篇关于使用php创建csv文件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文