php - 如何使用 PHP 打印 CSV 文件的行?
问题描述
这是我正在使用的代码,但它并没有完全输出我想要的。
<?php
$file = fopen("ad.csv","r");
while(! feof($file))
{
print_r(fgetcsv($file));
}
fclose($file);
?>
这是它当前输出的内容:
Array ( [0] => cn [1] => mail [2] => telephonenumber [3] => uid ) Array ( [0] => [1] => [2] => [3] => ) Array ( [0] => admin [1] => [2] => [3] => ) Array ( [0] => Isaac Newton [1] => newton@ldap.forumsys.com [2] => [3] => newton ) Array ( [0] => Albert Einstein [1] => einstein@ldap.forumsys.com [2] => 314-159-2653 [3] => einstein ) Array ( [0] => Nikola Tesla [1] => tesla@ldap.forumsys.com [2] => [3] => tesla ) Array ( [0] => Galileo Galilei [1] => galieleo@ldap.forumsys.com [2] => [3] => galieleo ) Array ( [0] => Leonhard Euler [1] => euler@ldap.forumsys.com [2] => [3] => euler ) Array ( [0] => Carl Friedrich Gauss [1] => gauss@ldap.forumsys.com [2] => [3] => gauss ) Array ( [0] => Bernhard Riemann [1] => riemann@ldap.forumsys.com [2] => [3] => riemann ) Array ( [0] => Euclid [1] => euclid@ldap.forumsys.com [2] => [3] => euclid ) Array ( [0] => Mathematicians [1] => [2] => [3] => ) Array ( [0] => Scientists [1] => [2] => [3] => ) Array ( [0] => read-only-admin [1] => [2] => [3] => ) Array ( [0] => Italians [1] => [2] => [3] => ) Array ( [0] => Test [1] => [2] => [3] => test ) Array ( [0] => Chemists [1] => [2] => [3] => ) Array ( [0] => Marie Curie [1] => curie@ldap.forumsys.com [2] => [3] => curie ) Array ( [0] => Alfred Nobel [1] => nobel@ldap.forumsys.com [2] => [3] => nobel ) Array ( [0] => Robert Boyle [1] => boyle@ldap.forumsys.com [2] => 999-867-5309 [3] => boyle ) Array ( [0] => Louis Pasteur [1] => pasteur@ldap.forumsys.com [2] => 602-214-4978 [3] => pasteur ) Array ( [0] => No Group [1] => nogroup@ldap.forumsys.com [2] => [3] => nogroup ) Array ( [0] => FS Training [1] => training@forumsys.com [2] => 888-111-2222 [3] => training ) Array ( [0] => FS Training [1] => jmacy-training@forumsys.com [2] => 888-111-2222 [3] => jmacy )
换句话说,它几乎就像是将我所有的 CSV 数据添加到一个多维数组中......
我想要的是像这样输出它:
cn,mail,telephonenumber,uid
,,,
admin,,,
"Isaac Newton",newton@ldap.forumsys.com,,newton
"Albert Einstein",einstein@ldap.forumsys.com,314-159-2653,einstein
"Nikola Tesla",tesla@ldap.forumsys.com,,tesla
"Galileo Galilei",galieleo@ldap.forumsys.com,,galieleo
"Leonhard Euler",euler@ldap.forumsys.com,,euler
"Carl Friedrich Gauss",gauss@ldap.forumsys.com,,gauss
"Bernhard Riemann",riemann@ldap.forumsys.com,,riemann
Euclid,euclid@ldap.forumsys.com,,euclid
Mathematicians,,,
Scientists,,,
read-only-admin,,,
Italians,,,
Test,,,test
Chemists,,,
"Marie Curie",curie@ldap.forumsys.com,,curie
"Alfred Nobel",nobel@ldap.forumsys.com,,nobel
"Robert Boyle",boyle@ldap.forumsys.com,999-867-5309,boyle
"Louis Pasteur",pasteur@ldap.forumsys.com,602-214-4978,pasteur
"No Group",nogroup@ldap.forumsys.com,,nogroup
"FS Training",training@forumsys.com,888-111-2222,training
"FS Training",jmacy-training@forumsys.com,888-111-2222,jmacy
解决方案
如何使用 PHP 解析 CSV 文件 有一些有趣的建议
顺便说一句,在 php 7.2 这也可以:
<?php
$row = 1;
if (($handle = fopen("ad.csv", "r")) !== FALSE) {
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
echo ($data[0].",".$data[1].",".$data[2].",".$data[3]."\n");
}
fclose($handle);
}
?>
此外,.csv 数据上的引号应包含所有数据,例如:
"Isaac Newton","newton@ldap.forumsys.com",,"newton"
"Albert Einstein","einstein@ldap.forumsys.com","314-159-2653","einstein"
"Nikola Tesla","tesla@ldap.forumsys.com",,"tesla"
"Galileo Galilei","galieleo@ldap.forumsys.com",,"galieleo"
推荐阅读
- python - 在熊猫的loc方法中动态更改行索引
- css - 为什么这个 css 在演示中工作,但不在我的项目中?
- list - Haskell - 给定两个整数,找到所有子列表
- android - 在 Android 的 EditText 中设置文本时出错
- python - 尝试安装 Pyro 库时出错
- handle - noUiSlider 手柄有两条小竖线,造型后不会消失
- php - 致命错误:更新 wordpress 后函数名称必须是字符串
- node.js - 无法从服务器获得实际响应
- python - 方法 strip() 没有从我的字符串中删除字符
- android - Ionic/Angular/Cordova 的 Google 登录插件中的错误 10