thinkphp条件查询和模糊查询的一些方法
1 #文章管理 2 public function adminArticle(){ 3 $adminArticle=M("article"); 4 $arr_seach=$this->seach($adminArticle,10,"now desc","");//参数格式seach($db,$num,$order,$where) 5 ##按最早排序 6 if(!@empty($_POST[‘time‘])){ 7 $arr_seach=$this->seach($adminArticle,10,"now asc",""); 8 } 9 ##按作者查询 10 if(!@empty($_POST[‘author‘])){ 11 $arr_seach=$this->seach($adminArticle,10,"now asc","author=‘{$_POST[‘author‘]}‘"); 12 } 13 ##按标签查询 14 if(!@empty($_POST[‘classify‘])){ 15 $arr_seach=$this->seach($adminArticle,10,"now asc","classify=‘{$_POST[‘classify‘]}‘"); 16 } 17 ##模糊查询 18 if(!@empty($_POST[‘seach‘])){ 19 $map[‘title‘] =array(‘like‘,"%{$_POST[‘seach‘]}%",‘or‘); 20 $arr_seach=$this->seach($adminArticle,10,"now desc",$map); 21 } 22 ##输出到view 23 $selectArticle=$arr_seach[‘selectArticle‘]; 24 $show=$arr_seach[‘show‘]; 25 $arr_index=array( 26 "selectArticle"=>$selectArticle, 27 "page"=>$show 28 ); 29 $this->assign($arr_index); 30 $this->display(); 31 } 32 ##一个查询方法 33 public function seach($db,$num,$order,$where){ 34 $count = $db->where($where)->count();// 35 $Page = new \Think\Page($count,$num);// 实例化分页类 传入总记录数和每页显示的记录数(25) 36 $show = $Page->show();// 分页显示输出 37 38 $selectArticle=$db->order($order)->where($where)->limit($Page->firstRow.‘,‘.$Page->listRows)->Field(‘id,author,title,classify,now‘)->select(); 39 40 return $arr_page = array( 41 "show"=>$show, 42 "selectArticle"=>$selectArticle, 43 ); 44 }
郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。