use frontend/models/StudUser;use yii/data/Pagination;use yii/db/Query;/** * 查詢 * */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()]);  //條數(shù)  $pagination->setPageSize('3');  //條件  $query->offset($pagination->offset)->limit($pagination->limit);  //執(zhí)行  $userInfo=$query->all();  //print_r($userInfo);die;  return $this->render('search',['userInfo'=>$userInfo,'page'=>$pagination,'where'=>$where]);}

<?phpnamespace frontend/models;use Yii;use yii/db/ActiveRecord;class StudUser extends ActiveRecord{  /**   * 聲明表名   *   */   public static function tableName()   {     return '{{%stud_user}}';   }  /**   * 驗證規(guī)則   *   */  public function rules()  {    return [      ['stud_age','integer'],    ];  }}

<?phpuse yii/widgets/ActiveForm;use yii/helpers/Url;use yii/helpers/Html;use yii/widgets/LinkPager;?><?php$form=ActiveForm::begin([  'action'=>Url::toRoute(['admin/search']),  'method'=>'get',]);echo '性別'," ",Html::input('text','sex',$where['sex']);echo '年齡'," ",Html::input('text','age',$where['age']);echo Html::submitButton('提交');ActiveForm::end();?><table class="table"><tr>  <td>序號</td>  <td>姓名</td>  <td>年齡</td></tr>  <?php foreach($userInfo as $val):?>    <tr>      <td><?= $val['stud_id']?></td>      <td><?= $val['stud_name']?></td>      <td><?= $val['stud_age']?></td>    </tr>  <?php endforeach;?></table><?phpecho LinkPager::widget([  'pagination' => $page,  'nextPageLabel'=>'下一頁' ]);?>