PHP Yii框架分页搜索， 个人自创源码，不喜勿碰。
//分页搜索model层
public function selectPage($p,$word){
$size=2;
$page=($p-1)*$size;
$where="";
$haha="";
if(!empty($word)){
$where .=" where brand_name like '%$word%' ";
$haha="&word=$word";
}
$command = Yii::$app->db->createCommand('SELECT count(*) as num FROM '.$this->table." ".$where);
$posts = $command->queryAll();
$num=$posts[0]['num'];
$end=ceil($num/$size);
$xia=$p+1>=$end?$end:$p+1;
$shang=$p-1<=1?1:$p-1;
$comm= Yii::$app->db->createCommand('SELECT * FROM '.$this->table." ".$where." limit $page,$size");
$pos = $comm->queryAll();
$data['page']=$pos;
$data['one']="1";
$data['next']=$xia;
$data['last']=$end;
$data['prev']=$shang;
$data['hhh']=$haha;
return $data;
}
//控制器中调用model分页搜索
//Controller use 路径
use app\models\Brand_add;
use yii\data\Pagination;
public function actionList()
{
$model=new Brand_add;
$p=isset($_GET['p'])?$_GET['p']:1;
$word=isset($_GET['word'])?$_GET['word']:"";
if(empty($word)){
$word=isset($_POST['word'])?$_POST['word']:"";
}
$obj=$model->selectPage($p,$word);
return $this->render("brand_list.html",['data'=>$obj]);
}
//全部视图层展示源码， 懒的整理了， 有点脑子都能看懂。 分页搜索关键字都有。
//视图层
<base href="./public/" />
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" ".dtd">
<html xmlns="">
<head>
<title>SHOP 管理中心 - 品牌管理 </title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="styles/general.css" rel="stylesheet" type="text/css" />
<link href="styles/main.css" rel="stylesheet" type="text/css" />
</head>
<body>
<h1>
<span class="action-span"><a href="../index.php?r=brand/add">添加品牌</a></span>
<span class="action-span1"><a href="../index.php?r=index/main">SHOP 管理中心</a> </span><span id="search_id" class="action-span1"> - 商品品牌 </span>
<div style="clear:both"></div>
</h1>
<div class="form-div">
<form action="../index.php?r=brand/list" name="searchForm" method="post">
<img src="images/icon_search.gif" width="26" height="22" border="0" alt="SEARCH">
<input type="text" name="word" size="15">
<input type="submit" value=" 搜索 " class="button">
</form>
</div>
<form method="post" action="" name="listForm">
<!-- start brand list -->
<div class="list-div" id="listDiv">
<table cellpadding="3" cellspacing="1">
<tbody>
<tr>
<th>品牌名称</th>
<th>品牌网址</th>
<th>品牌描述</th>
<th>排序</th>
<th>是否显示</th>
<th>操作</th>
</tr>
<?php foreach ($data['page'] as $key => $v): ?>
<tr>
<td><img src="../<?=$v['brand_logo']?>" alt="" width="50" height="50" /><?=$v['brand_name']?></td>
<td><?=$v['site_url']?></td>
<td><?=$v['brand_desc']?></td>
<td><?=$v['sort_order']?></td>
<td><?=$v['is_show']?></td>
<td></td>
</tr>
<?php endforeach ?>
<td align="right" nowrap="true" colspan="6">
<div id="turn-page">
<!-- 总计 <span id="totalRecords">11</span>
个记录分为 <span id="totalPages">2</span>
页当前第 <span id="pageCurrent">1</span>
页，每页 <input type="text" size="3" id="pageSize" value="10" οnkeypress="return listTable.changePageSize(event)">
<span id="page-link"> -->
<a href="../index.php?r=brand/list&p=<?php echo $data['one'];?><?php echo $data['hhh'];?>">第一页</a>
<a href="../index.php?r=brand/list&p=<?php echo $data['prev'];?><?php echo $data['hhh'];?>">上一页</a>
<a href="../index.php?r=brand/list&p=<?php echo $data['next'];?><?php echo $data['hhh'];?>">下一页</a>
<a href="../index.php?r=brand/list&p=<?php echo $data['last'];?><?php echo $data['hhh'];?>">最末页</a>
<select id="gotoPage" οnchange="listTable.gotoPage(this.value)">
<option value="1">1</option><option value="2">2</option> </select>
</span>
</div>
</td>
</tr>
</tbody></table>
<!-- end brand list -->
</div>
</form>
<div id="footer">
版权所有 © 牛儿教育 - 都篮子 - </div>
</div>
</body>
</html>
发布评论