thinkphp5搜索后导出Excel表格

input框就收value值并保留值

<input type="text" class="input-text" style="width:250px" placeholder="输入名称、是否上架" name="search" value="{$Request.param.search}">

a链接导出数据

<a href="{:url('Admin/daochu',array('id'=>$Request.param.search))}" class="btn btn-success radius"><i class="Hui-iconfont">&#xe627;</i>导出Excel</a>

控制器

public function daochu(){
 $cs =input('id');
			//halt($where);
			// dump($where);exit;
			$map['name']=array('like',"%".$cs."%");
			// dump($map);exit;
		$list = db('management')->where($map)->select();
		}

全部代码
静态页面

<form action="{:url('Admin/search')}" method="post" enctype="multipart/form-data">
			<input type="text" class="input-text" style="width:250px" placeholder="输入名称、是否上架" name="search" value="{$Request.param.search}">
			<button type="submit" class="btn btn-success radius"><i class="Hui-iconfont"></i> 搜用户</button>
			<a href="{:url('Admin/daochu',array('id'=>$Request.param.search))}" class="btn btn-success radius"><i class="Hui-iconfont">&#xe627;</i>导出Excel</a>
		</form>

控制器

//搜索
	public function search()
	{
		$chazhao = input('search');
		$where['name|state']=['like','%'.$chazhao.'%'];
		$sql = db('management')->where($where)->select();
		$this->assign('list',$sql);
		return view('Admin/management');
	}
	//导出xls
	public function daochu(){
		//1.从数据库中取出数据
		  $cs =input('id');
			//halt($where);
			// dump($where);exit;
			$map['name']=array('like',"%".$cs."%");
			// dump($map);exit;
		$list = db('management')->where($map)->select();
		// dump($list);exit;
				//halt($list);
		 //2.加载PHPExcle类库
		vendor('PHPExcel.PHPExcel');
		//3.实例化PHPExcel类
		  $path = dirname(__FILE__);
        Loader::import('PHPExcel.Classes.PHPExcel');
        Loader::import('PHPExcel.Classes.PHPExcel.IOFactory.PHPExcel_IOFactory');
      
        $objPHPExcel = new \PHPExcel();
		//4.激活当前的sheet表
		$objPHPExcel->setActiveSheetIndex(0);
		//5.设置表格头（即excel表格的第一行）
		$objPHPExcel->setActiveSheetIndex(0)
				->setCellValue('A1', 'ID')
				->setCellValue('B1', '名称')
				->setCellValue('C1', '价格')
				
		//设置A列水平居中
		$objPHPExcel->setActiveSheetIndex(0)->getStyle('A')->getAlignment()
					->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
		//设置单元格宽度
		$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('A')->setWidth(10);
		$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('B')->setWidth(30); 
		$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('C')->setWidth(30);
	  
		//6.循环刚取出来的数组，将数据逐一添加到excel表格。
		for($i=0;$i<count($list);$i++){
			$objPHPExcel->getActiveSheet()->setCellValue('A'.($i+2),$list[$i]['id']);//ID
			$objPHPExcel->getActiveSheet()->setCellValue('B'.($i+2),$list[$i]['name']);//名称
			$objPHPExcel->getActiveSheet()->setCellValue('C'.($i+2),$list[$i]['selling']);//价格
			
		}
		//7.设置保存的Excel表格名称
		$filename = '商品数据'.date('ymd',time()).'.xls';
		//8.设置当前激活的sheet表格名称；
		$objPHPExcel->getActiveSheet()->setTitle('价格');
		//9.设置浏览器窗口下载表格
		header("Content-Type: application/force-download");  
		header("Content-Type: application/octet-stream");  
		header("Content-Type: application/download");  
		header('Content-Disposition:inline;filename="'.$filename.'"');  
		//生成excel文件
		$objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
		//下载文件在浏览器窗口
		$objWriter->save('php://output');
		exit;
	}