When php reads csv, the solution to the problem of reading Chinese garbled characters-PHP Problem-php.cn

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

王林

Release： 2023-02-26 19:16:01

Original

5218 people have browsed it

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

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;));

Copy after login

这段代码的作用是改变脚本默认编码，因为操作系统的编码格式不是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;);

Copy after login

$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;
}

Copy after login

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!