<?
class mysql_driver {

	function mysql_driver($host,$name,$pass,$db)
	{
		$this->hostname = $host;
		$this->username = $name;
		$this->password = $pass;
		$this->database = $db;
	}

	function db_connect()
	{
		return @mysql_connect($this->hostname, $this->username, $this->password, TRUE);
	}

	function db_select()
	{
		return @mysql_select_db($this->database, $this->conn_id);
	}

	function initialize()
	{
		$this->conn_id = $this->db_connect();
		$this->db_select();
	}

	function query($sql)
	{
		// 이부분은 필요에 의해서 사용가능
		return $this->result=mysql_query($sql,$this->conn_id);
	}
}

function &DB($host,$name,$pass,$db)
{
	$driver = "mysql_driver";
	$DB =& instantiate_class(new $driver($host,$name,$pass,$db));
	$DB->initialize();
	return $DB;
}

function instantiate_class($class){
	return $class;
}


// 디비연결정보
$DB1 = DB('주소','아이디','패스워드','디비명');
$DB2 = DB('주소','아이디','패스워드','디비명');

// 순환출력 (db1, db2 교차테스트)
$result1=$DB1->query("select * from board");
while($data1=mysql_fetch_array($result1))
{

	$result2=$DB2->query("select * from board2");
	$data2 = mysql_fetch_array($result2);

	echo "$data1[title] => $data2[title]<br>";

}

// 입력
$DB1->query("insert into board(id, pass)
values('$id', '$pass')");

// 수정
$DB1->query("update board set  id='$id' where no='$no'");

// 삭제
$DB1->query("delete from board where no='$no' "); 

// 조회
$result=$DB1->query("select * from board where no = '$no'");
$data = mysql_fetch_array($result);



?>