如何在php中导出文件csv时修复文件csv中的错误字体UTF8

Question

I export csv in php as:

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

            foreach ($list as $fields) {
                if(!empty($fields))
                fputcsv($fp, $fields);
                else
                fputcsv($fp, ' ');

            }
            $fp = chr(255).chr(254).mb_convert_encoding($fp,"UTF-16LE","UTF-8"); 
            fclose($fp);

When i open csv, font UTF_8 is error. Ex: 防本部コー show in file csv: æ¶ˆé˜²æœ¬éƒ¨ă‚³ăƒ¼ăƒ‰

Can I help you? Thanks

Answer 1

This has been discussed here:

How can I output a UTF-8 CSV in PHP that Excel will read properly?

You might also want to check your CSV in an alternative text editor to rule out the editor.