Db::name(“table”)->where(“XXXX”)->paginate(10,false,[‘query’=>request()->param()]);
PHP:
$get = input(‘get.’);
$phone = input(‘get.phone’);
$email = input(‘get.email’);
$pageParam = [‘query’ =>[]];
if ($phone) {
$userModel->where(‘phone’, ‘like’, “%{$phone}%”);
$this->assign(‘phone’, $phone);
$pageParam[‘query’][‘phone’] = $phone;
}
if ($email) {
$userModel->where(‘email’, ‘like’, “%{$email}%”);
$this->assign(‘email’, $email);
$pageParam[‘query’][‘email’] = $email;
}
$list = $userModel->paginate(3, false, $pageParam);
$this->assign(‘list’, $list);
$this->assign(‘title’, ‘会员列表’);
$this->assign(‘breadcrumb’, [‘后台首页’, ‘用户管理’, ‘会员列表’]);
return $this->fetch();
HTML:
{volist name=’list’ id=’user’}
{/volist}
| ID | 妮称 | 手机 | 邮箱 | |
|---|---|---|---|---|
| {$user.id} | {$user.nickname} | {$user.phone} | {$user.email} |
{$list->render()}
