首先有一个名为admin的表,字段有adminName和adminPwd.
HTML:
<form action="" method="post" name="form1">
查询关键字<input type="text" name="keyword" id="" value="{$keyword}">
<input type="submit" name="" id="" value="查询">
</form>
<tr><td>姓名</td><td>密码</td></tr>
{foreach name="admin" item="data"}
<td>{$data['adminName']}</td>
<td>{$data['adminPwd']}</td>
{/foreach}
{$admin->render()}
CSS:
<style>
.pagination li{
list-style: none;
display: inline-block;
width: 30px;
}
</style>
控制器:
public function index(){
$keyword = input('keyword');
$search['query']['keyword'] = $keyword;
$admin = Db::name('Admin')->where('adminName','like',"%{$keyword}%")->paginate(2,false,$search);
// $list=->select();//列出所有数据
$this->assign('admin',$admin);
$this->assign('keyword',$keyword);
return view();
}