PHP generates CSV files and opens garbled characters in Excel_PHP tutorial

Today a classmate asked me why garbled characters appear when the CSV file generated by PHP is opened in Excel. Below, the editor will find some common methods for you. I hope this method will be helpful to all my friends.

Baidu found out after verification

The UTF-8 encoded CSV file generated by PHP displays garbled characters in Chinese when opened in Excel. This is because there is no BOM in the output CSV file.

We just need to deal with it briefly

So how to output BOM in PHP?

Before all content is output

The code is as follows

代码如下	复制代码
print(chr(0xEF).chr(0xBB).chr(0xBF));

Copy code

print(chr(0xEF).chr(0xBB).chr(0xBF));

代码如下

复制代码

$now = gmdate("D, d M Y H:i:s"); header("Expires: Tue, 03 Jul 2001 06:00:00 GMT"); header("Cache-Control: max-age=0, no-cache, must-revalidate, proxy-revalidate"); header("Last-Modified: {$now} GMT"); // force download header("Content-Type: application/force-download"); header("Content-Type: application/octet-stream"); header("Content-Type: application/download"); // disposition / encoding on response body header("Content-Disposition: attachment;filename={$filename}"); header("Content-Transfer-Encoding: binary"); $items_data=array( '0'=>array('title'=>'test test test1'), '1'=>array('title'=>'test test test2'), '2'=>array('title'=>'test test test3') ) print(chr(0xEF).chr(0xBB).chr(0xBF));//设置utf-8 + bom ，处理汉字显示的乱码 echo array2csv($items_data);   function array2csv(array &$array) {    if (count($array) == 0) {      return null;    }    ob_start();    $df = fopen("php://output", 'w');    fputcsv($df, array_keys(reset($array)));    foreach ($array as $row) {       fputcsv($df, $row);    }    fclose($df);    return ob_get_clean(); } ?>

Example. When php generates csv, we can do this

) print(chr(0xEF).chr(0xBB).chr(0xBF));//Set utf-8 + bom to deal with garbled characters displayed in Chinese characters

The code is as follows

Copy code

$now = gmdate("D, d M Y H:i:s"); header("Expires: Tue, 03 Jul 2001 06:00:00 GMT"); header("Cache-Control: max-age=0, no-cache, must-revalidate, proxy-revalidate"); header("Last-Modified: {$now} GMT"); // force download header("Content-Type: application/force-download"); header("Content-Type: application/octet-stream"); ​​ header("Content-Type: application/download"); // disposition / encoding on response body header("Content-Disposition: attachment;filename={$filename}"); header("Content-Transfer-Encoding: binary"); $items_data=array( '0'=>array('title'=>'test test test1'), '1'=>array('title'=>'test test test2'), '2'=>array('title'=>'test test test3')

echo array2csv($items_data);

function array2csv(array &$array)

{ If (count($array) == 0) { Return null; } ob_start(); $df = fopen("php://output", 'w'); fputcsv($df, array_keys(reset($array))); foreach ($array as $row) {          fputcsv($df, $row); } fclose($df); Return ob_get_clean(); }

?>

Another way is to use Office Open Microsoft Office 2010 Excel, data-self-text, as shown in the figure: Import this csv format file, and you are also required to select encoding, as shown in the figure: Select UTF-8 here. After opening it, you will find that the garbled characters are eliminated, as shown in the picture: Supplement: UTF-8 is the most widely used implementation of unicode encoding on the Internet. One of the biggest features of UTF-8 is that it is a variable-length encoding method. It can use 1~4 bytes to represent a symbol, and the byte length varies according to different symbols http://www.bkjia.com/PHPjc/633200.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/633200.htmlTechArticleToday a classmate asked me why the CSV file generated by PHP would appear garbled when opened in Excel. The editor will tell you below I found some common methods, I hope this method will be helpful to all my friends...