通过PHP导出为CSV

我个人使用此功能从任何数组创建CSV内容。

function array2csv(array &$array){   if (count($array) == 0) {     return null;   }   ob_start();   $df = fopen("php://output", 'w');   fputcsv($df, array_keys(reset($array)));   foreach ($array as $row) {      fputcsv($df, $row);   }   fclose($df);   return ob_get_clean();}

然后，您可以使用户使用以下方式下载该文件：

function download_send_headers($filename) {    // disable caching    $now = gmdate("D, d M Y H:i:s");    header("Expires: Tue, 03 Jul 2001 06:00:00 GMT");    header("Cache-Control: max-age=0, no-cache, must-revalidate, proxy-revalidate");    header("Last-Modified: {$now} GMT");    // 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={$filename}");    header("Content-Transfer-Encoding: binary");}

用法示例：

download_send_headers("data_export_" . date("Y-m-d") . ".csv");echo array2csv($array);die();