php mysql数据库类(兼容php4与php5)

WBOY
Freigeben: 2016-07-25 08:56:42
Original
1000 Leute haben es durchsucht
本文介绍下,php实现的mysql数据库操作类,此类的特点是可以兼容php4与php5,值得学习借鉴。有需要的朋友参考下吧。

分享一个php与mysql数据库类,良好的兼容了php4与php5。 代码如下:

<?php 

// mysql数据库类 
// Version 1.01
class clsTbsSql { 

    var $Id; 
    var $Mode; 
     
    function clsTbsSql($srv='',$uid='',$pwd='',$db='',$drv='') { 
        // Default values (defined here to be compatible with both PHP 4 & 5) 
        $this->Id = false; 
        $this->Mode = 1; // 0=silent, 1=normal, 2=debug, 3=trace 
        // Try to connect when instance is created 
        if ($srv!=='') $this->Connect($srv,$uid,$pwd,$db,$drv); 
        $this->_Dbs_Prepare(); 
        // Hook for the TinyButStrong Template Engine 
        $GLOBALS['_TBS_UserFctLst']['k:tbssql'] = array('type'=>4,'open'=>array(&$this,'_Dbs_RsOpen'),'fetch'=>array(&$this,'_Dbs_RsFetch'),
'close'=>array(&$this,'_Dbs_RsClose')); 
    } 

// Public methods 
     
    function Connect($srv,$uid,$pwd,$db,$drv='') { 
        $this->Id = $this->_Dbs_Connect($srv,$uid,$pwd,$db,$drv); 
      if ($this->Id===false) return $this->_SqlError(false); 
        return true; 
    } 

    function Close() { 
        if ($this->Id!==false) $this->_Dbs_Close(); 
    } 

    function Execute($Sql) { 

        $ArgLst = func_get_args(); 
        $this->_SqlProtect($Sql,$ArgLst,1); 
        $RsId = $this->_Dbs_RsOpen(null,$Sql); 
        if ($RsId===false) return $this->_SqlError($this->Id); 

        $this->_Dbs_RsClose($RsId); 
        return true; 

    } 

    function Value($DefVal,$Sql) { 

        $ArgLst = func_get_args(); 
        $this->_SqlProtect($Sql,$ArgLst,2); 
        $RsId = $this->_Dbs_RsOpen(null,$Sql); 
        if ($RsId===false) return $this->_SqlError($this->Id); 

        $Row = $this->_Dbs_RsFetch($RsId); 
        if ($Row===false) { 
            $x = $DefVal; 
        } else { 
            $x = reset($Row); 
        } 

        $this->_Dbs_RsClose($RsId); 
        return $x; 

    } 

    function Row1($Sql) { 

        $ArgLst = func_get_args(); 
        $this->_SqlProtect($Sql,$ArgLst,1); 
        $RsId = $this->_Dbs_RsOpen(null,$Sql); 
        if ($RsId===false) return $this->_SqlError($this->Id); 

        $x = $this->_Dbs_RsFetch($RsId); 

        $this->_Dbs_RsClose($RsId); 
        return $x; 

    } 

    function Rows($Sql) { 
         
        $ArgLst = func_get_args(); 
        $this->_SqlProtect($Sql,$ArgLst,1); 
        $RsId = $this->_Dbs_RsOpen(null,$Sql); 
        if ($RsId===false) return $this->_SqlError($this->Id); 

        $x = array(); 
        while ($r = $this->_Dbs_RsFetch($RsId)) { 
            $x[] = $r; 
        } 

        $this->_Dbs_RsClose($RsId); 
        return $x; 

    } 

    function AffectedRows() { 
        return $this->_Dbs_AffectedRows(); 
    } 

    function LastRowId() { 
        return $this->_Dbs_LastRowId(); 
    } 

// Private methods 

    function _SqlError($ObjId) { 
        if ($this->Mode==0) return; 
        $x =  'Database error message: '.$this->_Dbs_Error($ObjId); 
        if ($this->Mode==2) $x .= "\r\nSQL = ".$this->LastSql; 
        $this->_SqlMsg($x); 
        return false; 
    } 

    function _SqlMsg($Txt,$Color='#FF0000') { 
        if ($this->Mode!=0) { 
            echo '<div style="color: '.$Color.';">[TbsSql] '.nl2br(htmlentities($Txt)).'</div>'."\r\n"; 
            flush(); 
        } 
    } 
     
    function _SqlDate($Date,$Mode) { 
        // Return the date formated for the current Database 
        if (is_string($Date)) { 
            $x = strtotime($Date); 
            if (($x===-1) or ($x===false)) { 
                // display error message 
                $this->_SqlMsg('Date value not recognized: '.$Date); 
                $Mode = 0; // Try with the string mode 
                $x = $Date; 
            } 
        } else { 
            $x = $Date; 
        } 
        return $this->_Dbs_Date($x,$Mode); 
    } 
     
    function _SqlProtect(&$Sql,&$ArgLst,$IdxStart) { 
    // Replace all %i% and @i@ figures by corresponding protected values 
        $IdxMax = count($ArgLst) - 1; 
        for ($i=$IdxStart;$i<=$IdxMax;$i++) { 
            // Simple value 
            $n = $i - $IdxStart + 1; 
            $tag = '%'.$n.'%'; 
            if (strpos($Sql,$tag)!==false) { 
                $x = $this->_Dbs_ProtectStr(''.$ArgLst[$i]); 
                $Sql = str_replace($tag,$x,$Sql) ; 
            } 
            // String value 
            $tag = '@'.$n.'@'; 
            if (strpos($Sql,$tag)!==false) { 
                $x = '\''.$this->_Dbs_ProtectStr(''.$ArgLst[$i]).'\''; 
                $Sql = str_replace($tag,$x,$Sql) ; 
            } 
            // Date value 
            $tag = '#'.$n.'#'; 
            if (strpos($Sql,$tag)!==false) { 
                $x = $this->_SqlDate($ArgLst[$i],1); 
                $Sql = str_replace($tag,$x,$Sql) ; 
            } 
            // Date and time value 
            $tag = '~'.$n.'~'; 
            if (strpos($Sql,$tag)!==false) { 
                $x = $this->_SqlDate($ArgLst[$i],2); 
                $Sql = str_replace($tag,$x,$Sql) ; 
            } 
        } 
        if ($this->Mode==2) { 
            $this->LastSql = $Sql; 
        } elseif ($this->Mode==3) { 
            $this->_SqlMsg('Trace SQL: '.$Sql,'#663399'); 
        } 
    } 

// ------------------------------- 
// 指定数据库系统
// ------------------------------- 

// Database Engine: MySQL  
// Version 1.02
     
    function _Dbs_Prepare() { 
        if (@mysql_ping()) { // Check if a MySQL connection already exist 
            $this->Id = true; 
        } 
    } 

    function _Dbs_Connect($srv,$uid,$pwd,$db,$drv) { 
        $Id = @mysql_connect($srv,$uid,$pwd); 
        if (($Id!==false) and ($db!=='')) { 
            if (!@mysql_select_db($db)) $this->_SqlError(false); 
        } 
        return $Id; 
    } 

    function _Dbs_Close() { 
        if (is_resource($this->Id)) { 
            return @mysql_close($this->Id); 
        } else { 
            return @mysql_close(); 
        } 
    } 

    function _Dbs_Error($ObjId) { 
        if (is_resource($this->Id)) { 
            return @mysql_error($ObjId); 
        } else { 
            return @mysql_error(); 
        } 
    } 
     
    function _Dbs_RsOpen($Src,$Sql) { 
    // $Src is only for compatibility with TinyButStrong 
        if (is_resource($this->Id)) { 
            return @mysql_query($Sql,$this->Id); 
        } else { 
            return @mysql_query($Sql); 
        } 
    } 

    function _Dbs_RsFetch(&$RsId) { 
        return mysql_fetch_assoc($RsId); 
    } 

    function _Dbs_RsClose(&$RsId) { 
        if ($RsId===true)  return true; 
        return @mysql_free_result($RsId); 
    } 
     
    function _Dbs_ProtectStr($Txt) { 
        return mysql_real_escape_string($Txt); 
    } 
     
    function _Dbs_Date($Timestamp,$Mode) { 
        switch ($Mode) { 
        case 1: 
            // Date only 
            return '\''.date('Y-m-d',$Timestamp).'\''; 
        case 2: 
            // Date and time 
            return '\''.date('Y-m-d H:i:s',$Timestamp).'\''; 
        case 0: 
            // Value is a string 
            return '\''.$this->_Dbs_ProtectStr($Timestamp).'\''; 
        default: 
            // Error in date recognization 
            return '\'0000-00-00\''; 
        }   
    } 

    function _Dbs_LastRowId() { 
        return $this->Value(false,'SELECT LAST_INSERT_ID()'); 
    } 
     
    function _Dbs_AffectedRows() { 
        if (is_resource($this->Id)) { 
            return mysql_affected_rows($this->Id); 
        } else { 
            return mysql_affected_rows(); 
        }         
    }
}
?> 
Nach dem Login kopieren

这是小编见过的,相当牛X的一个mysql数据库类了,如果你有幸阅读读了这里,那么恭喜您。 在以后的php与mysql数据库操作方面,您即将成为高手了。



Quelle:php.cn
Erklärung dieser Website
Der Inhalt dieses Artikels wird freiwillig von Internetnutzern beigesteuert und das Urheberrecht liegt beim ursprünglichen Autor. Diese Website übernimmt keine entsprechende rechtliche Verantwortung. Wenn Sie Inhalte finden, bei denen der Verdacht eines Plagiats oder einer Rechtsverletzung besteht, wenden Sie sich bitte an admin@php.cn
Beliebte Tutorials
Mehr>
Neueste Downloads
Mehr>
Web-Effekte
Quellcode der Website
Website-Materialien
Frontend-Vorlage
Über uns Haftungsausschluss Sitemap
Chinesische PHP-Website:Online-PHP-Schulung für das Gemeinwohl,Helfen Sie PHP-Lernenden, sich schnell weiterzuentwickeln!