phpfans留言版用到的数据操作类和分页类

　　复制代码 代码如下:classmysql{
functionconnect($dbhost,$dbuser,$dbpw,$dbname=,$dbcharset=){
if(!@mysql_connect($dbhost,$dbuser,$dbpw)){
$this->show(CannotconnecttoMySQLserver);
}
if($dbname){
$this->select_db($dbname);
}
if($this->version()>4.1){
if($dbcharset){
$this->query(SETNAMES.$dbcharset.);
}
}
}

functionselect_db($dbname){
returnmysql_select_db($dbname);
}

functionfetch_array($query,$result_type=MYSQL_ASSOC){
return@mysql_fetch_array($query,$result_type);
}

functionquery($sql,$type=){
if(!($query=mysql_query($sql)))$this->show(MySQLQueryError,$sql);
return$query;
}

functionaffected_rows(){
returnmysql_affected_rows();
}

functionresult($query,$row){
returnmysql_result($query,$row);
}

functionnum_rows($query){
return@mysql_num_rows($query);
}

functionnum_fields($query){
returnmysql_num_fields($query);
}

functionfree_result($query){
returnmysql_free_result($query);
}

functioninsert_id(){
returnmysql_insert_id();
}

functionfetch_row($query){
returnmysql_fetch_row($query);
}

functionversion(){
returnmysql_get_server_info();
}

functionclose(){
returnmysql_close();
}

functionshow($message=,$sql=){
if(!$sql)echo$message;
elseecho$message.<br>.$sql;
}
}

classpageextendsmysql{
functionpagination($sql,$maxnum,$page,$maxpages,$pagepre,$ext=){
global$sum,$stail,$link,$lmid,$ltail,$curpage;//$ext=&class=3
$SELF=$_SERVER[PHP_SELF];

$query=$this->query($sql);
$rows=$this->fetch_array($query,MYSQL_NUM);
$totalrows=$rows[0];

$totalpages=ceil($totalrows/$maxnum);
$startnum=($page-1)*$maxnum;
$string=$sum.$totalrows.$stail.$sum.$page./.$totalpages.$stail;

if($page!=1){
$string.=$link.$SELF.?page=1.$ext.$lmid.‹.$ltail;
$string.=$link.$SELF.?page=.($page-1).$ext.$lmid.‹‹.$ltail;
}

if($maxpages>=$totalpages){
$pgstart=1;$pgend=$totalpages;
}
elseif(($page-$pagepre-1+$maxpages)>$totalpages){
$pgstart=$totalpages-$maxpages+1;
$pgend=$totalpages;
}
else{
$pgstart=(($page<=$pagepre)?1:($page-$pagepre));
$pgend=(($pgstart==1)?$maxpages:($pgstart+$maxpages-1));
}

for($pg=$pgstart;$pg<=$pgend;$pg++){
if($pg==$page){
$string.=$curpage.$SELF.?page=.$pg.$ext.$lmid.$pg.$ltail;
}
else$string.=$link.$SELF.?page=.$pg.$ext.$lmid.$pg.$ltail;
}

if($page!=$totalpages){
$string.=$link.$SELF.?page=.($page+1).$ext.$lmid.››.$ltail;
$string.=$link.$SELF.?page=.$totalpages.$ext.$lmid.›.$ltail;
}
return$string;
}
}

functionhtml($str){
$str=get_magic_quotes_gpc()?$str:addslashes($str);
return$str;
}

functiondehtml($str){
$str=nl2br(stripslashes($str));
return$str;
}

functiondeip($str){
$arr=explode(.,$str);
$str=$arr[0]...$arr[1]...$arr[2]..*;
return$str;
}