/**
* 分页 控制器
*/
public function actionFenye(){
$data=\Yii::$app->db->createCommand("select * from account")->queryAll();
//总记录数
$count=count($data);
//每页的条数
$onepage=5;
//总页数
$overpage=ceil($count/$onepage);
$page=isset($_POST['page'])?$_POST['page']:1;
//偏移量
$start=($page-1)*$onepage;
$u_sel=\Yii::$app->db->createCommand("select * from account limit $start,$onepage")->queryAll();
//var_dump($u_sel);die;
$str="<a href='javascript:void(0)' οnclick='ajax_page(1)'>首页</a>";
$up_page=$page-1<1?1:$page-1;
$str.="<a href='javascript:void(0)' οnclick='ajax_page($up_page)'>上一页</a>";
$down_page=$page+1>$overpage?$overpage:$page+1;
$str.="<a href='javascript:void(0)' οnclick='ajax_page($down_page)'>下一页</a>";
$str.="<a href='javascript:void(0)' οnclick='ajax_page($overpage)'>尾页</a>";
// $this->assign('u_sel',$u_sel);
// $this->assign('page',$str);
// $this->display('gly_list_pro');
return $this->render('design_fenye',array("u_sel"=>$u_sel,'page'=>$str));
}
//视图层
<script type="text/javascript">
/*分页*/
function ajax_page(page) {
//创建ajax对象
var ajax = new XMLHttpRequest();
//ajax事件
ajax.onreadystatechange = function () {
if (ajax.readyState == 4 && ajax.status == 200) {
//alert(ajax.responseText)
document.getElementById('content').innerHTML = ajax.responseText;
}
}
//与服务器建立连接
ajax.open('post', 'index.php?r=admin/fenye');
ajax.setRequestHeader('Content-type', 'application/x-www-form-urlencoded');
ajax.send('page=' + page);
}
分页
最新推荐文章于 2023-08-31 20:55:13 发布