Encoding characters when exporting using php in csv format

Question

I have a problem with my export.

So I tried to export data to .csv with the following code :

        $output = fopen('php://output', 'w');
        $sFileName = 'test.csv';
        header('Content-Disposition: attachement; filename="' . $sFileName . '";');
        header("Content-Type:application/csv;charset=UTF-8");
        fwrite($output, "sep=;\n");
        fputcsv($output, array('Nom', 'Prenom'), ";");
        foreach ($aFilterGifts as $value) {
            fputcsv($output, $value, ";");
        }
        fpassthru($output);
        fclose($output);
        exit;

Where the $aFilterGifts is an array with data. But If I have in Nom, data like this Fossé, when I export I get FossГ©.

Is there a solution? Thank you in advance.

Make sure your php document ist utf8 encoded.

Mel_T
– Mel_T

2015-06-02 11:35:27 +00:00
Commented Jun 2, 2015 at 11:35 — Mel_T
– Mel_T, Commented Jun 2, 2015 at 11:35

TanGio · Accepted Answer · 2015-06-02 11:36:39Z

1

I found the error, it's necessairy to make $output = fopen('php://output', 'w'); after all headers,so thhe code is like this :

    $sFileName = 'test.csv';
    header('Content-Disposition: attachement; filename="' . $sFileName . '";');
    header("Content-Type:application/csv;charset=UTF-8");
    $output = fopen('php://output', 'w');

answered Jun 2, 2015 at 11:36

TanGio

7662 gold badges12 silver badges34 bronze badges

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

Collectives™ on Stack Overflow

Encoding characters when exporting using php in csv format

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related