php 导出csv字符串,PHP CSV字符串到数组
我正在嘗試將CS??V字符串解析為PHP中的數組. CSV字符串具有以下屬性:
Delimiter: ,
Enclosure: "
New line: \r\n
示例內容:
"12345","Computers","Acer","4","Varta","5.93","1","0.04","27-05-2013"
"12346","Computers","Acer","5","Decra","5.94","1","0.04","27-05-2013"
當我嘗試解析它時:
$url = "http://www.url-to-feed.com";
$csv = file_get_contents($url);
$data = str_getcsv($csv);
var_dump($data);
最后一個元素和一個元素串在一個字符串中:
[0]=> string(5) "12345"
...
[7]=> string(4) "0.04"
[8]=> string(19) "27-05-2013
"12346""
我怎樣才能解決這個問題?任何幫助,將不勝感激.
解決方法:
做這個:
$csvData = file_get_contents($fileName);
$lines = explode(PHP_EOL, $csvData);
$array = array();
foreach ($lines as $line) {
$array[] = str_getcsv($line);
}
print_r($array);
它會給你一個像這樣的輸出:
Array
(
[0] => Array
(
[0] => 12345
[1] => Computers
[2] => Acer
[3] => 4
[4] => Varta
[5] => 5.93
[6] => 1
[7] => 0.04
[8] => 27-05-2013
)
[1] => Array
(
[0] => 12346
[1] => Computers
[2] => Acer
[3] => 5
[4] => Decra
[5] => 5.94
[6] => 1
[7] => 0.04
[8] => 27-05-2013
)
)
我希望這可以提供一些幫助.
標簽:php,csv,parsing
來源: https://codeday.me/bug/20190918/1810744.html
總結
以上是生活随笔為你收集整理的php 导出csv字符串,PHP CSV字符串到数组的全部內容,希望文章能夠幫你解決所遇到的問題。
- 上一篇: Php传图缩图,使用以下用于上传图像的P
- 下一篇: php留言簿代码,php自治简单留言板代