Thinkphp paging implementation, thinkphp paging implementation
The implementation of thinkphp paging is divided into two types: one is to call the Function Method in the public function, and the other is to write the paging method in the model, the following is a list of friends who need it.
I. Paging Method
/*** Encapsulate the same code of the TODO basic paging to reduce the front-end code. * @ param $ m model, pass reference * @ param $ where query condition * @ param int $ pagesize the number of queries per Page * @ return \ Think \ Page */function getpage (& $ m, $ where, $ pagesize = 10) {$ m1 = clone $ m; // copy a model in a shortest mode $ count = $ m-> where ($ where)-> count (); // after a connection operation, the join operation and other operations are reset $ m = $ m1; // this operation is a reserved operation, copy a model $ p = new Think \ Page ($ count, $ pagesize); $ p-> lastSuffix = false; $ p-> setConfig ('head ', '<li class = "rows"> total <B> % TOTAL_ROW % </B> records per page <B> % LIST_ROW % </B> <B> % NOW_PAGE % </B> page/total <B> % TOTAL_PAGE % </B> page </li> '); $ p-> setConfig ('prev', 'previous page'); $ p-> setConfig ('Next', 'next page'); $ p-> setConfig ('last ', 'Last page'); $ p-> setConfig ('first ', 'homepage'); $ p-> setConfig ('Theme ', '% FIRST % UP_PAGE % LINK_PAGE % DOWN_PAGE % END % HEADER %'); $ p-> parameter = I ('get. '); $ m-> limit ($ p-> firstRow, $ p-> listRows); return $ p ;}
The getpage method can be placed in the Application/Common/function of the TP framework. php. This document can be specifically used to place some common methods where they can be called (such as Controller files and View files ).
Ii. Call the paging Method
$m=M('products');$p=getpage($m,$where,10);$list=$m->field(true)->where($where)->order('id desc')->select();$this->list=$list;$this->page=$p->show();
View code
<div class="pagination"> {$page}</div>
III,The last step is the paging style. This is a bit messy. Because the background framework has been downloaded online, the style has not been prepared yet. This style can also be implemented by yourself, which is simple.
.pagination ul { display: inline-block; margin-bottom: 0; margin-left: 0; -webkit-border-radius: 3px; -moz-border-radius: 3px; border-radius: 3px; -webkit-box-shadow: 0 1px 2px rgba(0,0,0,0.05); -moz-box-shadow: 0 1px 2px rgba(0,0,0,0.05); box-shadow: 0 1px 2px rgba(0,0,0,0.05);}.pagination ul li { display: inline;}.pagination ul li.rows { line-height: 30px; padding-left: 5px;}.pagination ul li.rows b{color: #f00}.pagination ul li a, .pagination ul li span { float: left; padding: 4px 12px; line-height: 20px; text-decoration: none; background-color: #fff; background: url('../images/bottom_bg.png') 0px 0px; border: 1px solid #d3dbde; /*border-left-width: 0;*/ margin-left: 2px; color: #08c;}.pagination ul li a:hover{ color: red; background: #0088cc;}.pagination ul li.first-child a, .pagination ul li.first-child span { border-left-width: 1px; -webkit-border-bottom-left-radius: 3px; border-bottom-left-radius: 3px; -webkit-border-top-left-radius: 3px; border-top-left-radius: 3px; -moz-border-radius-bottomleft: 3px; -moz-border-radius-topleft: 3px;}.pagination ul .disabled span, .pagination ul .disabled a, .pagination ul .disabled a:hover {color: #999;cursor: default;background-color: transparent;}.pagination ul .active a, .pagination ul .active span {color: #999;cursor: default;}.pagination ul li a:hover, .pagination ul .active a, .pagination ul .active span {background-color: #f0c040;}.pagination ul li.last-child a, .pagination ul li.last-child span { -webkit-border-top-right-radius: 3px; border-top-right-radius: 3px; -webkit-border-bottom-right-radius: 3px; border-bottom-right-radius: 3px; -moz-border-radius-topright: 3px; -moz-border-radius-bottomright: 3px;}.pagination ul li.current a{color: #f00 ;font-weight: bold; background: #ddd}