this question has answer here:
- php array csv conversion column headers 3 answers
how can convert 2d array csv file adding header user can upload file directly.
here array
array ( [0] => array ( [0] => 25/2/2013 [1] => 8.45 a.m [2] => 9.98 [3] => 1.23 [4] => 6.1 ) [1] => array ( [0] => 25/2/2013 [1] => 8.46 a.m [2] => 9.02 [3] => 1.75 [4] => 1.75 ) ) and want output
date time value1 value2 value3 (all header)
25/2/2013 8.45 a.m 9.98 1.23 6.1
25/2/2013 8.46 a.m 9.02 1.75 1.75
$header = array("date","time","value1","value2","value3"); $fp = fopen("php://output", "w"); fputcsv ($fp, $header, "\t"); foreach($array $row){ fputcsv($fp, $row, "\t"); } fclose($fp); if want trigger download client add following lines @ top.
header("content-type: text/csv"); header('content-disposition: attachment;filename=mycoolfile.csv');
Comments
Post a Comment