Home > Article > Backend Development > When php reads csv, the solution to the problem of reading Chinese garbled characters

When php reads csv, the solution to the problem of reading Chinese garbled characters

王林Original: 2019-10-15 17:55:135170browse

1、首先讲linux，不管是centos或者Ubuntu。在导入csv的php脚本文件头部加上如下代码：

setlocale(LC_ALL,array(&#39;zh_CN.gbk&#39;,&#39;zh_CN.gb2312&#39;,&#39;zh_CN.gb18030&#39;));

这段代码的作用是改变脚本默认编码，因为操作系统的编码格式不是GBK所以，读取中文的时候会乱码。

When php reads csv, the solution to the problem of reading Chinese garbled characters

2、接着讲windows，我们在读取csv数据的时候，会有一个while循环遍历每一行的数据，而读取的每一行数据，就需要我们进行转义，将中文编码读取出来。代码如下：

$row = eval(&#39;return &#39;.iconv(&#39;gbk&#39;,&#39;utf-8&#39;,var_export($row,true)).&#39;;&#39;);

$row，就是读取出来每一行的数据变量。

When php reads csv, the solution to the problem of reading Chinese garbled characters

3、最后，贴一个fgetcsv()方法的替代函数，这种是针对有些老版本的php该函数自带着一些bug的情况。如果上边两点还是没办法解决您的问题，您可以尝试一下使用该函数，与前边两点配合使用。

function fgetcsv_reg(& $handle, $length = null, $d = &#39;,&#39;, $e = &#39;"&#39;) {
   $d = preg_quote($d);
   $e = preg_quote($e);
   $_line = "";
   $eof=false;
   while ($eof != true) {
       $_line .= (empty ($length) ? fgets($handle) : fgets($handle, $length));
       $itemcnt = preg_match_all(&#39;/&#39; . $e . &#39;/&#39;, $_line, $dummy);
       if ($itemcnt % 2 == 0)
           $eof = true;
   }
   $_csv_line = preg_replace(&#39;/(?: |[ ])?$/&#39;, $d, trim($_line));
   $_csv_pattern = &#39;/(&#39; . $e . &#39;[^&#39; . $e . &#39;]*(?:&#39; . $e . $e . &#39;[^&#39; . $e . &#39;]*)*&#39; . $e . &#39;|[^&#39; . $d . &#39;]*)&#39; . $d . &#39;/&#39;;
   preg_match_all($_csv_pattern, $_csv_line, $_csv_matches);
   $_csv_data = $_csv_matches[1];
   for ($_csv_i = 0; $_csv_i < count($_csv_data); $_csv_i++) {
       $_csv_data[$_csv_i] = preg_replace(&#39;/^&#39; . $e . &#39;(.*)&#39; . $e . &#39;$/s&#39;, &#39;$1&#39;, $_csv_data[$_csv_i]);
       $_csv_data[$_csv_i] = str_replace($e . $e, $e, $_csv_data[$_csv_i]);
   }
   return empty ($_line) ? false : $_csv_data;
}

When php reads csv, the solution to the problem of reading Chinese garbled characters

推荐教程：PHP视频教程

The above is the detailed content of When php reads csv, the solution to the problem of reading Chinese garbled characters. For more information, please follow other related articles on the PHP Chinese website!

Statement：

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Previous article：How to define variables in phpNext article：How to define variables in php

See more

When php reads csv, the solution to the problem of reading Chinese garbled characters

Related articles