@H_301_0@

控制层

• 查询

• */
  public function actionSearch()
  {
  //接值
  $where=Yii::$app->request->get();
  //实例化query
  $query=new Query();
  $query->from('stud_user');
  //判断
  if(isset($where['sex'])&&$where['sex']!=''){
  //判断
  if($where['sex']=='男'){
  $query->andWhere(['stud_sex'=>0]);
  }
  if($where['sex']=='女'){
  $query->andWhere(['stud_sex'=>1]);
  }
  }else{
  $where['sex']='';
  }
  //年龄
  if(isset($where['age'])&&$where['age']!=''){
  $query->andWhere(['>','stud_age',$where['age']]);
  }else{
  $where['age']='';
  }
  //分页
  $pagination = new Pagination(['totalCount' => $query->count()]);
  //条数
  $pagination->setPageSize('3');
  //条件
  $query->offset($pagination->offset)->limit($pagination->limit);
  //执行
  $userInfo=$query->all();
  //print_r($userInfo);die;
  return $this->render('search',['userInfo'=>$userInfo,'page'=>$pagination,'where'=>$where]);
  }