/** * csv导出 */ public function exportvoter(){ header( cache-control: public ); header( pragma: public ); header(content-type:application/vnd.ms-excel); header(content-disposition:attachment;filename=投票人信息.csv); header('content-type:application/octet-stream'); ob_start(); $header_str = iconv(utf-8,'gbk',姓名,性别,电话,密码\n); $voter = new \admin\model\votersmodel (); //$data = i ( 'get.' );print_r($data);exit(); if (i ( 'get.name' )!=) { $name = i ( 'get.name' ); } else { $name = ; } $where=($name==''?'': and v.name like '%{$name}%'); $list=$voter->query(select v.*,d.deptname from voters v inner join wkrj_auth_dept d on v.deptid=d.id.$where); $file_str=''; if($list){ foreach ($list as $row){ $file_str.= $row['name'].','.$row['sex'].','.$row['phone'].','.$row['password'].\n; } }else{ echo 导出失败!; } //exit($file_str); //iconv转码函数 $file_str= iconv(utf-8,'gbk',$file_str); ob_end_clean(); echo $header_str; echo $file_str; }
以上就介绍了thinkphp 导出csv格式文档，包括了方面的内容，希望对php教程有兴趣的朋友有所帮助。