& Lt ;! DOCTYPEhtmlPUBLIC-// W3C // DTDXHTML1.0Transitional // ENhttp: // Configure
Php make page list
$ Page_size = 10;
$ Result = mysql_query (select * from v_char );
$ Count = mysql_num_rows ($ result );
$ Page_count = ceil ($ count/$ Page_size );
$ Init = 1;
$ Page_len = 7;
$ Max_p = $ page_count;
$ Pages = $ page_count;
// Determine the current page number
If (empty ($ _ GET [page]) | $ _ GET [page] <0 ){
$ Page = 1;
} Else {
$ Page = $ _ GET [page];
}
$ Offset = $ Page_size * ($ page-1 );
$ SQL = "select * from v_char limit $ offset, $ Page_size ";
$ Result = mysql_query ($ SQL, $ link );
While ($ row = mysql_fetch_array ($ result )){
?>
}
$ Page_len = ($ page_len % 2 )? $ Page_len: $ pagelen + 1; // Number of page numbers
$ Pageoffset = ($ page_len-1)/2; // page number offset between left and right
$ Key =;
$ Key. = "$ page/$ pages"; // page
If ($ page! = 1 ){
$ Key. = "PHP_SELF]."? Page = 1 "> page 1"; // page 1
$ Key. = "previous page"; // Previous Page
} Else {
$ Key. = "first page"; // first page
$ Key. = "previous page"; // Previous Page
}
If ($ pages> $ page_len ){
// If the current page is less than or equal to the left offset
If ($ page <= $ pageoffset ){
$ Init = 1;
$ Max_p = $ page_len;
} Else {// if the current page is greater than the left offset
// If the right offset of the current page number exceeds the maximum page number
If ($ page + $ pageoffset >=$ pages + 1 ){
$ Init = $ pages-$ page_len + 1;
} Else {
// Calculation when both the left and right offsets exist
$ Init = $ page-$ pageoffset;
$ Max_p = $ page + $ pageoffset;
}
}
}
For ($ I = $ init; $ I <= $ max_p; $ I ++ ){
If ($ I = $ page ){
$ Key. =. $ I .;
} Else {
$ Key. = "". $ I ."";
}
}
If ($ page! = $ Pages ){
$ Key. = "next page"; // Next page
$ Key. = "Last page"; // Last Page
} Else {
$ Key. = "next page"; // Next page
$ Key. = "Last page"; // Last Page
}
$ Key. =;
?>
| ID |
Article title |
/** Created on 2010-4-17** Order by Kove Wong*/$ Link = MySQL_connect (localhost, root, haoxiazai1987 );Mysql_select_db (pagelist );Mysql_query (set names gbk );
|
|
| |