CODEWITHSUNDEEP
phplaravel
Bappy
Bappy

Reputation: 111

How can I export .csv file using with Japanese character code in PHP?

I'm trying to create a csv file using laravel and php. The database used to create the csv contains Japanese characters which I want to appear exactly the same in the file.

Below is the code I've tried so far, but the japanese characters still appear as symbols. 

$headers = array(
    "Content-Encoding" => "sjis-win",
    "Content-type" => "text/csv; charset=sjis-win",
    "Content-Disposition" => "attachment; filename=User-List.csv",
    "Pragma" => "no-cache",
    "Cache-Control" => "must-revalidate, post-check=0, pre-check=0",
    "Expires" => "0"
);


$users= $this->users->orderBy('created_at', 'desc')->get();
$columns = array('氏名', '氏名（ローマ字）');

$callback = function() use ($users, $columns)
{
    $file = fopen('php://output', 'w');
    fputcsv($file, $columns);

    foreach($users as $user) {
        fputcsv($file, array($user->name, $user->name_alphabet));
    }
    fclose($file);
};

What am I missing? What needs to be changed to make the characters appear as Japanese automatically in the csv.

Upvotes: 1

Views: 5519

Answers (2)

ChinhNV
ChinhNV

Reputation: 351

It working!

// You add $bom in when fputs file.
$headerColumns = [
   'name',
   'birthday',
   'address',
];

$fileCSV = fopen($fileName, 'w');
fputs($fileCSV, chr(0xEF) . chr(0xBB) . chr(0xBF));
fputcsv($fileCSV, $headerColumns);

foreach ($data as $myField ){
    fputcsv($fileCSV, $myField);
}

fclose($fileCSV);

// Good luck!

Upvotes: 2

Jeemusu
Jeemusu

Reputation: 10533

As the data your retrieving from the database is encoded in UTF-8, you will need to re-encode that data to match the encoding of your CSV file (SJIS-win).

You can use php's mb_convert_encoding() function to achieve this.

mb_convert_encoding($dataVariable, "SJIS-win", "UTF-8");

In your case you would use it as follows:

foreach($users as $user) {
    fputcsv($file, array(
        mb_convert_encoding($user->name, "SJIS-win", "UTF-8"), 
        mb_convert_encoding($user->name_alphabet, "SJIS-win", "UTF-8")
    ));
}

You may also need to re-encode the strings in your $columns = array('氏名', '氏名（ローマ字）') array too.

Upvotes: 1

Related Questions