turning db data into csv with header row in php

Question

I have a script that turns a database query result into a csv file. The csv file's first row needs to be the field names of what's defined in the query. Here's what I have so far:

$fp = fopen('report.csv', 'w');
$column_names = array();
foreach($dbh->query($base_query, PDO::FETCH_ASSOC) as $row) {
  if (empty($column_names)) {
    $column_names = array_keys($row);
    fputcsv($fp, $column_names);
  }
  // additional processing omitted ...
  fputcsv($fp, $row);
}
fclose($fp);

Is there a nicer way to populate the column names in the first row of csv (do away with the if condition)? Perhaps do it outside of the loop? or have PDO output the column names before fetching data? Thanks.

Your Common Sense · Accepted Answer · 2013-07-30 13:39:24Z

1

There is always a nicer way, if you separate different operations from each other.

//database part
$data = $dbh->query($base_query)->fetchAll();

// header part
$fp = fopen('report.csv', 'w');
$column_names = array_keys($data[0]);
fputcsv($fp, $column_names);

// body part
foreach($data as $row) {
  // additional processing omitted ...
  fputcsv($fp, $row);
}

answered Jul 30, 2013 at 13:39

Your Common Sense

158k42 gold badges226 silver badges373 bronze badges

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

Comments

Jason McCreary · Accepted Answer · 2013-07-30 13:33:46Z

0

Is there a nicer way to populate the column names in the first row of csv (do away with the if condition)?

No.

Perhaps do it outside of the loop?

Your code is inferring the column names from the keys of the fetched row and as such needs to be inside the loop.

PDO output the column names before fetching data?

This would require an additional query or storing metadata otherwise. Both of which are extra work.

answered Jul 30, 2013 at 13:33

Jason McCreary

73.3k23 gold badges140 silver badges177 bronze badges

Collectives™ on Stack Overflow

turning db data into csv with header row in php

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