Convert array into csv

Question

How to convert an array into a CSV file   This is my array   stdClass Object         OrderList RetrieveByContactResult    gt  stdClass Object                        OrderDetails    gt  stdClass Object                                        entityId    gt  1025298                      orderId    gt  10952                      orderName    gt  testing                      statusTypeId    gt  4652                      countryCode    gt  AU                      orderType    gt  1                      invoiceNumber    gt  0                      invoiceDate    gt  0001-01-01T00 00 00                      userID AssignedTo    gt  11711                      shippingAmount    gt  8 95                      shippingTaxRate    gt  0                      shippingAttention    gt                        shippingInstructions    gt                        shippingOptionId    gt  50161                      discountCodeId    gt  0                      discountRate    gt  0                      totalOrderAmount    gt  408 45                      directDebitTypeId    gt  0                      directDebitDays    gt  0                      isRecur    gt                        nextInvoiceDate    gt  0001-01-01T00 00 00                      endRecurDate    gt  0001-01-01T00 00 00                      cycleTypeID    gt  1                      createDate    gt  2010-10-08T18 40 00                      lastUpdateDate    gt  2010-10-08T18 40 00                      deleted    gt                        products    gt  stdClass Object                                                        Product    gt  stdClass Object                                                                        productId    gt  674975                                      productCode    gt                                        productDescription    gt                                        units    gt  10                                      unitPrice    gt  39 95                                      unitTaxRate    gt  0                                      totalProductPrice    gt  399 5                                      productName    gt  Acne Clearing Gel                                                                                    addresses    gt  stdClass Object                                                        Address    gt  stdClass Object                                                                        addressTypeID    gt  8                                      addressLine1    gt  Cebu City                                      city    gt  Cebu                                      zipcode    gt  6000                                      state    gt                                        countryCode    gt  PH

User · Answer

function array 2 csv  array         csv   array        foreach   array as  item            if  is array  item                  csv     array 2 csv  item             else                csv      item                      return implode       csv        csv data   array 2 csv  array    echo   lt pre gt    print r  csv data   echo   lt  pre gt

User · Answer

Well maybe a little late after 4 years haha    but I was looking for solution to do OBJECT to CSV  however most solutions here is actually for ARRAY to CSV     After some tinkering  here is my solution to convert object into CSV  I think is pretty neat  Hope this would help someone else    resp   array    foreach   entries as  entry         row   array        foreach   entry as  key   gt   value            array push  row   value             array push  resp  implode       row      echo implode PHP EOL   resp     Note that for the  key   gt   value to work  your object s attributes must be public  the private ones will not get fetched   The end result is that you get something like this   blah blah blah blah blah blah

User · Answer

I m using the following function for that  it s an adaptation from one of the man entries in the fputscsv comments  And you ll probably want to flatten that array  not sure what happens if you pass in a multi-dimensional one           Formats a line  passed as a fields  array  as CSV and returns the CSV as a string      Adapted from http   us3 php net manual en function fputcsv php 87120      function arrayToCsv  array  amp  fields   delimiter         enclosure         encloseAll   false   nullToMysqlNull   false          delimiter esc   preg quote  delimiter             enclosure esc   preg quote  enclosure              output   array        foreach    fields as  field             if   field     null  amp  amp   nullToMysqlNull                 output      NULL               continue                        Enclose fields containing  delimiter   enclosure or whitespace         if    encloseAll    preg match         delimiter esc    enclosure esc   s      field                    output      enclosure   str replace  enclosure   enclosure    enclosure   field     enclosure                    else                output      field                       return implode   delimiter   output

User · Answer

Add some improvements based on accepted answer    PHP 7 0 Strict typing PHP 7 0 Type declaration and Return type declaration Enclosure  r   n   t Don t enclosure empty string even  encloseAll is TRUE           Formats a line  passed as a fields array  as CSV and returns the CSV as a string      Adapted from https   www php net manual en function fputcsv php 87120      function arrayToCsv array  fields  string  delimiter        string  enclosure        bool  encloseAll   false  bool  nullToMysqlNull   false   string         delimiter esc   preg quote  delimiter             enclosure esc   preg quote  enclosure              output           foreach   fields as  field            if   field     null  amp  amp   nullToMysqlNull                 output      NULL               continue                       Enclose fields containing  delimiter   enclosure or whitespace  newline          field   strval  field           if  strlen  field   amp  amp    encloseAll    preg match        delimiter esc    enclosure esc   s  r  n  t      field                   output      enclosure   str replace  enclosure   enclosure    enclosure   field     enclosure            else                output      field                       return implode  delimiter   output

User · Answer

My solution requires the array be formatted differently than provided in the question    lt        data   array          array   row 1 col 1    row 1 col 2    row 1 col 3             array   row 2 col 1    row 2 col 2    row 2 col 3             array   row 3 col 1    row 3 col 2    row 3 col 3              gt    We define our function    lt       function outputCSV  data             outputBuffer   fopen  php   output    w            foreach  data as  val                fputcsv  outputBuffer   val                     fclose  outputBuffer           gt    Then we output our data as a CSV    lt        filename    example        header  Content-type  text csv        header  Content-Disposition  attachment  filename   filename  csv        header  Pragma  no-cache        header  Expires  0         outputCSV  data     gt    I have used this with several projects  and it works well  I should note that the outputCSV code is more clever than I am  so I am sure I am not the original author  Unfortunately I have lost track of where I got it  so I can t give the credit to whom it is due

User · Answer

A slight adaptation to the solution above by kingjeffrey for when you want to create and echo the CSV within a template  Ie - most frameworks will have output buffering enabled and you are required to set headers etc in controllers        Create Some data  lt  php      data   array          array   row 1 col 1    row 1 col 2    row 1 col 3             array   row 2 col 1    row 2 col 2    row 2 col 3             array   row 3 col 1    row 3 col 2    row 3 col 3                 Create a stream opening it with read   write mode  stream   fopen  data   text plain          w         Iterate over the data  writting each line to the text stream foreach   data as  val        fputcsv  stream   val         Rewind the stream rewind  stream       You can now echo it s content echo stream get contents  stream       Close the stream  fclose  stream     Credit to Kingjeffrey above and also to this blog post where I found the information about creating text streams

User · Answer

The accepted answer from Paul is great  I ve made a small extension to this which is very useful if you have an multidimensional array like this  which is quite common    Array        0    gt  Array                        a    gt   a               b    gt   b                  1    gt  Array                        a    gt   a2               b    gt   b2                  2    gt  Array                        a    gt   a3               b    gt   b3                  3    gt  Array                        a    gt   a4               b    gt   b4                  4    gt  Array                        a    gt   a5               b    gt   b5                 So I just took Paul s function from above           Formats a line  passed as a fields  array  as CSV and returns the CSV as a string      Adapted from http   us3 php net manual en function fputcsv php 87120      function arrayToCsv  array  amp  fields   delimiter         enclosure         encloseAll   false   nullToMysqlNull   false          delimiter esc   preg quote  delimiter             enclosure esc   preg quote  enclosure              output   array        foreach    fields as  field             if   field     null  amp  amp   nullToMysqlNull                 output      NULL               continue                        Enclose fields containing  delimiter   enclosure or whitespace         if    encloseAll    preg match         delimiter esc    enclosure esc   s      field                    output      enclosure   str replace  enclosure   enclosure    enclosure   field     enclosure                    else                output      field                       return implode   delimiter   output        And added this   function a2c  array   glue     n          ret           foreach   array as  item             ret     arrayToCsv  item             return implode  glue   ret       So you can just call     csv   a2c  array     If you want a special line ending you can use the optional parameter  glue  for this

[php] Convert array into csv

Examples related to php

Examples related to arrays

Examples related to csv