Add Column Headers To a CSV File With PHP

Question

I am trying to convert a php/mysql generated table into a downloadable csv file. When a user enters search parameters, a call is made to a mysql table and results returned as table.

I used the solution offered in this thread and it works fabulously: Create a CSV File for a user in PHP

I am able to allow users to save or view the results as a csv file. the problem I am having is I'm not sure how to add column headers to the file. For example, the results that are returned are in the following format: $result[x]['office'], $result[x]['user'], etc..., but I also want to add column titles like "Office" and "User" so that anyone looking at the csv file immediately knows what the data means.

This is the function that generates the csv file:

    header("Content-type: text/csv");
    header("Content-Disposition: attachment; filename=$file.csv");
    header("Pragma: no-cache");
    header("Expires: 0");
    outputCSV($data);

function outputCSV($data) {
        $outstream = fopen("php://output", "a");
        function __outputCSV(&$vals, $key, $filehandler) {
            fputcsv($filehandler, $vals); // add parameters if you want
        }
        array_walk($data, "__outputCSV", $outstream);
        fclose($outstream);
    }

I have tried creating the following function, and then calling it right before I call outputCSV, but it is not successful:

function create_file_header()
{       
    $headers = 'Office, User, Tag, Value';
    $fp = fopen("php://output", "w");
    file_put_contents("$file.csv", $headers);
    fclose($fp);
}

Any help is greatly appreciated.

Open the file in 'w' mode php.net/manual/en/function.fopen.php — CBusBus
– CBusBus, Commented Feb 15, 2012 at 17:36

Francis Avila · Accepted Answer · 2012-02-15 17:51:10Z

12

To create headers, you should just prepend a header row array and use fputcsv as normal.

You don't talk about the format of $data, but if it's an associative array you can do this for a generic solution:

function toCSV($data, $outstream) {
    if (count($data)) {
        // get header from keys
        fputcsv($outstream, array_keys($data[0]));
        // 
        foreach ($data as $row) {
            fputcsv($outstream, $row);
        }
    }
}

I'm don't see the benefit of array_walk() over a foreach loop.

answered Feb 15, 2012 at 17:51

Francis Avila

31.8k7 gold badges63 silver badges99 bronze badges

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

Comments

hair raisin · Accepted Answer · 2012-02-15 17:48:00Z

2

Do this before calling outputCSV:

array_unshift($data, array('Office', 'User', 'Tag', 'Value'));

Or, if the elements of $data are associative arrays, this would be more dynamic:

array_unshift($data, array_keys($data[0]));

edited Feb 15, 2012 at 17:48

answered Feb 15, 2012 at 17:40

hair raisin

2,62817 silver badges13 bronze badges

1 Comment

RCNeil Over a year ago

This is a genius solution! I ended up using array_push() in a slightly different case, but this is perfect for someone getting the header columns in MySQL by using fetch_fields() and then appending more fields to them. Kudos.

seanbreeden · Accepted Answer · 2012-02-15 17:41:56Z

0

Couldn't you just put it in the outputCSV function?

header("Content-type: text/csv");
header("Content-Disposition: attachment; filename=$file.csv");
header("Pragma: no-cache");
header("Expires: 0");
outputCSV($data);

function outputCSV($data) {
    $outstream = fopen("php://output", "a");

    $headers = 'Office, User, Tag, Value';
    fwrite($outstream,$headers);

    function __outputCSV(&$vals, $key, $filehandler) {
        fputcsv($filehandler, $vals); // add parameters if you want
    }
    array_walk($data, "__outputCSV", $outstream);
    fclose($outstream);
 }

answered Feb 15, 2012 at 17:41

seanbreeden

6,1075 gold badges39 silver badges47 bronze badges

1 Comment

IIIOXIII Over a year ago

Just a note. In my experience, I needed to add ."\r\n" at the end of $headers = 'Office, User, Tag, Value' line, i.e. $headers = 'Office, User, Tag, Value'."\r\n" or the first row would be appended to the header row without line break.

webbiedave · Accepted Answer · 2012-02-15 17:46:13Z

0

Add an optional $headers parameter to your outputCSV function. If your code passes them, they will be prepended to the csv array:

outputCSV($data, array('Office', 'User'));

//

function outputCSV($data, $headers = null) {
    $outstream = fopen("php://output", "a");
    function __outputCSV(&$vals, $key, $filehandler) {
        fputcsv($filehandler, $vals); // add parameters if you want
    }
    if ($headers) {
        $data = array_merge(array($headers), $data);
    }
    array_walk($data, "__outputCSV", $outstream);
    fclose($outstream);
}

answered Feb 15, 2012 at 17:46

webbiedave

49k8 gold badges92 silver badges104 bronze badges

Collectives™ on Stack Overflow

Add Column Headers To a CSV File With PHP

4 Answers 4

Comments

1 Comment

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related