常用php函数[07]：分页（两个函数配合使用）

1. <?php
2. function getpage($sql,$page_size=20)
3. {
4.       global $page,$totalpage,$sums;  //out param
5.       $page = $_GET["page"];
6.       //$eachpage = $page_size;
7.       $pagesql = strstr($sql," from ");
8.       $pagesql = "select count(*) as ids ".$pagesql;
9.       $result = mysql_query($pagesql);
10.       if($rs = mysql_fetch_array($result)) $sums = $rs[0];
11.       $totalpage = ceil($sums/$page_size);
12.       if((!$page)||($page<1)) $page=1;
13.   $startpos = ($page-1)*$page_size;
14.   $sql .=" limit $startpos,$page_size ";
15.     return $sql;
16. }
17.  
18. function showbar($string="")
19. {   
20.     global $page,$totalpage;
21. $out="共<font color='red'><b>".$totalpage."</b></font>页  ";
22.     $linkNum =4;
23.     $start = ($page-round($linkNum/2))>0 ? ($page-round($linkNum/2)) : "1";
24.     $end  = ($page+round($linkNum/2))<$totalpage ? ($page+round($linkNum/2)) : $totalpage;
25.     $prestart=$start-1;
26.     $nextend=$end+1;
27.     if($page<>1)
28. $out .= "<a href='?page=1&&".$string."'title=第一页>第一页</a> ";
29.     if($start>1)
30. $out.="<a href='?page=".$prestart."' title=上一页>..<<</a> ";
31. for($t=$start;$t<=$end;$t++)
32.     {
33.     $out .= ($page==$t) ? "<font color='red'><b>[".$t."]</b></font> " : "<a href='?page=$t&&".$string."'>$t</a> ";
34.     }
35. if($end<$totalpage)
36. $out.="<a href='?page=".$nextend."&&".$string."' title=下一页>>>..</a>";
37.     if($page<>$totalpage)
38.   $out .= " <a href='?page=".$totalpage."&&".$string."' title=最后页>最后页</a>";
39.   return $out;
40. }
41.  
42. ?>