分页

来源:互联网 发布:floyd算法流程图 编辑:程序博客网 时间:2024/05/17 17:18
/**     * 分页       控制器     */     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)' onclick='ajax_page(1)'>首页</a>";        $up_page=$page-1<1?1:$page-1;        $str.="<a href='javascript:void(0)' onclick='ajax_page($up_page)'>上一页</a>";        $down_page=$page+1>$overpage?$overpage:$page+1;        $str.="<a href='javascript:void(0)' onclick='ajax_page($down_page)'>下一页</a>";        $str.="<a href='javascript:void(0)' onclick='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);     }

0 0
原创粉丝点击