php导出数据为CSV文件DEMO
代码示例:
private 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"); } private function _array2csv($array) { if (count($array) == 0) { return null; } $keys = array_keys(reset($array)); echo implode(‘,‘, $keys) . PHP_EOL; for ($i = 0, $j = count($array); $i < $j; $i++) { echo implode(‘,‘, $array[$i]) . PHP_EOL; } } public function saveAsCsv() { $this -> _download_send_headers("adonads_data_export_" . date("Y-m-d") . ".csv"); $ret = array( array( ‘id‘ => 1, ‘name‘ => ‘hello‘ ), array( ‘id‘ => 2, ‘name‘ => ‘world‘ ), array( ‘id‘ => 3, ‘name‘ => ‘good‘ ), ); $this -> _array2csv($ret); die(); }
当然还有用fputcsv的,但我试了一下效果不太好。
郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。