php简略数字分页显示代码-php教程-PHP中文网

php简略数字分页显示代码
php中文网
发布： 2016-06-13 10:49:27
原创
1021人浏览过
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];*/$numrows = 1000;// number of rows to show per page$rowsperpage = 10;// find out total pages$totalpages = ceil($numrows / $rowsperpage);// get the current page or set a defaultif (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 = ($currentpage - 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);*/$sql = "SELECT id, number FROM numbers LIMIT $offset, $rowsperpage";echo $sql."<br />";// 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, don't show back linksif ($currentpage > 1) {   // show << link to go back to page 1   echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=1'><<</a> ";   // get previous page num   $prevpage = $currentpage - 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 pagefor ($x = ($currentpage - $range); $x < (($currentpage + $range) + 1); $x++) {   // if it's a valid page number...   if (($x > 0) && ($x <= $totalpages)) {      // if we're on current page...      if ($x == $currentpage) {         // 'highlight' it but don't make a link         echo " [<b>$x</b>] ";      // if not current page...      } else {         // make it a link         echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$x'>$x</a> ";      } // end else   } // end if } // end for                 // if not on last page, show forward and last page links        if ($currentpage != $totalpages) {   // get next page   $nextpage = $currentpage + 1;    // echo forward link for next page    echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$nextpage'>></a> ";   // echo forward link for lastpage   echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$totalpages'>>></a> ";} // end if/****** end build pagination links ******/?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>分页</title><style type="text/css">body{font:12px/1.5em "Century Gothic";}</style></head><body>	<p>摘自：<a href="http://www.phpfreaks.com/tutorial/basic-pagination">http://www.phpfreaks.com/tutorial/basic-pagination</a></p></body></html>
登录后复制