I am trying to export db rows using fputcsv() in csv file. how i can add heading on first, center align then columns then data my code works well without heading. I know there is many api's but is this possible with in my code.
Here is my code:-
Enquiry Report
id name class func
1 rk ba call()
2 bk bd that()
function exportdata_to_excel($details) {
// filename for download
$filename = date("Y-m-d").".csv";
header('Content-Type: text/csv');
header("Content-Disposition: attachment; filename=\"$filename\"");
$out = fopen("php://output", 'w');
$flag = false;
//$result = $orderDetails;
while($row = mysql_fetch_assoc($details)) {
$arr =array('Enquiry id'=>$row['id'],'Date'=>$row['created_on'],'Name'=>$row['name'], 'Email'=>$row['email'], 'Telephone'=>$row['telephone'], 'Customer Request'=>$row['customer_request'], 'Special Request'=>$row['special_request']);
if(!$flag) {
// display field/column names as first row
fputcsv($out, array_keys($arr), ',', '"');
$flag = true;
}
fputcsv($out, array_values($arr), ',', '"');
}
fclose($out);
exit();
}
The fputcsv() function in PHP is an inbuilt function which is used to format a line as CSV(comma separated values) file and writes it to an open file.
This worked for me.
function downloadCSV($data)
{
$filename = date("Y-m-d").".csv";
header('Content-type: application/csv');
header('Content-Disposition: attachment; filename=' . $filename);
header("Content-Transfer-Encoding: UTF-8");
$f = fopen('php://output', 'a');
fputcsv($f, array_keys($data[0]));
foreach ($data as $row)
{
fputcsv($f, $row);
}
fclose($f);
}
Try this after opening the file, you want to write in e.g. i want to write a file at below path:
$fp = fopen('csvfiles/myfile.csv','w')
You have to enter headers separately, so for this make an array of headers like:
$csv_fields=array();
$csv_fields[] = 'Enquiry id';
$csv_fields[] = 'Date';
$csv_fields[] = 'Name';
$csv_fields[] = 'Email';
$csv_fields[] = 'Telephone';
$csv_fields[] = 'Customer Request';
$csv_fields[] = 'Special Request';
After making headers add these headers to the file.
fputcsv($fp, $csv_fields);
while($row = mysql_fetch_assoc($details)) {
fputcsv($fp,$row);
}
fclose($fp);
Also add following headers on top so that file can be viewed easily:
header("content-type: application/force-download");
header('Content-Type: application/csv');
header('Pragma: no-cache');
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With