php arrays to CSV

Question

I have an array of arrays

$numbers= array(3) {
  [months]=>
    array(3) {
      ["1"]=>
      string(7) "Jan"
      ["2"]=>
      string(7) "Feb"
     ["3"]=>
     string(7) "Mar"
  }
[dates]=>
  array(3) {
    ["1"]=>
    string(7) "12th"
    ["2"]=>
    string(7) "19th"
    ["3"]=>
    string(7) "22nd"
 }
  [people]=>
  array(3) {
    ["1"]=>
    string(7) "Bill"
    ["2"]=>
    string(7) "Ted"
    ["3"]=>
    string(7) "Gary"
 }
 }

I want to write the contents of these arrays into a CSV file in the form of a table so I get an output like:

 months,  dates, people 
 Jan,     12th,   Bill
 Feb,     19th,   Ted
 Mar,     22nd,   Gary

I want to try and put it directly from the array into the CSV in one move it it's possible but I can't find a way to do it without cutting it up.

fputcsv() might help, but we're not going to write it for you. Personally, if the array is that small, I'd be inclined to use the SPL MultipleIterator to "transpose" the arrays — Mark Baker
– Mark Baker, Commented Jan 9, 2014 at 17:38
Note: CSV stands for "Comma-separated values". if you're using CSV for a reason you might want to separate your values with commas OR just use a simple txt file — Itay Gal
– Itay Gal, Commented Jan 9, 2014 at 17:40
Since your arrays are the columns and the standard functions work by rows you probably need to work this manually through loops. — EkriirkE
– EkriirkE, Commented Jan 9, 2014 at 17:40
@MarkBaker the arrays aren't small the example is just to try and make sense of how I want the output to look rather than indicative of what it actually does. — alexandercannon
– alexandercannon, Commented Jan 9, 2014 at 17:59

Bram · Accepted Answer · 2014-01-09 17:55:00Z

1

<?php
// transform the array
$keys = array_keys($numbers);
array_unshift($numbers, null);
$output = call_user_func_array('array_map', $numbers);
array_unshift($output, $keys);

// from php.net
$fp = fopen('file.csv', 'w');

foreach ($output as $fields) {
    fputcsv($fp, $fields);
}

fclose($fp);

answered Jan 9, 2014 at 17:55

Bram

4,55225 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mark Baker · Accepted Answer · 2014-01-09 17:48:09Z

1

$mi = new MultipleIterator();
$headers = array();
foreach($numbers as $header => $data) {
    $mi->attachIterator(new ArrayIterator($data));
    $headers[] = $header;
}

$fh = fopen('myfile.csv', 'w');
fputcsv($fh, $headers);
foreach($mi as $values) {
    fputcsv($fh, $values);
}
fclose($fh);

answered Jan 9, 2014 at 17:48

Mark Baker

213k34 gold badges354 silver badges390 bronze badges

Collectives™ on Stack Overflow

php arrays to CSV

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related