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"></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"></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;
}