CSV file generated correctly but with wrong format when is downloaded

431 Views Asked by andrea At 29 September 2022 at 00:30

I am a beginner student of PHP and i am doing some practice by coding a script to generate a CSV file. Once that the csv file is generated , the format is correct as I've expected : See the attached :

But if i add the download option the csv is generated wrongly with all the PHP page (i can see all the code)

Here the picture of the wrong csv

Could you help me to find the issue ?

Here the code :

 <?php

    include("db.php");
    session_start();


    $sql = "SELECT isocode FROM test_geo ORDER BY isocode";
    $result_csv = mysqli_query($conn, $sql);


    //facebook csv creation //
    $filename = 'test.csv';
    $fp = fopen($filename, 'w');
    $headers = ['key', 'country'];

    fputcsv($fp, $headers);
    foreach ($result_csv as $key => $id) {
        $new = array_push($id, "country");


        fputcsv($fp, $id);
        var_dump($id);
    }

    fclose($fp);





    ?>

Original Q&A

There are 2 best solutions below

bekanur98 On 29 September 2022 at 03:14

Try this

header("Content-type: text/csv");
header("Content-Disposition: attachment; filename=result_file.csv");
header("Pragma: no-cache");
header("Expires: 0");

$output = fopen("php://output", "w");
foreach ($new as $row) {
  fputcsv($outputt, $row);
}
fclose($outputt);
exit();

Ken Lee On 29 September 2022 at 04:25

I believe you put the header statements at the top of your script, so the download data includes the HTML codes too (like below...)

<!DOCTYPE html><html lang="en"><meta charset=...... >

You may use ob_flush() and set header (at the appropriate position of the code) so that the file will be correctly downloaded as csv when it is generated.

Here is the code:

<?php
session_start();
include("db.php");


$sql = "SELECT isocode FROM test_geo ORDER BY isocode";
$result_csv = mysqli_query($conn, $sql);


$data=array();

while($row = mysqli_fetch_array($result_csv, MYSQLI_ASSOC)) {
   $ok=$row["isocode"] . "," . "Country";
   array_push($data ,$ok);
}


ob_flush();
$filename="ok1.csv";
$csvData = join("\n", $data);
header('Content-Disposition: attachment; filename="'.$filename.'";');
header('Content-Type: application/csv; charset=UTF-8');
die($csvData);

?>

CSV file generated correctly but with wrong format when is downloaded

There are 2 best solutions below

Related Questions in PHP

Related Questions in HTTP-HEADERS

Related Questions in OPENCSV

Related Questions in FPUTCSV

Trending Questions

Popular # Hahtags

Popular Questions