public function datacsv(){ $result=M('user')->select(); $str = "姓名,年龄\n"; $str = iconv('utf-8','gb2312',$str); foreach($result as $key=>$val){ $name = iconv('utf-8','gb2312',$val['name']); //转换编码 $age=is_numeric($val['age'])?$val['age']."\t":$val['age']; //将数字不让科学记数法转换 $str .= $name.",".$age."\n"; } $fileName = date('Ymd').'.csv'; $this->export_csv($fileName,$str); exit; } public function export_csv($filename, $data){ header("Content-type:text/csv"); header("Content-Disposition:attachment;filename=".$filename); header('Cache-Control:must-revalidate,post-check=0,pre-check=0'); header('Expires:0'); header('Pragma:public'); echo $data; }