首先:每次搜索内容提交,,把它放在一个form表单里面,,,
<form method="get" action="__SELF__">
<div style="width: 120px; margin-left: 250px" class="formControls col-xs-6 col-sm-1">
<span class="select-box">
<select name="local_name" class="select" >
<option value="0">地区分类</option>
<foreach name="localmsg" item="vo">
<option value="{$vo.local_name}" <if condition="$vo['local_name'] eq I('get.local_name')"> selected</if> >{$vo.local_name}</option>
</foreach>
</select>
</span>
</div>
<literal>
<input type="text" name="addtimefrom" value="<?php echo I('get.addtimefrom'); ?>" οnfοcus="WdatePicker({lang:'zh-cn'})" id="logmin" class="input-text Wdate" style="width:120px;">
-
<input type="text" name="addtimeto" value="<?php echo I('get.addtimeto'); ?>" οnfοcus="WdatePicker({lang:'zh-cn'})" id="logmax" class="input-text Wdate" style="width:120px;">
</literal>
<!--<input type="text" name="title" value="<?php echo I('get.title'); ?>" id="title" placeholder="按新闻标题查询" style="width:250px" class="input-text">-->
<button class="btn btn-success" type="submit" ><i class="Hui-iconfont"></i> 搜新闻</button>
</form>
//无非就是在input里面多加一个 value=",,这是时间的回显。
//这个是下拉框的回显<</span>if condition="$vo['local_name'] eq I('get.local_name')">selected</</span>if>
//然后控制器是这样的,,我全给你们复制看了,,我是分页查询写一起,,不是ajax无刷新分页,,这个是我做政府网站里面的,对页面要求不高,但是要兼顾,他们用IE6浏览器很头痛,一般ajax都不敢用。
public function local_list(){
//取出地区
$localModel=D('local');
$localmsg=$localModel->select();
//从news表取出不同单位,对应的未审核的文章
$where = array();
$addtimefrom = strtotime(I('get.addtimefrom'));
$addtimeto = strtotime(I('get.addtimeto'));
if($addtimefrom && $addtimeto)
$where['add_time'] = array('between', array($addtimefrom,$addtimeto));
elseif($addtimefrom)
$where['add_time'] = array('egt', $addtimefrom );
elseif($addtimeto)
$where['add_time'] = array('elt', $addtimeto);
if($local_name = I('get.local_name'))
$where['local_name'] = array('like', "%$local_name%");
$where['news.local_id']=['neq',0] ;// $where['news.local_id']=array('neq',0) ;
$where['del_flag']=0;
$news=D('news');
$count = $news->join('local on news.local_id=local.local_id')->where($where)->count();
// dump($where);
// dump($news->getLastSql());
$page = new \Think\Page($count, 10);
$limit = $page->firstRow . ',' . $page->listRows;//每页的数据数和内容$limit
// 配置翻页的样式
$page->setConfig('header', '
//这里可以写成数组的形式,,但是我为了区分就这样写了四个assign
$this->display();
}
- 共%TOTAL_ROW%条记录 第%NOW_PAGE%页/共%TOTAL_PAGE%页
');
$page->setConfig('last', '末页');
$page->setConfig('first', '首页');
$page->setConfig('prev', '上一页');
$page->setConfig('next', '下一页');
$page->setConfig('theme', '%FIRST%%UP_PAGE%%LINK_PAGE%%DOWN_PAGE%%END%%HEADER%');
$show = $page->show();
// 进行分页数据查询
$newlist = $news->join('local on news.local_id=local.local_id')->where($where)->limit($limit)->order('id desc')->select();
// dump($newlist);
$this->assign('count',$count);
$this->assign('page',$show);
$this->assign('newlist',$newlist);
$this->assign('localmsg',$localmsg);
//这里可以封装数组,但是我写四个assign是为了好区分
$this->display();
}