How to export csv with php and set encoding

How to set encoding when exporting csv with php: 1. Use the iconv method to transcode the exported content from utf-8 to gb2312; 2. Use the mb_convert_encoding method to convert the encoding.

The operating environment of this article: Windows7 system, PHP7.1 version, Dell G3 computer

How does php export csv setting encoding? Export csv garbled code under PHP?

We used to use PHPexcel to export some of our data. Since Phpexcel would cause timeout and memory explosion when exporting more than 10,000 pieces of data, we later switched to exporting data into csv format. .

I believe many friends have encountered various garbled problems when exporting csv files using PHP. I searched a lot on the Internet and all found solutions by adding BOM. I tried this method many times but it didn’t work in our testing and production environments. I don’t know why.

Later, I used the iconv method to transcode the exported content from utf-8 to gb2312. The miracle finally came out and it could be displayed normally. However, my colleagues discovered that there were a few missing pieces of data among the more than 400 pieces of data we exported. Ten pieces of data (I transcoded each piece one by one and spliced ​​it into a csv string). So I went to Du Niang to find the problem of iconv transcoding failure, and found that iconv turned out to have a bug. Some Chinese characters could not be converted. If they could not be converted, they could not be skipped and returned a null value. This was the reason why dozens of pieces of data were missing. , and also provides the method of using mb_convert_encoding to convert. So I made a slight modification and changed it to use the mb_convert_encoding method. The test on the local machine was very normal. The code is as follows:

$str = mb_convert_encoding($str,'gb2312');

But when the data is exported online, it is still a bunch of garbled characters, but it is different from the previous one without transcoding. The garbled characters are still different, indicating that the mb_convert_encoding method is working. I checked that the mb_convert_encoding method has three parameters $from_encoding. The third parameter is an optional parameter. Most examples on the Internet do not use the third parameter. The third parameter is also null by default. So I changed it to

$str = mb_convert_encoding($str,'gb2312','utf-8');

and tested it on the local development machine. It was normal. When I published it to the production environment, hahaha, everything was normal.

Why is this? I really don’t have time to delve into it. If anyone knows, please tell me.

Recommended study: "PHP Video Tutorial"

The above is the detailed content of How to export csv with php and set encoding. For more information, please follow other related articles on the PHP Chinese website!