PHP中常用的分页类总结剖析.docx

PHP 中常用的分页类总结 分页是目前在显示大量结果时所采用的最好的方式。 有了下面这些代码的帮助， 开发人员可以在多个页面中显示大量的数据。 在互联网上， 分页是一般用于有哪些信誉好的足球投注网站结果或是浏览全部信息 php 基本分页 代码如下 复制代码 ?php // database connection info $conn = mysql_connect(localhost,dbusername,dbpass) or trigger_error(SQL, E_USER_ERROR); $db = mysql_select_db(dbname,$conn) or trigger_error(SQL, E_USER_ERROR); // find out how many rows are in the table $sql = SELECT COUNT(*) FROM numbers; $result = mysql_query($sql, $conn) or trigger_error(SQL, E_USER_ERROR); $r = mysql_fetch_row($result); $numrows = $r[0]; number of rows to show per page $rowsperpage = 10; find out total pages $totalpages = ceil($numrows / $rowsperpage); // get the current page or set a default if (isset($_GET[currentpage]) is_numeric($_GET[currentpage])) { // cast var as int $currentpage = (int) $_GET[currentpage]; } else { // default page num $currentpage = 1; } // end if if current page is greater than total pages... if ($currentpage $totalpages) { set current page to last page $currentpage = $totalpages; } // end if // if current page is less than first page... if ($currentpage 1) { set current page to first page $currentpage = 1; } // end if the offset of the list, based on current page $offset = ($current 1) * $rowsperpage; get the info from the db $sql = SELECT id, number FROM numbers LIMIT $offset, $rowsperpage; $result = mysql_query($sql, $conn) or trigger_error(SQL, E_USER_ERROR); while there are rows to be fetched... while ($list = mysql_fetch_assoc($result)) { echo data echo $list[id] . : . $list[number] . br /; } // end while /****** build the pagination links ******/ range of num links to show $range = 3; if not on page 1, dont show back links if ($currentpage 1) { show link to go back to page 1 echo a href={$_SERVER[PHP_SELF]}?currentpage=1/a ; // get previous page num $prevpage = $current 1; // show link to go back to 1 page echo a href={$_SERVER[PHP_SELF]}?currentpage=$prevpage/a ; } // end if // loop to show links to range of pages around current page for ($x = ($curren