php好看的分页类下载,php经典分页类

php经典分页类

class db

{

public $conn,$db,$table,$user,$host,$unm,$pwd;

public $res;

public $char;

public $linkType;

function __construct($linkType=false,$char="gb2312")

{

$this->linkType=$linkType;//设定连接类型

$this->char=$char;//设定连接校对字符

$this->db=DB;

$this->user=USER;

$this->host=HOST;

$this->unm=UNM;

$this->pwd=PWD;

if($this->linkType)

{

$this->conn=mysql_pconnect($this->host,$this->unm,$this->pwd) or die("Database connection failure");

}

else

{

$this->conn=mysql_connect($this->host,$this->unm,$this->pwd) or die("Database connection failure");

}

mysql_select_db($this->db);

mysql_query("set names ".$this->char);

}

function query($sql,$type="true")

{

//$type:默认的操作。 指代select操作

$this->res=mysql_query($sql) or die("SQL Statement error !Please check it again");

$row=$type?mysql_num_rows($this->res):mysql_affected_rows();

$result["res"]=$this->res;

$result["row"]=$row;

return $result;

}

//fetch()方法：获取所有的记录，并写入数组

function fetch($sql)

{

$res=self::query($sql);

while ($rs=mysql_fetch_array($res["res"]))

{

$result[]=$rs;

}

return $result;

}

//获取下一条记录

function fetchNext($filed,$currenID,$table)

{

$sql="select * from $table where $filed>$currenID limit 0,1 ";

return self::fetch($sql);

}

//获取前一条记录

function fetchPre($filed,$currenID,$table)

{

$sql="select * from $table where $filed

return self::fetch($sql);

}

}

class page extends db

{

public $currentPage,$totalRecord,$totalPage,$pageSize;

public $start;

public $flag;

public $sql;

function __construct($sql,$pagesize=5,$flag="page")

{

$this->sql=$sql;

$this->pageSize=$pagesize;

$this->flag=$flag;//设定翻页链接标识符

$row=parent::query($sql);

$this->totalRecord=$row["row"];

$this->totalPage=ceil($this->totalRecord/$this->pageSize);

$page=$_REQUEST[$this->flag];

if($page<0||$page=="")

{

$this->currentPage=1;

}

else

{

$page>$this->totalPage?$this->currentPage=$this->totalPage:$this->currentPage=$page;

}

$this->start=($this->currentPage-1)*$this->pageSize;

}

//显示分页列表

function show($page=10)

{

$str.='

';

$str.=" ".$this->totalRecord." ";

$pre=$this->currentPage-1;

if($pre!=0)

{

$str.='flag.'='.$pre.' class=next><<';

}

if($this->currentPage>=$page)

{

if($this->totalPage-$this->currentPage<10)

{

$start=$this->currentPage-($this->currentPage%10);

$end=$this->totalPage;

}

else

{

$start=$this->currentPage-2;

$end=$start+$page-1;

}

}

else

{

$start=1;

$end=10;

}

for ($i=$start;$i<=$end;$i++)

{

if($i==$this->currentPage)

{

$str.="".$i."";

}

else

{

$str.="flag."=$i>$i";

}

}

$next=$this->currentPage+1;

$str.='flag.'='.$next.' class=next>>>';

$str.="flag."=".$this->totalPage." class=last>...".$this->totalPage."";

$str.="flag}='+this.value; return false;}/" />";

$str.="

";

return $str;

}

}

?>

define("HOST","localhost");

define("UNM","root");

define("PWD","root");

define("DB","test");

require_once('db.class.php');

$db=new db();

$sql="select * from yy";

$page=new page($sql,10);

$sql.=" limit $page->start,$page->pageSize";

$rs = $db->fetch($sql);

?>

ID

UNM

for($i=0;$i

{

?>

=$rs[$i][0]?>=$rs[$i][1]?>

}

?>

=$page->show()?>