1、3、5、6、7、8、9 关于分页

Question

一般都是用url传递值，例如
http://localhost/test.php?page=4

Answer 1

请参考：<?php  
/*  
           function:break  page  
           author:  
           date:2003.7.15  
           parameter:  
 
           num=all  of  your  pages;  
           perpage=  how  many  do  you  want  to  show;  
           curr_page=current  page;  
           mpurl=current  url;  
 
           return:  
           multipage=a  string  under  your  page  
*/  
function  multi($num,  $perpage,  $curr_page,  $mpurl)  
           {  
                       if($num  >  $perpage)  
                                   {  
                                               $page  =  10;  
                                               $offset  =  2;  
 
                                               $pages  =  ceil($num  /  $perpage);//得到页数  
                                               $from  =  $curr_page  -  $offset;//偏移两页  
                                               $to  =  $curr_page  +  $page  -  $offset  -  1;  
                                   if($page  >  $pages)    
                                               {  
                                                           $from  =  1;  
                                                           $to  =  $pages;  
                                               }    
                                   else  
                                               {  
                                               if($from  <  1)  
                                                           {  
                                                                       $to  =  $curr_page  +  1  -  $from;  
                                                                       $from  =  1;  
                                                           if(($to  -  $from)  <  $page  &&  ($to  -  $from)  <  $pages)    
                                                                       {  
                                                                                   $to  =  $page;  
                                                                       }  
                                                           }    
                                               elseif($to  >  $pages)  
                                                           {  
                                                                       $from  =  $curr_page  -  $pages  +  $to;  
                                                                       $to  =  $pages;  
                                                                       if(($to  -  $from)  <  $page  &&  ($to  -  $from)  <  $pages)  
                                                                                   {  
                                                                                               $from  =  $pages  -  $page  +  1;  
                                                                                   }  
                                                           }  
                                               }  
                                   $fwd_back  .=  "<a  href=\"$mpurl&page=1\">&lt;&lt;</a>  &nbsp;";  
                                   for($i  =  $from;  $i  <=  $to;  $i++)  
                                               {  
                                                           if($i  !=  $curr_page)  
                                                                       {  
                                                                                   $fwd_back  .=  "<a  href=\"$mpurl&&page=$i\">[$i]</a>&nbsp;";  
                                                                       }  
                                                           else  
                                                                       {  
                                                                                   $fwd_back  .=  "<u><b>[$i]</b></u>&nbsp;";  
                                                                       }  
                                               }  
                                   $fwd_back  .=  $pages  >  $page  ?  "  ...  <a  href=\"$mpurl&&page=$pages\">  [$pages]  &gt;&gt;</a>"  :  "  <a  href=\"$mpurl&&page=$pages\">&gt;&gt;</a>";  
                                   $multipage  =  $fwd_back;  
                                   }  
           return  $multipage;  
           }  
 
//use  
 
//分页开始  
 
/*  
如果你有一个表叫XXXX，里面有字段叫cid和time,那么可以这样使用。第一次查询出总数num，第二次是进行你所要进行的真正查询，如内容什么的，  
mpurl是你当前页面的url，multipage是最后得到的一个分页串，  
*/  
$table="XXXX";  
$sql1            =  "SELECT  COUNT(*)  AS  rcnt  FROM  $table  where  cid=$cid  ORDER  BY  time  DESC";  
$result1      =  @mysql_query($sql1);  
$array1        =  @mysql_fetch_array($result1);  
$num              =  $array1[rcnt];  
$mpurl          =  "XXXX.php?cid=$cid";  
if(!empty($page))  {  
           $start_limit  =  ($page  -  1)  *    $morenum;  
}  
else  {  
           $start_limit  =  0;  
           $page  =  1;  
}  
$multipage  =  multi($num,$morenum,$page,$mpurl);  
$sql="select  *  from  $table  where  cid=$cid  order  by  time  desc  limit  $start_limit,$morenum";  
//分页结束  
$result      =  @mysql_query($sql);  
while($array        =  @mysql_fetch_array($result)){  
           XXXXX;  
           }//至此已取得数组，不用我再写了吧，我得回家了。  
 
?>