Laravel Chunk Results to CSV

outputCSV.php

<?php
/*
*  Chunk through result set and output as CSV file in browser.
*/
function outputCSV($columns, $query, $chunkSize = 200) {
	header("Content-type: text/csv");
	header("Content-Disposition: attachment; filename='export-" . date("YmdHis") . ".csv");
	header("Pragma: no-cache");
	header("Expires: 0");
		
	$output = fopen("php://output", "w");
	fputcsv($output, $columns);

	$query->select($columns)->chunk($chunkSize, function($rows) use(&$output) {
		foreach ($rows as &$row) {
			fputcsv($output, (array) $row);
		}
	});
	
	fclose($output);
}
	
// Eloquent or Fluent DB query
$query = DB::table('users');
$columns = ['id', 'name', 'email'];
outputCSV($columns, $query);