Creating a laravel txt with some data from database in LARAVEL

Question

how can i create a method in laravel in my USER controller that when i click on a button in the view it will download a txt file with this info tha its generating from this query

User::select('id','name','lastname')
            ->orderBy('id','desc')
            ->take(100)
            ->get();

Printing these 3 fields of Users table in 3 column in the txt file. If someone can guide me doing this via jquery-ajax it would be perfect !

UPDATED my problem is solved thanks to the guy below !

check this : laracasts.com/discuss/channels/general-discussion/… — Drone
– Drone, Commented Jun 28, 2016 at 12:33

Gian Tomakin · Accepted Answer · 2016-06-28 16:41:47Z

2

//controller

public function downloadTxt()
{
  $txt = "";
  $datas = User::select('id','name','lastname')
            ->orderBy('id','desc')
            ->take(100)
            ->get();
  foreach($datas as $data){
  $txt .= $data['id'].'|'.$data['name'].'|'.$data['lastname'].PHP_EOL;
  }
  $txtname = 'mytxt.txt';
     $headers = ['Content-type'=>'text/plain', 'test'=>'YoYo', 'Content-Disposition'=>sprintf('attachment; filename="%s"', $txtname),'X-BooYAH'=>'WorkyWorky','Content-Length'=>sizeof($datas)];
        return \Response::make($txt , 200, $headers );

}

edited Jun 28, 2016 at 16:41

answered Jun 28, 2016 at 13:58

Gian Tomakin

1931 silver badge5 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

JP.dev Over a year ago

i need all of them to show them and in three columns if thats possible

JP.dev Over a year ago

Non-ISO extended-ASCII text => can i do this format in my file ?

Collectives™ on Stack Overflow

Creating a laravel txt with some data from database in LARAVEL

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related