write utf-8 characters to file with fputcsv in php

Question

I want to try write Persian character in CSV file in PHP, I am using fputcsv function but how can write UTF-8 character to CSV file with fputcsv?

Part of my code:

$df = fopen($filepath, 'w');
fputcsv($df, array($coupon->code, $discount->label));

Hardy · Accepted Answer · 2014-02-24T14:50:11.440

200

Try this:

$df = fopen($filepath, 'w');
fprintf($df, chr(0xEF).chr(0xBB).chr(0xBF));
fputcsv($df, array($coupon->code, $discount->label));

the line fprintf($df, chr(0xEF).chr(0xBB).chr(0xBF)); writes file header for correct encoding.

edited Feb 24 '14 at 14:50

answered Feb 24 '14 at 13:06

Hardy

1

You also have to take consideration in excel perspective. Make sure the excel already encoded in UTF-8 – Faris Rayhan Nov 02 '17 at 07:50
4

Could you please explain what the three characters are and what is their purpose in fixing the UTF8 problem? – Ahmad Baktash Hayeri Feb 05 '19 at 04:13
2

@AhmadBaktashHayeri those bytes make up the Byte Order mark (BOM) for UTF-8 – Herbert Van-Vliet Sep 08 '19 at 07:11
This works great *but* in my case it makes some fields not to be printed to the excel file. Any idea why is that? – rutex Mar 12 '22 at 07:48
See also answer to https://stackoverflow.com/questions/40447325/php-export-csv-utf-8-with-bom-doesnt-work - if this doesn't work need to echo the characters before as well – softfrog Sep 12 '22 at 08:20

score 36 · Answer 2 · answered Oct 23 '14 at 12:43

36

Try this also:

$df = fopen($filepath, 'w');
$array = array($coupon->code, $discount->label);
$array = array_map("utf8_decode", $array);
fputcsv($df, $array);

answered Oct 23 '14 at 12:43

robsonsanches

1

What does this answer do? – mwfearnley Jul 01 '16 at 12:08
2

This will **decode** your UTF8 strings into single byte ISO-8859-1. This **NOT** what the OP was asking for. – Solrac Sep 01 '16 at 17:11
@FarisRayhan Same things here.. :( – Chinmay235 Apr 26 '18 at 06:53
This is clearer in my opinion and leaves the work to be done by utf8_decode and not requiring the reader to obey the BOM. – Ross Dec 01 '20 at 13:14

score 5 · Answer 3 · answered Aug 27 '18 at 07:57

5

If you want make a UTF-8 file for excel, use this simple solution:

$fp = fopen($filename, 'w');

//add BOM to fix UTF-8 in Excel 
fputs($fp, $bom =( chr(0xEF) . chr(0xBB) . chr(0xBF) ));

See the original answer here on the official PHP page.

answered Aug 27 '18 at 07:57

Syno

score 0 · Answer 4 · answered Oct 11 '21 at 13:08

0

Similar to others, but works for me

fputs($output_file, chr(0xEF) . chr(0xBB) . chr(0xBF) );

before fputcsv your data

answered Oct 11 '21 at 13:08

Nomikos Strigkos

4 Answers4