csv文件乱码问题解决(转)

2019独角兽企业重金招聘Python工程师标准>>>

<?php 

    function fopen_utf8($filename){

        $encoding='';

        $handle = fopen($filename, 'r');

        $bom = fread($handle, 2);

        //fclose($handle);

        rewind($handle);

        if($bom === chr(0xff).chr(0xfe)  || $bom === chr(0xfe).chr(0xff)){

                // UTF16 Byte Order Mark present

                $encoding = 'UTF-16';

        } else {

            $file_sample = fread($handle, 1000) + 'e'; //read first 1000 bytes

            // + e is a workaround for mb_string bug

            rewind($handle);

            $encoding = mb_detect_encoding($file_sample , 'UTF-8, UTF-7, ASCII, EUC-JP,SJIS, eucJP-win, SJIS-win, JIS, ISO-2022-JP');

        }

        if ($encoding){

            stream_filter_append($handle, 'convert.iconv.'.$encoding.'/UTF-8');

        }

        return  ($handle);

    }

    $file='./demo2.csv'; 

    if (($handle = fopen_utf8($file, "r")) === FALSE) return;

        while (($cols = fgetcsv($handle, 1000, "\t")) !== FALSE) {

            echo $cols[0];

    }

 ?>

转载于:https://my.oschina.net/lnmpstudy/blog/206082