PHP fputcsv unwanted additional last line

Question

I have the following code which exports an array result to csv in PHP:

$file = fopen('php://output', 'w');

    $firstLineKeys = false;
    foreach ($result as $line) {
        if (empty($firstLineKeys))
        {
            $firstLineKeys = array_keys($line);
            fputcsv($file, $firstLineKeys);
            $firstLineKeys = array_flip($firstLineKeys);
        }
        fputcsv($file, $line, ',');
    }

    fclose($file);

However, i get the last line of the csv file as "Headers Sent" which makes the file a little ugly at the end.

How can I remove that last line or not show the message "Headers Sent"?

score 2 · Accepted Answer · answered Nov 14 '18 at 02:12

Had to add exit(); at the end. This removed the last line that had "Headers Sent" text.

Solution as follows:

$file = fopen('php://output', 'w');

$firstLineKeys = false;
foreach ($result as $line) {
    if (empty($firstLineKeys))
    {
        $firstLineKeys = array_keys($line);
        fputcsv($file, $firstLineKeys);
        $firstLineKeys = array_flip($firstLineKeys);
    }
    fputcsv($file, $line, ',');
}

fclose($file);
exit();

PHP fputcsv unwanted additional last line

1 Answers1