CSV Wrong Encoding

Question

I have an array composed by just numbers and I use the following script to export in CSV

<?php
header('Content-Type: application/csv; charset=iso-8859-1');
session_start();
 
$tidyUp = array();
$index = 0;
foreach($_SESSION['report'] as $date => $values){
    $tidyUp[$index][] =$date;
    foreach($values as $title => $value)
        $tidyUp[$index][] = $value;
    $index += 1;
}
exportToCsv($tidyUp);
function exportToCsv($array, $filename = "export.csv", $delimiter=",") {
    $f = fopen('php://output', 'w');
    // loop over the input array
    foreach ($array as $line) {
        // generate csv lines from the inner arrays
        fputcsv($f, $line , $delimiter);
    }
    // reset the file pointer to the start of the file
    fseek($f, 0);
    // tell the browser we want to save it instead of displaying it
    header('Content-Disposition: attachment; filename="'.$filename.'";');
    // make php send the generated csv lines to the browser
    fpassthru($f);
}  
?>

The result is in the following image

Here a dump of the given array

array ( 0 => array ( 0 => '2019-10-29', 1 => 0, 2 => '45', 3 => 0, 4 => 0, 5 => 45, ), 1 => array ( 0 => '2019-10-30', 1 => 45, 2 => '165', 3 => '25', 4 => '26', 5 => 211, ), 2 => array ( 0 => '2019-10-31', 1 => 211, 2 => '12', 3 => '120', 4 => 0, 5 => 103, ), )

Any suggestion?

geldek · Accepted Answer · 2019-10-31 11:57:33Z

1

Check the encoding of $_SESSION['report'] data. It is possible that it uses some multi-byte characters. Use iconv on your $line before passing it to fputcsv function.

answered Oct 31, 2019 at 11:57

geldek

5843 silver badges12 bronze badges

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

5 Comments

geldek Over a year ago

When you open the resulting file in hex editor how does the data look like? Is there any byte order mark? Are the characters stored as single or multi-byte values?

Lucarnosky Over a year ago

To be honest can't say it to you, but I can post you there result: link

geldek Over a year ago

There is no BOM at the beginning of the file. Every character is a single byte and new line character is 0A in hexadecimal. However, it seems that you do not have equal number of columns in those first two lines that are in the screenshot. If you open the file in a simple text editor it should display just fine. I am assuming Libre Office on Mac has a problem with either the new line character or with the column count.

Lucarnosky Over a year ago

Opening with text editor works, but how can I make it also working as CSV? P.S. Is Ubuntu not a Mac

Lucarnosky Over a year ago

update: on usual office from Microsoft it work smoothly, thank you for help

Collectives™ on Stack Overflow

CSV Wrong Encoding

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related