控制层
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]);
}
模型层
PHP
namespace frontend\models;
use Yii;
use yii\db\ActiveRecord;
class StudUser extends ActiveRecord
{
/**
* 声明表名
*
*/
public static function tableName()
{
return '{{%stud_user}}';
}
/**
* 验证规则
*
*/
public function rules()
{
return [
['stud_age','integer'],];
}
}
视图层
Url::toRoute(['admin/search']),'method'=>'get',]);
echo '性别'," ",Html::input('text','sex',$where['sex']);
echo '年龄','age',$where['age']);
echo Html::submitButton('提交');
ActiveForm::end();
?>
