我正在努力将数据导出为csv,它下载的只有第一个9条记录,总共10个excel第一个是标题和9条记录,然后我想从Db导出整个表不知道出了什么问题这里是下面的方法
public function ExportAll(){
$student = Students::all();
$temp = tmpfile();
$heading = array('Name', 'Group');
fputcsv($temp, $heading);
foreach($student as $row) {
fputcsv($temp, array($row['name'],$row['group']));
}
fseek($temp, 0);
echo fread($temp, 1024);
header('Content-Type: text/csv; charset=utf-8');
header('Content-Disposition: attachment; filename=Student.csv' );
fclose($temp);
die;
}
它只下载一行,我想用这个方法下载整个表请帮忙修复路由为
Route::get('/student/ExportAll', 'StudentController@ExportAll');
这里我有一个导出为
的链接<a href="/student/ExportAll">Export</a>
每次通过数组覆盖$values
。
$values = [];
foreach($student as $row) {
$values[] = array($row['name'],$row['group']);
}