ThinkSSL🔒 一键申购 5分钟快速签发 30天无理由退款 购买更放心 广告
可能用到的laravel命令行: ``` php artisan make:controller ExportExcelController php artisan make:migration create_exports_table --create=exports ``` 方法1: ``` <?php namespace App\Exports; use App\Media; use Illuminate\Contracts\View\View; use Maatwebsite\Excel\Concerns\FromView; class MediasExport implements FromView { public function view(): View { $medias = Media::where('user', '1')->orderBy('created_at', 'asc')->get(); // desc, asc return view('export', compact('medias')); } } ``` 方法2: ``` <?php namespace App\Exports; use App\Media; use Maatwebsite\Excel\Concerns\FromCollection; class MediasExport implements FromCollection { /** * @return \Illuminate\Support\Collection */ public function collection() { return Media::where('display_status', '1')->orderBy('created_at', 'asc')->get(); // asc, desc } } ``` 参考: https://github.com/Maatwebsite/Laravel-Excel