pager alternatives

) { $page _string. = ' first page | previous page | '; } else{ $page _string. = ' } if ($page = = $page _count) | | ($page _count = 0)) { $page _string. = ' next page | last '; } else{ $page _string. = ' } Gets the data and returns the result in a two-dimensional array format if ($amount) { $sql = "SELECT * from table ORDER BY id desc limit". ($page-1) * $page _size. ", $page _size"; $result = mysql_query ($sql); while ($row = Mysql_fetch_row ($result)) { $rowset [] = $row; } }else{ $rowset = A

$page _string = ';if ($page = = 1) {$page _string. = ' first page | previous page | ';}else{$page _string. = ' }if ($page = = $page _count) | | ($page _count = 0)) {$page _string. = ' next page | last ';}else{$page _string. = ' }Gets the data and returns the result in a two-dimensional array formatif ($amount) {$sql = "SELECT * from table ORDER BY id desc limit". ($page-1) * $page _size. ", $page _size";$result = mysql_query ($sql);while ($row = Mysql_fetch_row ($result)) {$rowset [] = $row;}}el

| ';}else{$page _string. = ' }if ($page = = $page _count) | | ($page _count = 0)) {$page _string. = ' next page | last ';}else{$page _string. = ' }Gets the data and returns the result in a two-dimensional array formatif ($amount) {$sql = "SELECT * from table ORDER BY id desc limit". ($page-1) * $page _size. ", $page _size";$result = mysql_query ($sql);while ($row = Mysql_fetch_row ($result)) {$rowset [] = $row;}}else{$rowset = Array ();}There is no code to display the results, which is not in t

results of each page (} } else{ $page _count = 0; } Page links$page _string = ';if ($page = = 1) {$page _string. = ' first page | previous page | ';}else{$page _string. = ' first page | Previous page | ';}if ($page = = $page _count) | | ($page _count = 0)) {$page _string. = ' next page | last ';}else{$page _string. = ' next page | last ';}Gets the data and returns the result in a two-dimensional array formatif ($amount) {$sql = "SELECT * from table ORDER BY id desc limit". ($page-1) * $

. 3) set the size: In the Bootstrap framework, you can also set the size in several different cases. Similar to buttons: "Pagination-lg" is used to increase paging navigation; Use pagination-sm to reduce the paging Navigation: … … … 4) implementation principle of size setting: In practice, the corresponding padding font-size and angular sizes are added. The source code is 4,193rd rows for the bootstrap.css

; } Page links $page _string = '; if ($page = = 1) { $page _string. = ' first page | previous page | '; } else{ $page _string. = ' } if ($page = = $page _count) | | ($page _count = 0)) { $page _string. = ' next page | last '; } else{ $page _string. = ' } Gets the data and returns the result in a two-dimensional array format if ($amount) { $sql = "SELECT * from table ORDER BY id desc limit". ($page-1) * $page _size. ", $page _size"; $result = mysql_query ($sql); while ($ro

($page = = 1) { $page _string. = ' first page | previous page | '; } else{ $page _string. = ' } if ($page = = $page _count) | | ($page _count = 0)) { $page _string. = ' next page | last '; } else{ $page _string. = ' } Gets the data and returns the result in a two-dimensional array format if ($amount) { $sql = "SELECT * from table ORDER BY id desc limit". ($page-1) * $page _size. ", $page _size"; $result = mysql_query ($sql); while ($row = Mysql_fetch_row ($result)) { $rowset [] = $row; } }els

Front desk Copy Code code as follows: Paging class Copy Code code as follows: [Serializable] public class Pager { public int totalrecords; public int pageSize; public int pageIndex; public int totalpages; } After his code Copy Code code as follows: Using System; Using System.Collections.Generic; Using System.Linq; Using System.Web; Using System.Web.UI; Using System.Web.UI.WebControl

database connection in the following code uses the pear db class for processing. // FileName: Pager. class. php// Paging class. this class is only used to process the data structure and is not used to process the display.Class Pager{Var $ PageSize; // Number of pages per pageVar $ CurrentPageID; // Current page numberVar $ NextPageID; // Next pageVar $ PreviousPageID; // Previous PageVar $ numPages; // T

codeThe database connection in the following code uses the pear db class for processing. // FileName: Pager. class. php// Paging class. this class is only used to process the data structure and is not used to process the display.Class Pager{Var $ PageSize; // Number of pages per pageVar $ CurrentPageID; // Current page numberVar $ NextPageID; // Next pageVar $ PreviousPageID; // Previous PageVar $ numPag

= $ amount/$ page_size; // if there is no remainder, the number of pages equals the total data volume divided by the result of each page } } Else { $ Page_count = 0; } // Flip link$ Page_string = '';If ($ page = 1 ){$ Page_string. = 'Page 1 | previous page | ';}Else {$ Page_string. = 'Page 1 | previous page | ';}If ($ page = $ page_count) | ($ page_count = 0 )){$ Page_string. = 'next page | last page ';}Else {$ Page_string. = 'next page | last page ';}// Obtain data and return results in two-d

command to mysql service help (\ h) Display this help. nopager (\ n) Disable pager, print to stdout. -- close the page settings and print it to the standard output notee (\ t) Don't write into outfile. -- disable pager (\ P) Set PAGER [to_pager]. print the query results via PAGER. -- set the

(\ G) Send command to mysql server, display resu Lt vertically. -- the control result is displayed as vertical exit (\ q) Exit mysql. same as quit. -- exit mysqlgo (\ g) Send command to mysql server. -- send the command to mysql service help (\ h) Display this help. nopager (\ n) Disable pager, print to stdout. -- close the page settings and print it to the standard output notee (\ t) Don't write into outfile. -- disable

($ page = 1 ){$ Page_string. = 'Page 1 | previous page | ';}Else {$ Page_string. = 'Page 1 | previous page | ';}If ($ page = $ page_count) | ($ page_count = 0 )){$ Page_string. = 'next page | last page ';}Else {$ Page_string. = 'next page | last page ';}// Obtain data and return results in two-dimensional array formatIf ($ amount ){$ SQL = "select * from table order by id desc limit". ($ page-1) * $ page_size. ", $ page_size ";$ Result = mysql_query ($ SQL );While ($ row = mysql_fetch_row ($ re

; } // Flip link $ Page_string = ''; If ($ page = 1 ){ $ Page_string. = 'Page 1 | previous page | '; } Else { $ Page_string. = 'Page 1 | previous page | '; } If ($ page = $ page_count) | ($ page_count = 0 )){ $ Page_string. = 'next page | last page '; } Else { $ Page_string. = 'next page | last page '; } // Obtain data and return results in two-dimensional array format If ($ amount ){ $ SQL = "select * from table order by id desc limit". ($ page-1) * $ page_size. ", $ page_size "; $ Result = my

{ $ Page_string. = '"; first page | previous page | '; } If ($ page = $ page_count) | ($ page_count = 0 )){ $ Page_string. = 'next page | last page '; } Else { $ Page_string. = 'next page | last page '; } // Obtain data and return results in two-dimensional array format If ($ amount ){ $ SQL = "select * from table order by id desc limit". ($ page-1) * $ page_size. ", $ page_size "; $ Result = mysql_query ($ SQL ); While ($