PHP Array to CSV

Question

I m trying to convert an array of products into a CSV file  but it doesn t seem to be going to plan  The CSV file is one long line  here is my code    for  i 0  i lt count  prods   i       sql    SELECT   FROM products WHERE id       prods  i        result    mysqli- gt query  sql    info    result- gt fetch array         header        for  i 0  i lt count  info   i               row    info  i         line           for  b 0  b lt count  row   b                value    row  b                                                 if      isset   value           value                                  value     t                     else                        value   str replace                value                 value          value           t                       line     value                 data    trim   line       n      data   str replace    r          data     if    data            data     n 0  Records Found  n                              header  Content-type  application octet-stream    header  Content-Disposition  attachment  filename your desired name xls    header  Pragma  no-cache    header  Expires  0     array to CSV  data     function array to CSV  data                 outstream   fopen  php   output    r             fputcsv  outstream   data                     rewind  outstream            csv   fgets  outstream           fclose  outstream           return  csv          Also  the header doesn t force a download  I ve been copy and pasting the output and saving as  csv   EDIT  PROBLEM RESOLVED    If anyone else was looking for the same thing  found a better way of doing it    num   0   sql    SELECT id  name  description FROM products   if  result    mysqli- gt query  sql          while  p    result- gt fetch array                prod  num   id               p  id              prod  num   name             p  name              prod  num   description      p  description              num                      output   fopen  php   output   w   or die  Can t open php   output    header  Content-Type application csv     header  Content-Disposition attachment filename pressurecsv csv     fputcsv  output  array  id   name   description     foreach  prod as  product        fputcsv  output   product     fclose  output  or die  Can t close php   output

User · Answer

In my case  my array was multidimensional  potentially with arrays as values   So I created this recursive function to blow apart the array completely   function array2csv  array   amp  title   amp  data        foreach  array as  key   gt   value                  if is array  value                  title     key                     data                          array2csv  value   title   data             else                title     key                     data           value                             Since the various levels of my array didn t lend themselves well to a the flat CSV format  I created a blank column with the sub-array s key to serve as a descriptive  intro  to the next level of data   Sample output   agentid     fname           lname      empid    totals  sales   leads   dish    dishnet top200 plus top120  latino  base packages G-adriana   ADRIANA EUGENIA PALOMO PAIZ 886                0    19              0         0         0         0      0   You could easily remove that  intro   descriptive  column  but in my case I had repeating column headers  i e  inbound leads  in each sub-array  so that gave me a break title preceding the next section   Remove    title     key         data                after the is array   to compact the code further and remove the extra column   Since I wanted both a title row and data row  I pass two variables into the function and upon completion of the call to the function  terminate both with PHP EOL    title    PHP EOL   data    PHP EOL    Yes  I know I leave an extra comma  but for the sake of brevity  I didn t handle it here

User · Answer

This is a simple solution that exports an array to csv string   function array2csv  data   delimiter         enclosure         escape char                f   fopen  php   memory    r         foreach   data as  item            fputcsv  f   item   delimiter   enclosure   escape char             rewind  f       return stream get contents  f       list   array       array  aaa    bbb    ccc    dddd        array  123    456    789        array   aaa      bbb       var dump array2csv  list

User · Answer

I know this is old  I had a case where I needed the array key to be included in the CSV also  so I updated the script by Jesse Q to do that  I used a string as output  as implode can t add new line  new line is something I added  and should really be there    Please note  this only works with single value arrays  key  value   but could easily be updated to handle multi-dimensional  key  array      function arrayToCsv  array  amp  fields   delimiter         enclosure         encloseAll   false   nullToMysqlNull   false          delimiter esc   preg quote  delimiter             enclosure esc   preg quote  enclosure              output           foreach    fields as  key   gt   field             if   field     null  amp  amp   nullToMysqlNull                 output                   continue                        Enclose fields containing  delimiter   enclosure or whitespace         if    encloseAll    preg match         delimiter esc    enclosure esc   s      field                    output     key               output     delimiter               output     enclosure   str replace  enclosure   enclosure    enclosure       field     enclosure               output    PHP EOL                    else                output     key               output     delimiter               output     field               output    PHP EOL                       return   output

User · Answer

Arrays of data are converted into csv  text csv  format by built in php function fputcsv takes care of commas  quotes and etc   Look at https   coderwall com p zvzwwa array-to-comma-separated-string-in-php http   www php net manual en function fputcsv php

User · Answer

It worked for me     f fopen  php   memory   w      header array  asdf    asdf   asd   Calasdflee   Start Time   End Time            fputcsv  f  header    fputcsv  f  header    fputcsv  f  header     fseek  f 0    header  content-type text csv      header  Content-Disposition  attachment  filename       filename           fpassthru  f

User · Answer

Instead of writing out values consider using fputcsv      This may solve your problem immediately

User · Answer

Try using   PHP EOL   To terminate each new line in your CSV output   I m assuming that the text is delimiting  but isn t moving to the next row   That s a PHP constant  It will determine the correct end of line you need   Windows  for example  uses   r n   I wracked my brains with that one when my output wasn t breaking to a new line   how to write unified new line in PHP

[php] PHP Array to CSV

Examples related to php

Examples related to csv