ThinkPHP paging implementation and thinkphp paging implementation
In the TP3.2 framework manual, there is a data paging, but too much code should be written every time, and there are some troubles in Chinese settings. As a program developer, it is necessary to sort it out:
O. First View
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 & nbsp; <B> % LIST_ROW % </B> entries per page & nbsp; page <B> % NOW_PAGE % </B>/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>
3. Finally, it is the paging style. This is a bit messy, because the background framework has been downloaded online, and the style has not been prepared yet. This style can also be implemented by itself, 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}
How does thinkphp implement paging and email sending?
Pagination of TP is actually very simple:
First, you need to import the paging class.
The Code is as follows:
$ User = M ('user'); // instantiate the User object
Import ('org. Util. page'); // import the paging class
$ Count = $ User-> where ('status = 1')-> count (); // query the total number of records meeting the requirements
$ Page = new Page ($ count, 25); // The total number of incoming records and the number of records displayed on each Page are instantiated in the paging class.
$ Show = $ Page-> show (); // display the output by Page
// Perform paging data query. Note that the parameters of the limit Method must use the attributes of the Page class.
$ List = $ User-> where ('status = 1')-> order ('create _ Time')-> limit ($ Page-> firstRow. ','. $ Page-> listRows)-> select ();
$ This-> assign ('LIST', $ list); // assign a value to a dataset
$ This-> assign ('page', $ show); // value-assigned paging output
$ This-> display (); // output Template
Thinkphp data paging (article paging)
On the page of the article, I remember there should be a thinkphpcms. You should look for the installation to see how it was written .. Your line --