How to create an array from a CSV file using PHP and the fgetcsv function

Question

Can someone kindly provide a code to create an array from a CSV file using fgetcsv   I ve used the following code to create an array from a simple CSV file  but it doesn t work right when one of my fields has multiple commas - such as addresses    lines  file  CSV Address csv     foreach  lines as  data    list  name    address    status      explode      data        Also  str getcsv is not supported by my hosting service   The above code doesn t work with the following CSV file example   First column is name  second column is address  third column is marital status   Scott L  Aranda  123 Main Street  Bethesda  Maryland 20816  Single Todd D  Smith  987 Elm Street  Alexandria  Virginia 22301  Single Edward M  Grass  123 Main Street  Bethesda  Maryland 20816  Married Aaron G  Frantz  987 Elm Street  Alexandria  Virginia 22301  Married Ryan V  Turner  123 Main Street  Bethesda  Maryland 20816  Single

User · Answer

To get an array with the right keys  you can try this      Open file  file   fopen  file path   r        Headers  headers   fgetcsv  file       Rows  data       while    row   fgetcsv  file       false         item           foreach   row as  key   gt   value           item  headers  key      value    null       data      item        Close file fclose  file

User · Answer

function csvToArray  path        try           csv   fopen  path   r             rows                header                index   0          while    line   fgetcsv  csv       FALSE                if   index    0                     header    line                   index   1                else                    row                       for   i   0   i  lt  count  header    i                           row  header  i      line  i                                     array push  rows   row                                   return  rows       catch  Exception  exception           return false

User · Answer

convertToArray file get content  filename     function convertToArray string  content   array       data   str getcsv  content   n       array walk  data  function  amp  a  use   data            a   str getcsv  a              return  data

User · Answer

If you want each line to be in an array  and each cell in the line in array    file   fopen  csvFile csv    r                    Open the file                      while    line   fgetcsv  file       FALSE          Read one line      array     line                                Add the line in the main array   echo   lt pre gt    print r  array       print it out echo   lt  pre gt     fclose  file

User · Answer

Old question  but still relevant for PHP 5 2 users  str getcsv is available from PHP 5 3  I ve written a small function that works with fgetcsv itself   Below is my function from https   gist github com 4152628    function parse csv file  csvfile         csv   Array         rowcount   0      if    handle   fopen  csvfile   r        FALSE             max line length   defined  MAX LINE LENGTH     MAX LINE LENGTH   10000           header   fgetcsv  handle   max line length            header colcount   count  header           while    row   fgetcsv  handle   max line length       FALSE                 row colcount   count  row               if   row colcount     header colcount                     entry   array combine  header   row                    csv      entry                            else                   error log  csvreader  Invalid number of columns at line       rowcount   2       row       rowcount   1        Expected  header colcount Got  row colcount                    return null                             rowcount                        echo  Totally  rowcount rows found n           fclose  handle             else           error log  csvreader  Could not read CSV    csvfile              return null            return  csv      Returns  Begin Reading CSV  Array        0    gt  Array                        vid    gt                agency    gt                division    gt  Division              country    gt                station    gt  Duty Station              unit    gt  Unit   Department              grade    gt                funding    gt  Fund Code              number    gt  Country Office Position Number              wnumber    gt  Wings Position Number              title    gt  Position Title              tor    gt  Tor Text              tor file    gt                status    gt                datetime    gt  Entry on Wings              laction    gt                supervisor    gt  Supervisor Index Number              asupervisor    gt  Alternative Supervisor Index              author    gt                category    gt                parent    gt  Reporting to Which Position Number              vacant    gt  Status  Vacant   Filled               index    gt  Index Number                 1    gt  Array                        vid    gt                agency    gt  WFP              division    gt  KEN Kenya  The Republic Of              country    gt                station    gt  Nairobi              unit    gt  Human Resources Officer P4              grade    gt  P-4              funding    gt  5000001              number    gt  22018154              wnumber    gt                title    gt  Human Resources Officer P4              tor    gt                tor file    gt                status    gt                datetime    gt                laction    gt                supervisor    gt                asupervisor    gt                author    gt                category    gt  Professional              parent    gt                vacant    gt                index    gt  xxxxx

User · Answer

This function will return array with Header values as array keys       function csv to array  file name             data     header   array             i   0           file   fopen  file name   r            while    line   fgetcsv  file       FALSE                if   i  0                      header    line                else                    data      line                                     i                      fclose  file           foreach   data as  key   gt    value                 new item   array                foreach    value as  key   gt   value                     new item   header  key      value                              data      new item                    return   data

User · Answer

Try this code   function readCsv  file        if    handle   fopen  file   r        FALSE            while    lineArray   fgetcsv  handle  4000       FALSE                print r lineArray                     fclose  handle

User · Answer

I came up with this pretty basic code  I think it could be useful to anyone    link    link to the CSV here   fp   fopen  link   r     while   line   fgetcsv  fp       FALSE        foreach  line as  key   gt   value            echo  key     -      value     lt br gt              fclose  fp

User · Answer

I think the str getcsv   syntax is much cleaner  it also doesn t require the CSV to be stored in the file system    csv   str getcsv file get contents  myCSVFile csv      echo   lt pre gt    print r  csv   echo   lt  pre gt      Or for a line by line solution    csv   array     lines   file  myCSVFile csv   FILE IGNORE NEW LINES    foreach   lines as  key   gt   value         csv  key    str getcsv  value      echo   lt pre gt    print r  csv   echo   lt  pre gt      Or for a line by line solution with no str getcsv      csv   array     file   fopen  myCSVFile csv    r     while    result   fgetcsv  file       false         csv      result     fclose  file    echo   lt pre gt    print r  csv   echo   lt  pre gt

User · Answer

I have created a function which will convert a csv string to an array  The function knows how to escape special characters  and it works with or without enclosure chars    dataArray   csvstring to array  file get contents  Address csv       I tried it with your csv sample and it works as expected   function csvstring to array  string   separatorChar         enclosureChar         newlineChar     n             author  Klemen Nagode      array   array         size   strlen  string        columnIndex   0       rowIndex   0       fieldValue          isEnclosured   false      for  i 0   i lt  size  i                char    string  i            addChar                if  isEnclosured                if  char   enclosureChar                     if  i 1 lt  size  amp  amp   string  i 1    enclosureChar                          escaped char                      addChar  char                       i       dont check next char                  else                       isEnclosured   false                                 else                    addChar  char                         else               if  char   enclosureChar                     isEnclosured   true               else                    if  char   separatorChar                          array  rowIndex   columnIndex     fieldValue                       fieldValue                           columnIndex                     elseif  char   newlineChar                        echo  char                       array  rowIndex   columnIndex     fieldValue                       fieldValue                          columnIndex 0                       rowIndex                     else                        addChar  char                                                    if  addChar                    fieldValue   addChar                        if  fieldValue       save last field          array  rowIndex   columnIndex     fieldValue            return  array

User · Answer

Please fin below a link to the function from  knagode  enhanced with a skip rows parameter  https   gist github com gabrieljenik 47fc38ae47d99868d5b3 file-csv to array   lt  php                Convert a CSV string into an array                  param  string         param  separatorChar         param  enclosureChar         param  newlineChar         param  skip rows         return array             public static function csvstring to array  string   skip rows   0   separatorChar         enclosureChar         newlineChar     n                 author  Klemen Nagode              source  http   stackoverflow com questions 1269562 how-to-create-an-array-from-a-csv-file-using-php-and-the-fgetcsv-function          array   array             size   strlen  string            columnIndex   0           rowIndex   0           fieldValue              isEnclosured   false          for  i 0   i lt  size  i                    char    string  i                addChar                    if  isEnclosured                    if  char   enclosureChar                         if  i 1 lt  size  amp  amp   string  i 1    enclosureChar                              escaped char                          addChar  char                           i       dont check next char                      else                           isEnclosured   false                                         else                        addChar  char                                 else                   if  char   enclosureChar                         isEnclosured   true                   else                        if  char   separatorChar                              array  rowIndex   columnIndex     fieldValue                           fieldValue                               columnIndex                         elseif  char   newlineChar                            echo  char                           array  rowIndex   columnIndex     fieldValue                           fieldValue                              columnIndex 0                           rowIndex                         else                            addChar  char                                                                    if  addChar                        fieldValue   addChar                                    if  fieldValue       save last field              array  rowIndex   columnIndex     fieldValue                                     Skip rows              Returning empty array if being told to skip all rows in the array                       if   skip rows  gt  0                if  count  array      skip rows                   array   array                elseif  count  array   gt   skip rows                   array   array slice  array   skip rows                                  return  array

User · Answer

Like you said in your title  fgetcsv is the way to go  It s pretty darn easy to use    file   fopen  myCSVFile csv    r    while    line   fgetcsv  file       FALSE         line is an array of the csv elements   print r  line     fclose  file     You ll want to put more error checking in there in case fopen   fails  but this works to read a CSV file line by line and parse the line into an array

User · Answer

arrayFromCSV    array map  str getcsv   file   path to file csv

User · Answer

Try this    function getdata  csvFile        file handle   fopen  csvFile   r        while   feof  file handle               line of text     fgetcsv  file handle  1024             fclose  file handle       return  line of text         Set path to CSV file  csvFile    test csv     csv   getdata  csvFile   echo   lt pre gt    print r  csv   echo   lt  pre gt     Array        0    gt  Array                        0    gt  Project              1    gt  Date              2    gt  User              3    gt  Activity              4    gt  Issue              5    gt  Comment              6    gt  Hours                 1    gt  Array                        0    gt  test              1    gt  04 30 2015              2    gt  test              3    gt  test              4    gt  test              5    gt                6    gt  6 00

[php] How to create an array from a CSV file using PHP and the fgetcsv function

Examples related to php

Examples related to arrays

Examples related to csv