export database table to csv laravel

Question

Hi I am trying to export database table users to a csv file and I am using the following method in my controller:

 public function getExport()
{
    $table = User::all();
    $output='';
      foreach ($table as $row) {
          $output.=  implode(",",$row->toArray());
      }
      $headers = array(
          'Content-Type' => 'text/csv',
          'Content-Disposition' => 'attachment; filename="ExportFileName.csv"',
      );

    return Response::make(rtrim($output, "\n"), 200, $headers);
}

but when I open "ExportFileName.csv" I am getting not Columns Headers and also getting some other garbage in there that are not in the database ?

Whats the best and easy way to do this in Laravel 4

Thanks

Chris · Accepted Answer · 2014-08-26 09:41:34Z

2

You've not added the headers to the CSV. Before outputting the rows, you should do something like:

foreach ($table[0] as $column => $value) {
    $output .= "$column,";
}
rtrim($output, ",");
$output .= "\n";

(There are better ways to do that).

You'll also need to account for special characters in the values:

Wrap every value in "" to deal with commas,
Escape and quotation marks, and
Delete or replace any \ns.

answered Aug 26, 2014 at 9:41

Chris

9811 gold badge11 silver badges23 bronze badges

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

1 Comment

user3150060 Over a year ago

I found a better use , I am ganna use Laravel-Excel packages , thanks for the help

Collectives™ on Stack Overflow

export database table to csv laravel

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related