Turning a nested associative array in php into a CSV file

Question

I working on a PHP issue and have an associative array that looks like this:

(
  [2019-03-22T2:26:03-04:00] => Array
      (
          [0] => Array
              (
                  [A] => 1
                  [B] => 1
                  [C] => 2
              )

      )

  [2019-03-23T2:27:04-04:00] => Array
      (
          [0] => Array
              (
                  [A] => 1
              )

      )
)

I'm trying to turn this data into a CSV that looks like this:

NAME                              COUNT
2021-07-15T10:46:16-04:00
      A                             1
      B                             1
      C                             2
2021-07-15T10:46:17-04:00
      A                             1

I've done this before, going from an array to csv, with a simple associative array but getting it in the format above is not working for me. This is the code that I have tried:

The variable $statArray holds the array that I need to be on a CSV.

  $fp = fopen('test.csv', 'w');
  foreach ($statArray as $fields)
  {
    foreach ($key as $v)
    {
        fputcsv($fp, $v);
    }
  }

Thank you for any help.

AbraCadaver · Accepted Answer · 2021-07-15 19:27:54Z

1

That's an odd format, but you need to write the main array key and then get the nested keys and values and write those:

foreach ($statArray as $date => $array)
{
    fputcsv($fp, [$date]);  //write main key
    
    foreach ($array as $values)
    {
        foreach ($values as $name => $count)
        {
            fputcsv($fp, [$name, $count]); //write key and value
        }
    }
}

This might make more sense:

2021-07-15T10:46:16-04:00    A    1
2021-07-15T10:46:16-04:00    B    1
2021-07-15T10:46:16-04:00    C    2
2021-07-15T10:46:17-04:00    A    1

If so then:

foreach ($statArray as $date => $array)
{        
    foreach ($array as $values)
    {        
        foreach ($values as $name => $count)
        {
            fputcsv($fp, [$date, $name, $count]); //write date and key and value
        }
    }
}

Either way, you state CSV but it looks like you are showing tabs not commas. If so you would need:

fputcsv($fp, [$date, $name, $count], "\t");

edited Jul 15, 2021 at 19:27

answered Jul 15, 2021 at 19:11

AbraCadaver

79.2k7 gold badges75 silver badges91 bronze badges

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

3 Comments

Sammitch Over a year ago

IMHO having only fputcsv($fp, [$date, $name, $count]); in the inner loop would be a far sane-r CSV output. But if this is what OP really wants...

AbraCadaver Over a year ago

Edited, forgot a nesting.

ravenUSMC Over a year ago

Thank you! I got it!

Collectives™ on Stack Overflow

Turning a nested associative array in php into a CSV file

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related