PHP 导出csv

 
 

  
  //Html 页面提交申请

 
 
 
 

  
  <form 
  
  action=
  
  "/Article/Export" 
  
  method=
  
  "post" 
  
  class=
  
  "form-horizontal" 
  
  enctype=
  
  "multipart/form-data"
  
  >

 
 
 
 
	
  
  <button 
  
  class=
  
  "btn btn-return" 
  
  type=
  
  "submit" 
  
  id=
  
  "submit" 
  
  target-form=
  
  "form-horizontal"
  
  >µ¼³ö
  
  </button>

 
 
 
 

  
  </form>

 
 
 
 


 
 
 
 


 
 
 
 


 
 
 
 

  
  //控制器方法

 
 
 
 

  
    public function ExportAction() {

 
 
 
 
       
 
 
 
 

  
          $result = getAll('xx_xxx'); // 查询出数据

 
 
 
 

  
          $data = "编号,标题,分类,渠道类别,\n";;    //A1行标题

 
 
 
 

  
          foreach ( $result as $item ) {		//循环获取 

 
 
 
 

  
              $data .= $item ['id'] . ',' . $item ['title'] . ',' . $item ['sortid']. ',' . $item ['type'] . "\n";//对应标题输出对应字符

 
 
 
 

  
          }

 
 
 
 
    

 
 
 
 

  
          $name = iconv ( 'UTF-8', 'GBK//IGNORE', 'xx列表' );

 
 
 
 

  
          $filename = $name . date ( 'Ymd', time () ) . ".csv"; //文件名为 xx列表20161026.csv

 
 
 
 

  
          header ( "Content-type:text/csv; charset=gbk" );  //注明编码 防止乱码

 
 
 
 

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

 
 
 
 
    

 
 
 
 

  
          echo iconv ( 'UTF-8', 'GBK//IGNORE', $data );  //输出

 
 
 
 

  
      }