How to create a downloadable csv file from an array?

Question

I have an array like this :

     $data = [
  ["firstname" => "Mary", "lastname" => "Johnson", "age" => 25],
   ["firstname" => "Amanda", "lastname" => "Miller", "age" => 18],
   ["firstname" => "James", "lastname" => "Brown", "age" => 31],
   ["firstname" => "Patricia", "lastname" => "Williams", "age" => 7],
   ["firstname" => "Michael", "lastname" => "Davis", "age" => 43],
   ["firstname" => "Sarah", "lastname" => "Miller", "age" => 24],
   ["firstname" => "Patrick", "lastname" => "Miller", "age" => 27]
 ];

I want to create an downloadable csv file from this array in php. like this:

unicode utf-8 is important too.

I have found the solution:

<?PHP

 function cleanData(&$str)
{
if($str == 't') $str = 'TRUE';
if($str == 'f') $str = 'FALSE';
if(preg_match("/^0/", $str) || preg_match("/^\+?\d{8,}$/", $str) ||          preg_match("/^\d{4}.\d{1,2}.\d{1,2}/", $str)) {
    $str = "'$str";
  }
  if(strstr($str, '"')) $str = '"' . str_replace('"', '""', $str) . '"';
  $str = mb_convert_encoding($str, 'UTF-16LE', 'UTF-8');

}

// filename for download
$filename = "website_data_" . date('Ymd') . ".csv";

header("Content-Disposition: attachment; filename=\"$filename\"");
header("Content-Type: text/csv; charset=UTF-16LE");

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

$flag = false;
foreach ($data as $row) {
   if(!$flag) {
    // display field/column names as first row
    fputcsv($out, array_keys($row), ',', '"');
    $flag = true;
  }
  array_walk($row, __NAMESPACE__ . '\cleanData');
   fputcsv($out, array_values($row), ',', '"');
}

fclose($out);
exit;
 ?>

it works and creates .csv file but it show Persian Chars unreadable.

That screenshot does not show a CSV file but a spreadsheet application. — arkascha, Jan 12 '17 at 23:00
You don't need to create a physical file for this. You simply send a mime type header for the CSV format and then the data itself. That's all the magic. — arkascha, Jan 12 '17 at 23:01

cornelb · Answer 1 · 2017-01-12T23:06:31.310

0

Use http://php.net/manual/en/function.fputcsv.php

$fp = fopen('php://output', 'w');
fputcsv($fp, array_keys($data[0]));

foreach ($data as $row) { 
    fputcsv($fp, array_values($row));
}

fclose($fp);

Converting the array to UTF8 can be done using something like

$dataUTF8 = array_map("utf8_encode", $data);

edited Jan 12 '17 at 23:06

answered Jan 12 '17 at 23:00

cornelb

6,046
3
19
30

no need to create an actual file `$fp = fopen('php://output', 'w');` – Jan 12 '17 at 23:01
you are right. I have updated the answer. It will output the csv content to the browser. – cornelb Jan 12 '17 at 23:03
It does not answer all the question either, however the Sup does. – RiggsFolly Jan 12 '17 at 23:03
can you tell me what does not work? Does it give an error? – cornelb Jan 12 '17 at 23:15

How to create a downloadable csv file from an array?

1 Answers1