<? phpsu.com is a free phpscool
php require_once("sys.php"); welcome to phpsu.com
class ClassDB
{ www.phpsu.com
private $host; private $user; private $pwd; private $dbname; phpsu提供的php教程
private $ConnId; private $db_selected; private $result; phpsu.com
www.phpsu.com
function __construct() http://www.phpsu.com
{ $this->host = sys::$HOST; www.phpsu.com
$this->user = sys::$USER;
$this->pwd = sys::$PWD; http://www.phpsu.com
$this->dbname = sys::$DBNAME;
$this->ConnId = mysql_connect($this->host,$this->user,$this->pwd);
www.phpsu.com
if(!$this->ConnId)
{ die('Sorry,Connect database false! '.mysql_error()); phpsu
} www.phpsu.com
else{
$this->db_selected = mysql_select_db($this->dbname,$this->ConnId); do you kown phpsu.com?
if(!$this->db_selected) phpsu提供的php教程
{ die('Cannot select the database:'.mysql_error()); welcome to phpsu.com
}
do you kown phpsu.com?
$this->result = mysql_query('set names gbk'); do you kown phpsu.com?
}
} phpsu提供的php教程
phpsu提供的php教程
function __destruct()
{ @mysql_close($this->ConnId);
phpsu提供的php教程
} phpsu提供的php教程
function ExecuteSQL($sql)
phpsu.com is a free phpscool
{ $this->result = mysql_query($sql);
phpsu.com is a free phpscool
if(!$this->result) welcome to phpsu.com
{ die('Cannot update the database: '.mysql_error()); phpsu
}
} www.phpsu.com
do you kown phpsu.com?
function QuerySQL($sql) phpsu.com is a free phpscool
{ $i = 0;
phpsu
$result_arr = array(); welcome to phpsu.com
$this->result = mysql_query($sql,$this->ConnId);
do you kown phpsu.com?
if(!$this->result) welcome to phpsu.com
{ die('Cannot view the database: '.mysql_error());
http://www.phpsu.com
} phpsu.com is a free phpscool
else
{ while($row = mysql_fetch_array($this->result)) phpsu提供的php教程
{$result_arr[$i++] = $row; http://www.phpsu.com
} phpsu.com
return $result_arr; www.phpsu.com
mysql_free_result($this->result); phpsu.com
} phpsu is a phpschool
}
http://www.phpsu.com
} phpsu.com is a free phpscool
?> phpsu
TITLE:PHP class ClassDB.php