PHP导出CSV UTF-8转GBK不乱码的解决办法

提示：扫一扫查出行
【扫一扫了解最新限行尾号】
复制提示

折腾了几次搜索了好久终于找到办法

/**

* http://yige.org/php/

* @ string 需要转换的文字

* @ encoding 目标编码

**/

function convert_encoding($string, $encoding = 'gbk'){

	$is_utf8 =  preg_match('%^(?:[\x09\x0A\x0D\x20-\x7E]| [\xC2-\xDF][\x80-\xBF]|  \xE0[\xA0-\xBF][\x80-\xBF] | [\xE1-\xEC\xEE\xEF][\x80-\xBF]{2}    |  \xED[\x80-\x9F][\x80-\xBF] |  \xF0[\x90-\xBF][\x80-\xBF]{2}  | [\xF1-\xF3][\x80-\xBF]{3}  |  \xF4[\x80-\x8F][\x80-\xBF]{2} )*$%xs', $string);

	if($is_utf8 && $encoding == 'utf8'){

		return $string;

	}elseif($is_utf8){

		return mb_convert_encoding($string, $encoding, "UTF-8");

	}else{

		return mb_convert_encoding($string, $encoding, 'gbk,gb2312,big5');

	}

}

应用办法

/**

 * 输出一个csv头，用于下载

 * @param string $filename, 输出的下载文件名

 * @return null

 */

function csv_header_4_downloading($filename, $encode = 'UTF-8')

{

	header('Content-Encoding: ' . $encode);

	header('Content-type: text/csv; charset=' . $encode);

	header("Content-Disposition: attachment; filename={$filename}.csv");

	if (strtolower($encode) == 'utf-8') echo "\xEF\xBB\xBF"; // UTF-8 BOM

}

/**

    * 导出数据为excel表格

    *@param $data    一个二维数组,结构如同从数据库查出来的数组

    *@param $title   excel的第一行标题,一个数组,如果为空则没有标题

    *@param $filename 下载的文件名

    *@examlpe

    $stu = M ('User');

    $arr = $stu -> select();

    exportexcel($arr,array('id','账户','密码','昵称'),'文件名!');

*/

function export2excel($data=array(), $title=array(), $filename='report'){

	ob_clean();

    csv_header_4_downloading($filename, 'gbk');

    //导出xls 开始

    if (!empty($title)){

        foreach ($title as $k => &$v) {

			$v = convert_encoding($v, 'gbk');

        }

        $title= implode("\",\"", $title);

        echo "\"$title\"\r\n";

    }

    if (!empty($data)){

        foreach($data as $key => &$val){

            foreach ($val as $ck => &$cv) {

				$cv = str_replace(',', '，', $cv);

				$cv = str_replace("\"", "\\\"", $cv);

				$cv = str_replace("\r", "", $cv);

				$cv = str_replace("\n", "", $cv);

				$cv = strip_tags($cv);

				$cv = convert_encoding($cv, 'gbk');

            }

            $val = implode("\",\"", $val);

			echo "\"$val\"\r\n";

        }

    }

	exit();

}