$this->conn=mysql_connect(self::host,self::user,self::pwd) or die("数据连接失败");

		}

		else

		{

			$this->conn=mysql_pconnect(self::host,self::user,self::pwd) or die("数据连接失败");

		}

		mysql_select_db(self::db);

		mysql_query("set names ".self::code);

	}

	

	function query($sql)

	{

		$res=mysql_query($sql) or die(mysql_error());

		return $res;

	}

	function fetch_array($res)

	{

		return mysql_fetch_array($res);



	}

	//获取主键

	function key($table)

	{

		$sql="desc $table";

		$res=$this->query($sql);

		while ($rs=$this->fetch_array($res))

		{

			if($rs["Key"]=="PRI")

			{



				return $rs['Field'];

			}

		}



	}

	//返回影响行数

	function rows()

	{

		return mysql_affected_rows();

	}

	//插入一条记录

	function insert($table,$str)

	{

		$sql="insert into $table set $str";



		$res=$this->query($sql);

		return mysql_insert_id();

	}

	//跟新一条记录

	function update($table,$str,$ID)

	{

		$key=$this->key($table);

		$sql="update ".self::db.".$table set $str where $key=$ID";



		$this->query($sql);

		return $this->rows();

	}

	//删除一条记录

	function del($table,$ID)

	{

		$key=$this->key($table);

		$sql="delete from $table where $key=$ID";

		$this->query($sql);

		return $this->rows();

	}

	

	//获取记录数量

	function fetchRow($sql){

		$res = $this->query($sql);

		return $this->rows();

	}

	

	//获取一条记录

	function fetch($table,$ID)

	{

		$key=$this->key($table);

		$sql="select * from $table  where $key=$ID";

		$res=$this->query($sql);

		$rs=$this->fetch_array($res);

		return $rs;

	}

	//获取多条记录(分页)

	function fetchMore($sql,$pagesize=10,$url="")

	{

		$res=$this->query($sql);

		$row=mysql_num_rows($res);

		$page=new page($row,$pagesize,$url);

 

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

		$res=$this->query($sql);

		while ($rs=$this->fetch_array($res))

		{

			$record["rec"][]=$rs;

		}



		//判断是否需要显示分页

		if($page->pageSize<$row)

		{



			$record["page"]=$page->show($type);

		}

		return $record;

	}

	

	//获取多条记录(静态分页)

	function fetchMore_html($sql,$pagesize=10,$url="",$f)

	{

		$res=$this->query($sql);

		$row=mysql_num_rows($res);

		$page=new page_html($row,$pagesize,$url,$f);

 

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

		$res=$this->query($sql);

		while ($rs=$this->fetch_array($res))

		{

			$record["rec"][]=$rs;

		}



		//判断是否需要显示分页

		if($page->pageSize<$row)

		{



			$record["page"]=$page->show($type);

		}

		return $record;

	}

	

	//获取多条记录不分页

	function _fetchMore($sql)

	{

		$res=$this->query($sql);

		$row=mysql_num_rows($res);

		while ($rs=$this->fetch_array($res))

		{

			$record["rec"][]=$rs;

		}



		return $record;

	}

	

	//获取所有栏目

	function fetchAll($table,$lumnName,$lumnID=0,$lan=0)

	{

		if($lumnID==0){

			$p=0;

		}else{

			$p=$lumnID;

		}

		if($lan!='0'){

			$limit = " and lan='{$lan}'";

		}

		$sql="select * from $table where $lumnName={$p} $limit order by px desc";

		$key=$this->key($table);

		$res=$this->query($sql);

		$k=0;

		while ($rs=$this->fetch_array($res)){

			$record[$k]=$rs;

			$res2=$this->query("select * from $table where $lumnName={$rs[$key]} $limit order by px desc");

			while ($rs2=$this->fetch_array($res2)){

				$record[$k]["rec"][]=$rs2;

			}

			$k++;

		}

		return $record;

	}

	

	//获取所有栏目2

	function fetchAll2($table,$where,$lumnName,$lan=0)

	{

		if($lumnID==0){

			$p=0;

		}else{

			$p=$lumnID;

		}

		if($lan!='0'){

			$limit = " and lan='{$lan}'";

		}

		$sql="select * from $table where $where order by px desc";

		$key=$this->key($table);

		$res=$this->query($sql);

		$k=0;

		while ($rs=$this->fetch_array($res)){

			$record[$k]=$rs;

			$res2=$this->query("select * from $table where $lumnName={$rs[$key]} $limit order by px desc");

			while ($rs2=$this->fetch_array($res2)){

				$record[$k]["rec"][]=$rs2;

			}

			$k++;

		}

		return $record;

	}



	function getRecord($table,$where="")

	{

		if($where=="")

		{

			$sql="select * from $table";

		}

		else

		{

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

		}



		$res=$this->query($sql);

		while ($rs=$this->fetch_array($res))

		{

			$record[]=$rs;

		}

		return $record;

	}

	

	function isexist($sql)

	{

		$res=$this->query($sql);

		$rs=$this->fetch_array($res);

		return $rs;

	}

	

	function __destruct(){ 

		mysql_close(); 

	}

}

?>var $url;

function __construct($total,$pagesize=5,$url="")

{

$this->pageSize=$pagesize;

$this->url=$url;

$this->totalRec=$total;

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

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

if($this->page==""||$this->page<=0) { $this->curPage=1;

	}

	else

	{

	{

	$start=$this->curPage-4;//start

	$end=$start+$step-1;//end

	if($this->totalPage-$start<$step) { $start=$this->totalPage-$step;

		if($start<=0) { $start=1; } $end=$this->totalPage;

			}

			else

			{

			$start=$this->curPage-4;

			if($start<=0) { $start=1; $end=$step; } else { $end=$step+$start; } } } //
				$temp=pathinfo($_SERVER['PHP_SELF']); $base_url=$temp["basename"]; $url=$this->url;

				$first_page="$base_url?$url";

				$pre_page="$base_url?page=".($this->curPage-1);

				$link_page="$base_url?page";

				$next_page="$base_url?page=".($this->curPage+1);

				$last_page="$base_url?page=".$this->totalPage;





				/******************输出分页开始***************/

				$str.="

				<style type=text/css>
					#page ul {
						margin: 0
					}

					#page li {
						list-style: none;
						float: left;
						margin-left: 2px;
						display: block;
					}

					#page li A {
						display: block;
						padding: 0px 5px;
						font-size: 12px;
						border: solid #CCCCCC 1px;
						text-decoration: none;
						background-color: #FFFFFF;
						width: 15px;
					}

					#page li A:hover {
						display: block;
						border: solid #FF6600 1px;
						color: #0033CC
					}

					#page li b {
						display: block;
						padding: 8px 5px 0px 5px;
						width: 15px;
					}
				</style>

				";

				$str.="<div id='page'>
					<li><a>".$this->curPage."/".$this->totalPage."</a></li>";

					$pre=$this->curPage-1;

					$str.="<li><a href={$first_page}>|<<< /a>
					</li>";

					if($pre>1)

					{

					$str.="<li><a href=\"{$pre_page}{$url}\">
							<< /a>
					</li>";

					}

					for($i=$start;$i<=$end;$i++) { if($i==$this->curPage)

						{

						$str.="<li><b>$i</b></li>";

						}

						else

						{

						if($i!=1)

						$str.="<li><a href=$link_page={$i}{$url}>$i</a></li>";

						else

						$str.="<li><a href=$first_page>$i</a></li>";

						}

						}

						$next=$this->curPage+1;

						if($next<$this->totalPage)

							{

							$str.="<li><a href='{$next_page}{$url}'>></a></li>";

							}

							$str.="<li><a href=\"{$last_page}{$url}\">>>|</a></li>
				</div>";

				return $str;

				}



				}

				?>