Home >Backend Development >PHP Tutorial >thinkphp 文字 筛选 字段 都在一个表里面

thinkphp 文字 筛选 字段 都在一个表里面

WBOY
WBOYOriginal
2016-06-23 13:49:051231browse





程序代码

	public function index(){			$Data = M('zhaopin'); // 实例化Data数据对象			import('ORG.Util.Page');// 导入分页类			$count= $Data->where($map)->count();// 查询满足要求的总记录数			$Page= new Page($count,20);// 实例化分页类 传入总记录数			$nowPage = isset($_GET['p'])?$_GET['p']:1;			$list = $Data->where($map)->order('shijian desc,id asc')->page($nowPage.','.$Page->listRows)->select();			$show = $Page->show();// 分页显示输出			$this->assign('count',$count);			$this->assign('page',$show);// 赋值分页输出			$this->assign('list',$list);// 赋值数据集			$this->display(); // 输出模板	}


筛选的地方
<dt>招聘职位:</dt><a href="#" >全部</a><volist name="list" id="vo">	<a href="/index.php/Zhaopin/index/Position/{$vo[Position]}">{$vo['Position']}</a>	</volist> <dt>区域:</dt><a href="停车场.html">全深圳</a> <volist name="list" id="vo">	<a href="/index.php/Zhaopin/index/Recruitment/{$vo[Recruitment]}">{$vo['Recruitment']}</a>	</volist> 


内容代码
<volist name="list" id="vo">	<span class="jobname" style="width:35%;"><a href="/index.php/Zhaopin/show/id/{$vo[id]}">{$vo['Job']|mb_substr=0,8,'UTF-8'}</a></span>	<span style="width:30%;"><a href="/index.php/Zhaopin/show/id/{$vo[id]}">{$vo['company_name']}</a></span>	<span style="width:16%;">{$vo['Recruitment']}</span>	<span style="width:15%;">{$vo['shijian']}</span>			招聘人数:{$vo['hiring']}人    			公司性质:{$vo['Nature']}    			规模:{$vo['company_scale']}人    			经验:{$vo['Work_experience']}年    			学历:{$vo['Degree_required']}    			职位月薪:{$vo['salary']}元/月		岗位要求: {$vo['Job_requirements']|mb_substr=0,150,'UTF-8'}	<a href="/index.php/Zhaopin/show/id/{$vo[id]}" class="getjob">查看职位</a></dd></volist>


回复讨论(解决方案)

主要问题是  where 里面的条件不会写

public function index(){        $Data = M('zhaopin'); // 实例化Data数据对象        import('ORG.Util.Page');// 导入分页类               $map="1=1 ";//初始化条件变量        $Position=$this->_param('Position');//接收参数        $Recruitment=$this->_param('Recruitment');//接收参数        if($Position<>''){	        $map.=" and Position='$Position'";        }        if($Recruitment<>''){	        $map.=" and Recruitment='$Recruitment'";        }        $count= $Data->where($map)->count();// 查询满足要求的总记录数        $Page= new Page($count,20);// 实例化分页类 传入总记录数        $nowPage = isset($_GET['p'])?$_GET['p']:1;        $list = $Data->where($map)->order('shijian desc,id asc')->page($nowPage.','.$Page->listRows)->select();        $show = $Page->show();// 分页显示输出        $this->assign('count',$count);        $this->assign('page',$show);// 赋值分页输出        $this->assign('list',$list);// 赋值数据集        $this->display(); // 输出模板}

大概是这个样子,楼主看看是否有用

里面的去掉,想加红的,结果放到php代码块里了。。。

如果是可以把分页改对成数组分页。

$count=count($list);$Page       = new \Think\Page($count,20);$show       = $Page->show();// 分页显示输出$data=array_slice($list,$Page->firstRow,$Page->listRows);$this->assign("list",$data);

where写查询条件

public function index(){        $Data = M('zhaopin'); // 实例化Data数据对象        import('ORG.Util.Page');// 导入分页类               $map="1=1 ";//初始化条件变量        $Position=$this->_param('Position');//接收参数        $Recruitment=$this->_param('Recruitment');//接收参数        if($Position<>''){	        $map.=" and Position='$Position'";        }        if($Recruitment<>''){	        $map.=" and Recruitment='$Recruitment'";        }        $count= $Data->where($map)->count();// 查询满足要求的总记录数        $Page= new Page($count,20);// 实例化分页类 传入总记录数        $nowPage = isset($_GET['p'])?$_GET['p']:1;        $list = $Data->where($map)->order('shijian desc,id asc')->page($nowPage.','.$Page->listRows)->select();        $show = $Page->show();// 分页显示输出        $this->assign('count',$count);        $this->assign('page',$show);// 赋值分页输出        $this->assign('list',$list);// 赋值数据集        $this->display(); // 输出模板}

大概是这个样子,楼主看看是否有用




{$vo['Position']}   筛选  读取出的结果
 那么 a 怎么给
  $Position=$this->_param('Position');//接收参数
        $Recruitment=$this->_param('Recruitment');//接收参数 值得????
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn