php - writing column headers to CSV

Question

I have an array called $contents which I loop through and write to CSV. I'd like to write column headers to the top of the CSV but I can only write to each row generated from my $contents array. What am I doing wrong?

PHP

$contents = array(date("Y").",".date("m").","."1st half,".$client.",".$resultcasa1.",".$billable_hours);

header('Content-Type: text/csv; charset=utf-8');
header('Content-Disposition: attachment; filename=fms_usage.csv');

echo "Year, Month, Period, Client, Minutes Used, Billable Hours,";

$file = fopen("php://output", "w");

foreach($contents as $content){
     fputcsv($file,explode(',',$content));
}
fclose($file);

Output

Year  Month  Period  Client  Minutes Used  Billable Hours    2014   6   1st half    [email protected]  0   0
Year  Month  Period  Client  Minutes Used  Billable Hours    2014   6   1st half    [email protected]   0   0
Year  Month  Period  Client  Minutes Used  Billable Hours    2014   6   1st half    [email protected] 0   0
Year  Month  Period  Client  Minutes Used  Billable Hours    2014   6   1st half    tim 0   0

Phil · Accepted Answer · 2014-06-12 05:54:40Z

10

You can use the same fputcsv function to output your headers too

Something like this...

$contents = [
  [2014, 6, '1st half', '[email protected]', 0, 0],
  [2014, 6, '1st half', '[email protected]', 0, 0],
  [2014, 6, '1st half', '[email protected]', 0, 0],
  [2014, 6, '1st half', 'tim', 0, 0]
];

$headers = ['Year', 'Month', 'Period', 'Client', 'Minutes Used', 'Billable Hours'];

$file = fopen("php://output", "w");

fputcsv($file, $headers);
foreach($contents as $content){
    fputcsv($file, $content);
}
fclose($file);

Demo here ~ https://eval.in/161434

answered Jun 12, 2014 at 5:54

Phil

166k25 gold badges265 silver badges269 bronze badges

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

Comments

Vincent Decaux · Accepted Answer · 2014-06-12 05:58:05Z

4

Or using fputcsv function :

$headers = "Year, Month, Period, Client, Minutes Used, Billable Hours";

$file = fopen("php://output", "w");

fputcsv($file, explode(', ', $headers));

....

answered Jun 12, 2014 at 5:58

Vincent Decaux

10.9k7 gold badges67 silver badges102 bronze badges

Comments

Vishal · Accepted Answer · 2014-06-12 06:00:27Z

1

$contents = array(date("Y").",".date("m").","."1st half,".$client.",".$resultcasa1.",".$billable_hours);

header('Content-Type: text/csv; charset=utf-8');
header('Content-Disposition: attachment; filename=fms_usage.csv');

$h = "Year, Month, Period, Client, Minutes Used, Billable Hours";

$file = fopen("php://output", "w");

fputcsv($file,explode(', ', $h));

foreach($contents as $content){
     fputcsv($file,explode(', ', $content));
}
fclose($file);

answered Jun 12, 2014 at 6:00

Vishal

1081 silver badge9 bronze badges

1 Comment

Phil Over a year ago

The second argument to fputcsv should be an array. You are passing a string in both instances

Collectives™ on Stack Overflow

php - writing column headers to CSV

3 Answers 3

Comments

Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Related