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

2015-01-24信息快讯网

class mysql{      
    function connect($dbhost, $dbuser, $dbpw, $dbname = '',$dbcharset='') {      
        if(!@mysql_connect($dbhost, $dbuser, $dbpw)) {  
            $this->show('Can not connect to MySQL server');  
        }      
        if($dbname) {  
            $this->select_db($dbname);  
        }  
        if($this->version() > '4.1') {  
            if($dbcharset) {              
                 $this->query("SET NAMES '".$dbcharset."'");      
            }  
        }  
    }  

    function select_db($dbname) {  
        return mysql_select_db($dbname);  
    }  

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

    function query($sql, $type = '') {  
        if(!($query = mysql_query($sql))) $this->show('MySQL Query Error', $sql);  
        return $query;          
    }  

    function affected_rows() {  
        return mysql_affected_rows();  
    }  

    function result($query, $row) {  
        return mysql_result($query, $row);  
    }  

    function num_rows($query) {  
        return @mysql_num_rows($query);  
    }  

    function num_fields($query) {  
        return mysql_num_fields($query);  
    }  

    function free_result($query) {  
        return mysql_free_result($query);  
    }  

    function insert_id() {  
        return mysql_insert_id();          
    }  

    function fetch_row($query) {  
        return mysql_fetch_row($query);  
    }  

    function version() {  
        return mysql_get_server_info();  
    }  

    function close() {  
        return mysql_close();  
    }  

    function show($message = '', $sql = '') {  
        if(!$sql) echo $message;  
        else echo $message.'<br>'.$sql;  
    }  
}  

class page extends mysql{  
    function pagination($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;  
    }  
}  

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

function dehtml($str){  
    $str = nl2br(stripslashes($str));  
    return $str;  
}  

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

©2014-2024 dbsqp.com