```php <?php //校验上传文件类型 if(empty($_FILES['csv']['error'])) { $sFileExt = strtolower(substr($_FILES['csv']['name'], -3)); //获取后缀名 if($sFileExt != 'csv'){ Page::error('上传文件必须是csv文件'); } $sFileName = $_FILES['csv']['tmp_name']; $oFile = fopen($sFileName, 'r'); $aSameNick = array(); while(($aRow = fgetcsv($oFile, 10000)) !== false) { $list[] = $aRow; } fclose($oFile); //确定文件名 $sFilename = "cvs生成_" . time(). ".csv"; $sFilename = mb_convert_encoding($sFilename, 'gbk'); header("Content-type:application/vnd.ms-excel"); header("Content-Disposition:filename=" . $sFilename); //导出生成的短链接 $sOut = "手机,短链接,长链接,姓名,userid"."\n"; $sOut = mb_convert_encoding($sOut, 'gbk'); echo $sOut; foreach($arr as $key => $val){ $sOut = "\"{$mobile}\"," . "\"{$valurl_short}\"," . "\"{$valurl_real}\"," . "\"{$valuserName}\"," . "\"{$valuserId}\",\n"; $sOut = mb_convert_encoding($sOut, 'gbk'); echo $sOut; } } ?> ``` 下面的代码是我在项目中用到的，故copy ```php <?php use League\Csv\Reader; class CsvParse { private $file; private $counter; private $readline; private $project_id; private $userid; private $group_id; private $sendcloud; private $aSendCloudMember; public function __construct($file) { $this->file = new SplFileObject($file); } public function run($project_id, $userid) { $this->readline = 500; //每次读取500行 $this->project_id = $project_id; $this->userid = $userid; $this->sendcloud = App::get('config')->get('sendcloud'); $this->createGroup(); $this->readCsv(); } public function readCsv() { $aCache = array(); while (!$this->file->eof()) { $linedata = $this->file->fgetcsv(); if(!empty($linedata)) { $aCache[] = $linedata; } if(count($aCache) == $this->readline) { if(!$this->checkAndSend($aCache)) { break; } $aCache = array(); } } if(!$this->checkAndSend($aCache)) { return; } $aCache = array(); } public function checkAndSend($aUser) { if(empty($aUser)) { return false; } foreach ($aUser as $key=>$value) { if (empty($value[0]) || empty($value[1]) || empty($value[2])) { continue; } //$value 下的数据 } return true; } } ```
