Php paging principle analysis and php paging code design
-
// Php paging code
- // Bbs.it-home.org
- Include ("conn. php ");
- $ Pagesize = 5; // records displayed on each page
- $ Startrow = 0; // The Record header of the current page
- If (empty ($ _ GET ['pageno']) {
- If ($ startrow = 0 ){
- $ Pageno = $ startrow + 1;
- }
- } Else {
- $ Pageno = $ _ GET ['pageno'];
- $ Startrow = ($ pageno-1) * $ pagesize;
- }
- $ SQL = "select * from test ";
- $ Result1 = mysql_query ($ SQL, $ conn );
- $ Resultcount = mysql_num_rows ($ result1 );
- If ($ resultcount % $ pagesize = 0 ){
- $ Maxpage = $ resultcount/$ pagesize;
- } Else {
- $ Maxpage = ceil ($ resultcount/$ pagesize );
- }
-
$ Result = mysql_query ("select * from test LIMIT $ startrow, $ pagesize ");
- While ($ row = mysql_fetch_array ($ result )){
- Echo $ row ["name"].'
';
- }
- ?>
- Total Page
- Homepage
- Previous Page
- Next page
- "> Last Page
|
