PHP导入导出csv文件

 1 <?php 2 ?3 class CSV 4 { 5 ????public static $csvError = ‘‘; 6 ?????7 ????public static function _SetError($error) 8 ????{ 9 ????????self::$csvError = $error;10 ????}11 ????12 ????/**13 ?????* 读取csv文件成数组14 ?????* @param string $filePath 文件路径15 ?????* @return array|bool16 ?????*/17 ????public static function import($filePath)18 ????{19 ????????setlocale(LC_ALL, ‘zh_CN‘);20 ????21 ????????if(!file_exists($filePath) || !is_readable($filePath)) {22 ????????????self::_SetError(‘文件不存在或者不可读‘);23 ????????????return FALSE;24 ????????}25 ????26 ????????$rows = array();27 ????????$fp = fopen($filePath, ‘rb‘);28 ????????while (!feof($fp)) {29 ????????30 ????????????$row = str_replace(array("\r\n", "\r", "\n"), ‘‘, fgets($fp));31 ????????????$rows[] = explode(‘,‘, iconv(‘GB2312‘, ‘UTF-8‘, $row)); //简体中文编码转为 utf-8, gbk 兼容gb231232 ????????33 ????????}34 ????????return $rows;35 ????}36 ????37 ????/**38 ?????* 输出 UTF-8 编码的csv文件39 ?????* @param array $data ?[‘filename‘ => ‘xxx‘, ‘list‘ => [[xx,xx,x], [xx,xx,x], ....]]40 ?????* @return bool41 ?????*/42 ????public static function export($data)43 ????{44 ????????if (empty($data[‘filename‘]) || empty($data[‘list‘])) {45 ????????????self::_SetError(‘缺少参数filename/list‘);46 ????????????return FALSE;47 ????????}48 ????????$filename = $data[‘filename‘]; //文件名49 ????50 ????????header("Expires: 0");51 ????????header("Cache-Control: max-age=0, no-cache, must-revalidate, proxy-revalidate");52 ????????// 强制下载53 ????????header("Content-Type: application/force-download");54 ????????header("Content-Type: application/octet-stream");55 ????????header("Content-Type: application/download");56 ????????// disposition / encoding on response body57 ????????header("Content-Disposition: attachment;filename={$filename}");58 ????????header("Content-Transfer-Encoding: binary");59 ????60 ????????//设置utf-8 + bom ，处理汉字显示的乱码61 ????????echo(chr(0xEF).chr(0xBB).chr(0xBF));62 ????63 ????????//打开输出缓存64 ????????ob_start();65 ????66 ????????//打开输出流67 ????????$df = fopen("php://output", ‘w‘);68 ????69 ????????//数据写入缓存70 ????????foreach ($data[‘list‘] as $row) {71 ????????????foreach ($row as $k => $v) {72 ????????????????is_numeric($v) && ($row[$k] .= "\t"); //防止变为科学计数法显示73 ????????????}74 ????????????fputcsv($df, $row);75 ????????}76 ????77 ????????fclose($df);78 ????????echo ob_get_clean();79 ????????exit;80 ????}81 }