PHP CSV string to array

Question

I m trying to parse a CSV string to an array in PHP  The CSV string has the following attributes   Delimiter    Enclosure    New line   r n   Example content    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    When I try to parse it like this    url    http   www url-to-feed com    csv   file get contents  url    data   str getcsv  csv   var dump  data     The last and first element are concatenated in one string    0   gt  string 5   12345       7   gt  string 4   0 04   8   gt  string 19   27-05-2013  12346     How can I fix this  Any help would be appreciated

User · Accepted Answer

Do this    csvData   file get contents  fileName    lines   explode PHP EOL   csvData    array   array    foreach   lines as  line         array     str getcsv  line     print r  array     It will give you an output like this   Array        0    gt  Array                        0    gt  12345              1    gt  Computers              2    gt  Acer              3    gt  4              4    gt  Varta              5    gt  5 93              6    gt  1              7    gt  0 04              8    gt  27-05-2013                 1    gt  Array                        0    gt  12346              1    gt  Computers              2    gt  Acer              3    gt  5              4    gt  Decra              5    gt  5 94              6    gt  1              7    gt  0 04              8    gt  27-05-2013                I hope this can be of some help

User · Answer

Handy oneliner    csv   array map  str getcsv   file  data csv

User · Answer

If you have carriage return line feeds within columns  str getcsv will not work   Try https   github com synappnz php-csv  Use   include  csv php    csv   new csv file get contents  filename csv      rows    csv- gt rows    foreach   rows as  row         do something with  row

User · Answer

Slightly shorter version  without unnecessary second variable    csv    lt  lt  lt  ENDLIST   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  ENDLIST    arr   explode   n    csv   foreach   arr as  amp  line       line   str getcsv  line

User · Answer

If you need a name for the csv columns  you can use this method    example  array map function  v    column   str getcsv  v       return array  foo    gt   column 0   bar    gt   column 1     file  file csv

User · Answer

You can convert CSV string to Array with this function       function csv2array           csv string           delimiter                 skip empty lines   true           trim fields   true           FirstLineTitle   false                  arr   array map              function    line   use    amp  result   amp  FirstLine   delimiter   trim fields   FirstLineTitle                     if   FirstLineTitle  amp  amp    FirstLine                         FirstLine   explode   delimiter   result 0                                        lineResult   array map                      function    field                             return str replace     Q          utf8 decode  urldecode   field                                                    trim fields   array map   trim   explode   delimiter   line       explode   delimiter   line                                      return  FirstLineTitle   array combine   FirstLine   lineResult      lineResult                               result   preg split                   skip empty lines      trim fields         R   s       R  s         R s                   preg replace callback                                s                       function    field                             return urlencode  utf8 encode   field 1                                                   enc   preg replace       lt             Q      csv string                                                       return  FirstLineTitle   array splice  arr  1     arr

User · Answer

A modification of previous answers using array map  Blow up the CSV data with multiple lines    csv   array map  str getcsv   explode   n    csvData

User · Answer

You should use fgetcsv   Since you cannot import a file as a stream because the csv is a variable  then you should spoof the string as a file by using php   temp or php   memory first   fp   fopen  quot php   temp quot    r     fputs  fp   csvText   rewind  fp    Then you will have no problem using fgetcsv   csv       while     data   fgetcsv  fp        FALSE          csv      data      data will be an array of a single csv line  which may include line breaks or commas  etc   as it should be  Caveat  The memory limit of php   temp can be controlled by appending  maxmemory NN  where NN is the maximum amount of data to keep in memory before using a temporary file  in bytes   the default is 2 MB  http   www php net manual en wrappers php php

User · Answer

I have used following function to parse csv string to associative array  public function csvToArray  file         rows   array         headers   array        if  file exists  file   amp  amp  is readable  file              handle   fopen  file   r            while   feof  handle                  row   fgetcsv  handle  10240                         if  empty  headers                    headers    row              else if  is array  row                     array splice  row  count  headers                     rows     array combine  headers   row                                   fclose  handle         else           throw new Exception  file     doesn t exist or is not readable               return  rows      if your csv file name is mycsv csv then you call this function as    dataArray   csvToArray mycsv csv     you can get this script also in http   www scriptville in parse-csv-data-to-array

User · Answer

Try this  it s working for me    delimiter           enclosure           escape             rows   array filter explode PHP EOL   content       header   NULL     data          foreach  rows as  row           row   str getcsv   row   delimiter   enclosure    escape        if   header           header    row        else          data     array combine  header   row

[php] PHP CSV string to array

Examples related to php

Examples related to parsing

Examples related to csv