Flip values in array to display them in column instead of row via csv

Question

<?php
// output headers so that the file is downloaded rather than displayed
 header('Content-type: text/csv');
 header('Content-Disposition: attachment; filename="csv.csv"');
 
// do not cache the file
 header('Pragma: no-cache');
 header('Expires: 0');
 
// create a file pointer connected to the output stream
 $file = fopen('php://output', 'w');
 
// send the column headers
 fputcsv($file, array('Filepath', 'Folders', 'Date'));
 
// data
  
  $shopurl = "https://www.example.com/";
 
 $scanner = new RecursiveIteratorIterator(new RecursiveDirectoryIterator('.'));
 
 $Fpath = array(); 
 $Folders = array(); 
 $Date = array(); 
 
  foreach ($scanner as $fileInfo) {
  
      if ($fileInfo->isDir()){ 
          continue;
      }
   
   $filepath = substr($fileInfo->getPathname(), 2);
   $cur_dir = explode('/', getcwd());
   
      $Fpath[] = $shopurl . $filepath;
      $Folders[] = substr(pathinfo($fileInfo->getPathname(), PATHINFO_DIRNAME), 2);
      $Date[] = date ("F d Y H:i:s.", filemtime($fileInfo));
  
  }

 $data = array($Fpath, $Folders, $Date);
 
 
// output each row of the data
 foreach ($data as $column)
 {
  fputcsv($file, $column);
 }
 
 exit();

With the code above I tried to get a csv with three columns. The output of the arrays look like:

Array
(
    [0] => Array
        (
            [0] => https://www.example.com/GHI/123/new.php
            [1] => https://www.example.com/ABC/123.php
            [2] => https://www.example.com/output.php
            [3] => https://www.example.com/csv.php
        )

    [1] => Array
        (
            [0] => GHI/123
            [1] => ABC
            [2] => 
            [3] => 
        )

    [2] => Array
        (
            [0] => April 12 2018 11:15:03.
            [1] => April 13 2018 10:28:30.
            [2] => April 13 2018 12:36:16.
            [3] => April 13 2018 12:32:10.
        )

)

So the problem right now is that all filepaths are displayed in the first array / row, the folder names are in second and date in last. To get the arrays correctly displayed in csv I need to have for each array / row the three values (filepath, folder, date).

I tried to get it done with array_flip but it doesn't work. Maybe someone has an advice. Thanks!

You must not have read the `array_flip()` docs if you thought it would do what you want to do. And you're not getting *four* columns? There are 4 elements in your array. — Jay Blanchard, Apr 13 '18 at 12:58
Darn it @JayBlanchard I was going to post a smart condensed script without all the needless variable declarations and surplus loops. Oh well, you're not wrong. — mickmackusa, Apr 13 '18 at 13:20
@Rob my advice to you is to only use one loop, don't declare single-use variables, and don't declare variables that you don't use. — mickmackusa, Apr 13 '18 at 13:22
@Rob ... I reckon something like this is rather direct / clean / sensible: https://3v4l.org/jqDaP — mickmackusa, Apr 13 '18 at 13:41
@JayBlanchard Wait a sec... that dupe link is dead wrong. The op doesn't want to kick the first element to the back, Rob wants to "transpose". Perhaps switch to: https://stackoverflow.com/q/36493112/2943403 or https://stackoverflow.com/q/43948739/2943403 (there are heaps to choose from) — mickmackusa, Apr 13 '18 at 13:52
@Jay I don't have the privilege to add to your dupe link list; please improve your closure. — mickmackusa, Apr 13 '18 at 13:57

score 2 · Answer 1 · answered Apr 13 '18 at 13:03

You could try a different approach on $data stracture

    $data = [];

        foreach ($scanner as $key => $fileInfo) {

            if ($fileInfo->isDir()){ 
                continue;
            }

            $filepath = substr($fileInfo->getPathname(), 2);
            $cur_dir = explode('/', getcwd());

            $path = $shopurl . $filepath;
            $olders = substr(pathinfo($fileInfo->getPathname(), PATHINFO_DIRNAME), 2);
            $date = date ("F d Y H:i:s.", filemtime($fileInfo));

            $data[$key] = [$path, $olders, $data];
        }


// output each row of the data
    foreach ($data as $columns)
    {
        fputcsv($file, $columns);
    }

    fclose($file);
    exit();

mtr.web · Accepted Answer · 2018-04-13T13:42:56.253

The problem should be solvable by changing how you load the values in your first code-snippet. If you want the structure to be something like

[0] => Array
        (
            ['fpath'] => https://www.example.com/GHI/123/new.php
            ['folder'] => GHI/123
            ['date'] => April 12 2018 11:15:03.
        )
[1] => Array
        (
            ['fpath'] => https://www.example.com/GHI/123/new.php
            ['folder'] => GHI/123
            ['date'] => April 12 2018 11:15:03.
        )

Then the following should work for you:

<?php
// output headers so that the file is downloaded rather than displayed
    header('Content-type: text/csv');
    header('Content-Disposition: attachment; filename="csv.csv"');

// do not cache the file
    header('Pragma: no-cache');
    header('Expires: 0');

// create a file pointer connected to the output stream
    $file = fopen('php://output', 'w');

// send the column headers
    fputcsv($file, array('Filepath', 'Folders', 'Date'));

// data
    $scanner = new RecursiveIteratorIterator(new RecursiveDirectoryIterator('.'));
    $data = array();

    foreach ($scanner as $fileInfo) {
        $data[] = array(
                    "fpath" => "https://www.example.com/" . substr($fileInfo->getPathname(), 2),
                    "folder" => substr(pathinfo($fileInfo->getPathname(), PATHINFO_DIRNAME), 2),
                    "date" => date ("F d Y H:i:s.", filemtime($fileInfo))
                );
    }

// output each row of the data
    foreach ($data as $column)
    {
        fputcsv($file, $column);
    }

    exit();

For as long as you plan to volunteer your technical support on StackOverflow, please endeavor to always post your very best code. It will improve your skills and influence other programmers to improve theirs. — mickmackusa, Apr 13 '18 at 13:33
@mickmackusa - any better? I do not consider myself a master of PHP, but the edit at least covered most of your suggestions, and it would appear that it solved the problem, considering the OP accepted it. — mtr.web, Apr 13 '18 at 13:44

Flip values in array to display them in column instead of row via csv

2 Answers2