<?
class TurnPage
{
var $cpage;
var $pagesize;
var $prepage;
var $nextpage;
var $recordcount;
var $pagecount; var $sql_limit; //构造函数
function TurnPage($default_pagesize,$num_page,$num_pagesize)
{
$this->cpage=$num_page;
$this->pagesize=$num_pagesize; if($this->pagesize=="")
{
//$this->pagesize=$default_pagesize;
$this->pagesize=10;
}
if($this->cpage=="")
{
$this->cpage=1;
}
} //增加条件
function addCondition($str_table,$str_con)
{
$sqlstr="SELECT COUNT(*) FROM $str_table WHERE $str_con";
$temp_rs=mysql_query($sqlstr);
if(mysql_errno()>0)
{
echo "发生错误!\n$sqlstr";
exit;
}
$temp_row=mysql_fetch_array($temp_rs); $this->recordcount=$temp_row[0];
$this->pagecount=ceil($this->recordcount/$this->pagesize);
if($this->cpage<1){$this->cpage=$this->pagecount;}
if($this->cpage>$this->pagecount){$this->cpage=1;}
$temp_abslocate=($this->cpage-1)*$this->pagesize;
$this->sql_limit=" LIMIT ".$temp_abslocate.",".$this->pagesize;
$this->prepage=$this->cpage-1;
$this->nextpage=$this->cpage+1;
} //生成SQL
function getSQLString($str_fieldlist,$str_tablelist,$str_con)
{
$this->addCondition($str_tablelist,$str_con);
return "SELECT $str_fieldlist FROM $str_tablelist WHERE $str_con".$this->sql_limit;
} //显示工具条
function showtoolbar($str_programe,$str_querystring)
{
?>
<form action='<?echo $str_programe."?".$str_querystring;?>' method=get name="__pagetool">
<table width=100% border=0 cellpadding=0 cellspacing=0>
<tr><td align=right>共<?echo $this->recordcount;?>条 
 第<?echo $this->cpage;?>页/共<?echo $this->pagecount;?>页 
每页<input type=text size=1 maxlength=5 name=pagesize style='font-size:8pt;font-family:Arial,宋体;border:1px solid black;width:20px;' value='<?echo $this->pagesize;?>'>篇| <a href="<?echo $str_programe."?".$str_querystring."&page=1&pagesize=".$this->pagesize;?>">首页</a> | 
<?
if($this->cpage>1)
{
?><a href="<?echo $str_programe."?".$str_querystring."&page=".$this->prepage."&pagesize=".$this->pagesize;?>">上页</a> | <?
}
?>
<?
if($this->cpage<$this->pagecount)
{
?><a href="<?echo $str_programe."?".$str_querystring."&page=".$this->nextpage."&pagesize=".$this->pagesize;?>">下页</a> | <?
}
?>
<a href="<?echo $str_programe."?".$str_querystring."&page=0&pagesize=".$this->pagesize;?>">尾页</a> | 
<input type=text size=3 maxlength=3 style='font-size:8pt;font-family:Arial,宋体;border:1px solid black;width:20px;' name=page>
<input type=submit value='GO!' style='font-size:9pt;font-family:Arial,宋体;border-width:1px;border-style:solid;border-color:#FFFFFF #AAAAAA #AAAAAA #FFFFFF;background-image:URL(images/button_bg.gif);'>
</td>
</tr>
</table>
</form>
<?
}
}
?><?
session_start();
$obj_page=new TurnPage(20,$HTTP_GET_VARS["page"],$HTTP_GET_VARS["pagesize"]);
$sqlstr=$obj_page->getSQLString("r.mr_id,r.mr_type,c.mc_title,u.truename,c.mc_createtime,c.mc_id","tab_messages_content as c,tab_messages_ref as r,tab_admins as u","c.mc_id=r.mc_id AND r.mr_toid=$session_userid AND u.userid=c.mser_fromid ORDER BY c.mc_createtime DESC");
$rs=mysql_query($sqlstr);
?><?$obj_page->showtoolbar("main.php4","");?><?
while($row=mysql_fetch_array($rs))
{
        表格
}
?>