Adding the headers when creating a csv file PhP, SQL

Question

I have the following code:

PhP

function write_csv($filename, $rows) {
  $file = fopen($filename, 'w');
  while($row = mysqli_fetch_assoc($rows)) :
    fputcsv($file, $row);
  endwhile;

  fclose($file);
 }

 // $db is a class I have and this function just returns a SQL result set
 $result_set = $db->run_query("SELECT * FROM Users");

 write_csv('../MOCK_USERS_DATA.csv', $result_set);

I am correctly getting a created CSV file with the the users information for example

1,greg,mason,407-356-3322,[email protected]
2,derek,herd,407-234-4352,[email protected]

etc...

My question is how do I get the headers from the table as the first row in my CSV file. I am new to creating CSV files and am stuck on getting that first row of headers in that file that match the name of the column in my database. Any suggestions?

Jan Sršeň · Accepted Answer · 2017-01-11 15:43:57Z

Easy export to CSV

// output headers so that the file is downloaded rather than displayed
header('Content-Type: text/csv; charset=utf-8');

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

// output the column headings -> trim is used for lang translates
// or use SQL query to get table columns headers name
fputcsv($output, array(
    trim('Product name'),
    trim('Pellet number'),
    trim('Quantity'),
    trim('Date')
        ), ";");
// use foreach
***********
// force download  
header("Content-Type: application/force-download");
header("Content-Type: application/octet-stream");
header("Content-Type: application/download");

// disposition / encoding on response body
header('Content-Disposition: attachment; filename=pelletlist-' . time() . '.csv');
header("Content-Transfer-Encoding: binary");
header("Cache-control: private"); //use this to open files directly
header('Expires: 0');
header("Pragma: no-cache");
header("Connection: close");
fclose($output);
exit();

for load column name from db use:

SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'my_database' AND TABLE_NAME = 'my_table';

or

SHOW COLUMNS FROM my_table;

Collectives™ on Stack Overflow

Adding the headers when creating a csv file PhP, SQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related