Laravel Export to csv

I am generating CSV file with extension of .csv


Here is my simple code:


  public function download(){

        $headers = [
                'Cache-Control'       => 'must-revalidate, post-check=0, pre-check=0'
            ,   'Content-type'        => 'application/vnd.ms-excel; charset=utf-8'
            ,   'Content-Disposition' => 'attachment; filename=users.csv'
            ,   'Expires'             => '0'
            ,   'Pragma'              => 'public'
        ];

        $users = Users::where('status', '=', '1')->get();
        $columns = array('No','User ID','Name','Email','Mobile','Register Date');
    
        $callback = function() use ($users, $columns)
        {
            $file = fopen('php://output', 'w');
            fputcsv($file, $columns);
    
            foreach($users as $index => $user) {
               
                fputcsv($file, array($index+1,$user->id, $user->name,$user->email,$user->mobile,date('d/m/Y', strtotime($user->created_at))));
            }
            fclose($file);
        };
        
        return Response::stream($callback, 200, $headers);
    }

No comments:

Post a Comment

how to call ssh from vs code

 To call SSH from VS Code, you can use the built-in Remote Development extension. This extension allows you to open a remote folder or works...