Shulou(Shulou.com)06/03 Report--

This article mainly introduces php how to export csv setting code, the article is very detailed, has a certain reference value, interested friends must read it!

The method of php exporting csv setting encoding: 1. Use iconv method to transcode the exported content from utf-8 to gb2312;2, and use mb_convert_encoding method to transform coding.

This article operating environment: Windows7 system, PHP7.1 version, Dell G3 computer

We used to use PHPexcel to export some of our data, because Phpexcel exports more than 10, 000 pieces of data will lead to timeouts and memory skyrocketing, and then we use the data to export to csv format.

I believe that many friends encounter all kinds of garbled code problems when exporting csv files with PHP. A lot of searches on the Internet are solved by adding BOM. I have tried this method many times and it doesn't work in our test and production environment. I don't know why.

Later, using the iconv method to transcode the exported content from utf-8 to gb2312, the miracle finally came out and could be displayed normally, but colleagues found that dozens of pieces of data were missing from more than 400 pieces of data (I am a csv string that is transcoded and spliced out). So I went to du Niang to find the problem of iconv transcoding failure, and found that iconv originally had BUG, and for some Chinese characters, it could not be converted, and then a null value could not be returned. This is the reason why dozens of pieces of data are missing. At the same time, the method of mb_convert_encoding is given to convert. So with a little modification, it is changed to use the mb_convert_encoding method, and the local test is very normal. The code is as follows:

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

However, publishing to the online export data is still a pile of garbled code, but it is different from the garbled code when it is not transcoded before, indicating that the mb_convert_encoding method is effective. Check that the mb_convert_encoding method has three parameters $from_encoding, the third parameter is optional, most examples on the Internet do not use the third parameter, and the third parameter defaults to a null value. So I used it and changed it to

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

It is normal to test on the local development machine, release to the production environment, ho ho, everything is fine.

The above is all the content of the article "how to export csv setting codes from php". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.