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
| 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') |
)
print(chr(0xEF).chr(0xBB).chr(0xBF));//Set utf-8 + bom to deal with garbled characters displayed in Chinese characters
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...
|
