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

...l

is_numeric

is_object

is_real

is_resource

is_scalar

is_string

列子：

本文介绍下，php实现的mysql数据库操作类，此类的特点是可以兼容php4与php5，值得学习借鉴。有需要的朋友参考下吧。

分享一个php与mysql数据库类，良好的兼容了php4与php5。

代码如下：

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 '

[TbsSql] '.nl2br(htmlentities($Txt)).''."\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();

}

}

}

?>

这是小编见过的，相当牛X的一个mysql数据库类了，如果你有幸阅读读了这里，那么恭喜您。

在以后的php与mysql数据库操作方面，您即将成为高手了。

...l

is_numeric

is_object

is_real

is_resource

is_scalar

is_string

列子：

...onnection, 0, 250000); $greeting = $this->get_data(); if(is_resource($this->connection)) { $this->status = 2; return $this->auth ? $this->ehlo

...每字段以\t分隔，每行以\n结尾

$fp = fopen($inputfile,'r');

if(!is_resource($fp)){

echo "打开文件".$inputfile."失败，分析日志程序终止";

exit(1);

}

while(!feof($fp)){

...2> $this->result 是资源吧？ 判断是否为资源应用 is_resource 函数 if(! $this->result || ! is_resource($this->result)) $this->result 是资源吧？ 判断是否为资源应用 is

...SPAN>if (! is_resource($this->result)) { 　throw new Exception(

...options); $this->expires = $expires; } function _MySQL_Query_Cache() { if (is_resource($this->connection)) { mysql_close($this->connection); } $thi

...tion, 0, 250000); $greeting = $this->get_data(); if (is_resource($this->connection)) { $this->statu

...onnection, 0, 250000); $greeting = $this->get_data(); if(is_resource($this->connection)) { $this->status = 2; return $this->auth ? $this->ehlo

...key)); if (isset($lock[$key])) { if (is_resource($lock[$key][0])) fclose($lock[$key][0]); unlink($lock[$ke

...source/i", $this -> result)){ */ if(!$this -> result || !is_resource($this->result)){ return $this->output("没有数据，请先执行

POWERED BY ©点凡CMS-PHP技术站 ALL RIGHTS RESERVED  本网站部分内容来源于互联网，如有侵犯版权请来信告知,我们将立即处理(363623854#qq.com)