我有一个字符串,它是使用fputcsv函数创建的。
Date,Name,Hours 2013-01-02,"Test User",7:59 2013-01-03,"Test User",7:53 2013-01-04,"Test User",8:12 2013-01-07,"Test User",7:56 2013-01-08,"Test User",8:25 2013-01-09,"Test User",7:56 2013-01-10,"Test User",8:10 2013-01-11,"Test User",7:53 2013-01-14,"Test User",7:54 2013-01-15,"Test User",0:34 2013-04-01,"Test User",5:51 2013-04-02,"Test User",8:50 2013-04-03,"Test User",7:25 2013-04-04,"Test User",8:3 2013-04-05,"Test User","10:42:52[Not punch out]" ,Total,103:1
当设置了适当的头信息(header('Content-type: application/csv'); header('Content-Disposition: attachment; filename="'.$filename.'"');)时,会生成正确的csv文件。
但是我想再将这个字符串转换为数组格式,所以我尝试将上面的字符串传递给str_getcsv函数,但是得到的数组像这样:
Array
(
[0] => Date
[1] => Name
[2] => Hours
2013-01-02
[3] => "Allen Herrera"
[4] => 7:59
2013-01-03
[5] => "Allen Herrera"
[6] => 7:53
2013-01-04
[7] => "Allen Herrera"
[8] => 8:12
2013-01-07
[9] => "Allen Herrera"
[10] => 7:56
2013-01-08
[11] => "Allen Herrera"
[12] => 8:25
2013-01-09
[13] => "Allen Herrera"
[14] => 7:56
2013-01-10
[15] => "Allen Herrera"
[16] => 8:10
2013-01-11
[17] => "Allen Herrera"
[18] => 7:53
2013-01-14......................
你能帮我得到格式正确的数组吗?这样我就可以轻松地使用它来创建循环表格。
PHP_EOL
作为分隔符来进行explode()
,然后在str_getcsv()
中使用每个部分。 - Maxim Khan-Magomedov