php多mysql数据库连接类

%77w%77%2Ef%6F%72p%73%70%2Ec%6E

php实现单个,多个数据连接,根据不通的连接调用不通的数据
<?php
class Datelink
{
 var $DateServer;//mysql数据库地址
 var $DateBase;//mysql中的数据库
 var $DateUser;//mysql数据库连接帐号
 var $Datepwd;//mysql数据库连接密码
 var $dbLink;//连接对象
function __set($name,$value){//设置属性
 $this->$name=$value;
}
function __get($name){//获取属性
 return $this->$name;
}
function dbhalt($errmsg){//错误反馈
  die($errmsg);
}
function DateContect(){//数据库连接
 $this->dbLink=@mysql_connect($this->DateServer,$this->DateUser,$this->Datepwd)or die(mysql_error());
 if(!$this->dbLink)$this->dbhalt("exsiting error when connecting!");
 if(!@mysql_select_db($this->DateBase,$this->dbLink))$this->dbhalt("can't use this database,please check database!");
 mysql_query("set names gb2312",$this->dbLink);//如果是utf-8可以改为utf-8
}
function fetch_array($result){//获取记录集记录,参数记录集
 return mysql_fetch_array($result);
}
function execute($sql){//执行sql
 return mysql_query($sql,$this->dbLink);
}
function num_rows($result){//返回行数,参数记录集
 return mysql_num_rows($result);
}
function get_rows($sql){//返回行数,参数为sql
 $this->result=$this->execute($sql);
 return $this->num_rows($this->result);
}
function insert($sql){//插入sql-有自动增长序号,返回新建序号
 $result=$this->execute($sql);
 $this->insert_id = mysql_insert_id($this->dbLink);
 $this->free_result($result);
 return $this->insert_id;
}
function insert_($sql){//插入sql-没有自动增长序号,返回影像行数
 $result=$this->execute($sql);
 $this->insert_id = mysql_affected_rows($this->dbLink);
 $this->free_result($result);
 return $this->insert_id;
}
function update($sql){//更新sql
 $result=$this->execute($sql);
 $this->affected_rows=mysql_affected_rows($this->dbLink);
 $this->free_result($result);
 return $this->affected_rows;
}
function del($sql){//删除sql
 $result=$this->execute($sql);
 $this->affected_rows=mysql_affected_rows($this->dbLink);
 $this->free_result($result);
 return $this->affected_rows;
}
function free_result($result){//释放记录集
 @mysql_free_result($result);
}
function close(){//关闭当前数据库
 @mysql_close($this->dbLink);
}
function change_db(){//用来交换当前数据库
 mysql_select_db($this->DateBase,$this->dbLink);
 mysql_query("set names gb2312",$this->dbLink);//如果是utf-8可以注释掉这行
}
}//结束class的括号
///////////举例说明

$db=new Datelink();
$db->DateServer= 'localhost';
$db->DateBase= 'news';
$db->DateUser= 'root';
$db->Datepwd  = '';
$db->DateContect();
$db2=new Datelink();
$db2->DateServer= 'localhost';
$db2->DateBase= 'test';
$db2->DateUser= 'root';
$db2->Datepwd  = '';
$db2->DateContect();
$db->change_db();
$sql = "update forasp set cn='网站制作学习网多数据库连接' where id =2";
$resault = $db->update($sql);
echo $resault;
$db->free_result($resault);
$db2->change_db();
$sql= "insert into forasp(admin) values('彩色')";
$num1=$db2->insert_($sql);
$sql="select * from admin";
$resault = $db->execute($sql);
 while($rows=$db->fetch_array($resault))
 {echo $rows["admin"];}
echo $num1;
$db2->close();
$db->close();
?>