代码如下：
0 ? intval($page) : 1;$conn = mysql_connect(127.0.0.1,root,) or die('连接数据库失败');mysql_select_db(demo,$conn);mysql_query(set names utf8);$pagesize = 10;//每页显示的数据$showpage = 5;//显示页码$sql = select * from demo limit .($page-1)*$pagesize.,.$pagesize;$result = mysql_query($sql,$conn);echo '';echo 'id name
';while($row = mysql_fetch_assoc($result)){ echo ''; echo ''.$row['id'].' '; echo ''.$row['name'].' '; echo '
';}echo '
';mysql_free_result($result);$total_sql = select count(*) from demo;$total_result = mysql_fetch_array(mysql_query($total_sql));$total = $total_result[0];//计算总页数$total_page = ceil($total/$pagesize);mysql_close($conn);/*分页条*/$page_banner = '';//偏移量$pageoffset = ($showpage-1)/2;if ($page > 1) { $page_banner .= '首页 '; $page_banner .= '<<上一页 ';} else { $page_banner .= '首页'; $page_banner .= ' $pageoffset+1) { $page_banner.= '...'; } if ($page > $pageoffset) { //开始位置总是当前页-偏移量 $start = $page - $pageoffset; //右边的显示码加偏移量小于总页数就显示当前页+偏移量否则就显示最后页 $end = $total_page > ($page + $pageoffset) ? ($page + $pageoffset) : $total_page; } else { $start = 1; $end = $total_page > $showpage ? $showpage : $total_page; } if ($page+$pageoffset > $total_page) { //实际的开始位置-(当前位置+偏移量-最后一页) $start = $start - ($page + $pageoffset - $end); }}for($i = $start; $i $showpage && $total_page > $page + $pageoffset) { $page_banner.= '...';}//page endif ($page >'; $page_banner .= '尾页';} else { $page_banner .= '下一页>>'; $page_banner .= '尾页';}$page_banner .= '共'.$total_page.'页';$page_banner .= '到第';$page_banner .= '页';$page_banner .= '';$page_banner .= '
';echo $page_banner;