du6333137 2016-08-22 14:57
浏览 36
已采纳

PHP str_getcsv不会分隔索引1和2中的元素

I'm importing a CSV and creating a 2D array with it. The problem is that in the indexes 1 and 2 the function doesn't recognize the separator "," so every array is ok but the ones in the second and third position.

I tried with multiple files, multiple software (LibreOffice, Google Spreadsheet) and it has always the same problem.

This is the code:

$dbLocation = 'upload/db.csv';

$paramStrGetCsv = array(",", '"', "\\");
$db = array_map('str_getcsv', file($dbLocation), $paramStrGetCsv);

print "<pre>";
print_r($db);
print "</pre>";

This is the array $db:

Array
(
    [0] => Array
        (
            [0] => email
            [1] => name
            [2] => surname
            [3] => birthdate
        )

    [1] => Array
        (
            [0] => red@email.com,red,qwer,1990-06-01
        )

    [2] => Array
        (
            [0] => blue@gmail.com,blue,poiu,1990-01-01
        )

    [3] => Array
        (
            [0] => green@yahoo.com
            [1] => green
            [2] => yuiop
            [3] => 1980-01-01
        )

    [4] => Array
        (
            [0] => purple@gmail.com
            [1] => purple
            [2] => zxcvbn
            [3] => 1975-01-01
        )

    [5] => Array
        (
            [0] => yellow@gmail.com
            [1] => yellow
            [2] => vbnm
            [3] => 1970-01-01
        )
)

This is the csv file:

email,name,surname,birthdate
red@email.com,red,qwer,1990-06-01
blue@gmail.com,blue,poiu,1990-01-01
green@yahoo.com,green,yuiop,1980-01-01
purple@gmail.com,purple,zxcvbn,1975-01-01
yellow@gmail.com,yellow,vbnm,1970-01-01

Thank you, Federico.

  • 写回答

1条回答 默认 最新

  • douhuigang9550 2016-08-22 15:16
    关注

    So here's your problem:

    $db = array_map('str_getcsv', file($dbLocation), $paramStrGetCsv);
    

    First entry will run function str_getcsv("email,name,surname,birthdate", ",")

    Second will run str_getcsv(red@email.com,red,qwer,1990-06-01, "\"")

    and generally array map maps mutliple arrays using a single function which accepts multiple arguments, so it will try to use both the file and the $paramStrGetCsv to do the mapping. Instead do this:

    $db = array_map(function ($ln) { return str_getcsv($ln,",", '"', "\\"); }, file($dbLocation));
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 CST仿真别人的模型结果仿真结果S参数完全不对
  • ¥15 pyqt5读取ui文件报错
  • ¥15 请问在阿里云服务器中怎么利用数据库制作网站
  • ¥60 ESP32怎么烧录自启动程序
  • ¥50 html2canvas超出滚动条不显示
  • ¥15 java业务性能问题求解(sql,业务设计相关)
  • ¥15 52810 尾椎c三个a 写蓝牙地址
  • ¥15 elmos524.33 eeprom的读写问题
  • ¥15 用ADS设计一款的射频功率放大器
  • ¥15 怎么求交点连线的理论解?