Breaking News: Grepper is joining You.com. Read the official announcement!

laravel error 500 when export data to csv

vickzkater answered on June 13, 2023 Popularity 1/10 Helpfulness 3/10

answer laravel error 500 when export data to csv

laravel error 500 when export data to csv

Comment

1) Set appropriate PHP configuration: Adjust the PHP configuration settings to handle large datasets. Modify the following settings in your php.ini file or within your PHP script:

ini_set('memory_limit', '512M'); // or higher if needed
set_time_limit(0); // to prevent script timeout

2) Open and write to the CSV file: Open a file handle using fopen to create the CSV file and use fwrite or fputcsv to write data to the file. It's recommended to use the fputcsv function as it automatically handles special characters and formatting. And use flush and buffer data: To avoid memory issues when exporting large datasets, periodically flush and buffer the data to disk. This ensures that the data is written to the file and cleared from memory. Here's an example of flushing the buffer after writing a certain number of rows:

$file = fopen('data.csv', 'w');
$rowCount = 0;
foreach ($data as $row) {
    fputcsv($file, $row);
    $rowCount++;
    if ($rowCount % 1000 === 0) {
        fflush($file);
    }
}
fclose($file);

Or you can use my sample code below:

use Illuminate\Support\Facades\DB;

use App\Models\customer;

class CustomerController extends Controller
{
    public function export(Request $request)
    {
      ini_set('memory_limit', '512M'); // or higher if needed
      set_time_limit(0); // to prevent script timeout

      $filename = $this->module . '.csv';

      $query = customer::whereNotNull('id');
      $data = $query->get();

      if (!empty($data[0])) {
        // SET HTTP HEADERS
        $headers = array(
          "Content-type" => "text/csv",
          "Content-Disposition" => "attachment; filename=$filename",
          "Pragma" => "no-cache",
          "Cache-Control" => "must-revalidate, post-check=0, pre-check=0",
          "Expires" => "0"
        );

        $callback = function () use ($data) {
          $fh = fopen('php://output', 'w');

          // SET HEADER FIELDS
          $header_fields = [
            ucwords('customer ID'),
            ucwords('name'),
            ucwords('phone'),
            ucwords('address'),
            ucwords('created')
          ];
          fputcsv($fh, $header_fields);

          $rowCount = 0;
          foreach ($data as $item) {
            $final_array = [];
            $final_array[] = $item->id;
            $final_array[] = $item->name;
            $final_array[] = $item->phone;
            $final_array[] = $item->address;
            $final_array[] = $item->created_at;

            fputcsv($fh, $final_array);

            $rowCount++;
            if ($rowCount % 1000 === 0) {
              fflush($fh);
            }
          }

          fclose($fh);
        };

        return response()->stream($callback, 200, $headers);
      } else {
        # FAILED (NO DATA)
        return redirect()->back()->with('error', 'No Data');
      }
    }
}

Popularity 1/10 Helpfulness 3/10 Language php

Source: Grepper

Tags: csv export laravel php when

Link to this answer
Share Copy Link

Contributed on Jun 13 2023

vickzkater

0 Answers Avg Quality 2/10

laravel error 500 when export data to csv

Contents

More Related Answers

laravel error 500 when export data to csv

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.