how to check for different types of connection?

[adrive]

im trying to create a function that allows me to set different types of database connections into the current instance.

I need a logic to detect what are the current types of connection that is being passed in, and only assign them if it's a valid database connection object.

Such as, right now i could use "instanceof MySQLI" because MySQLI is object oriented.

Let's say i now need to check for oracle? oci_connect doesn't look object oriented to me so i can't use instanceof.

	public function setConnection($conn){

	if(isset($conn)){
	if($conn instanceof MySQLI ||
               $conn instanceof OCI){
		$this->currentConnection = $conn;
	}
	}
}

[NogDog]

Maybe something along these lines:

$type = null;
if(is_object($conn))
{
   $type = get_class($conn);
}
elseif(is_resource($conn))
{
   $type = get_resource_type($conn);
}
switch($type)
{
   case 'mysqli':
      // do stuff;
      break;
   case 'mssql':
      // do different stuff;
      break;
   // etc....
   default:
      throw new Exception('Unknown/invalid connection');
}

(I'm just guessing what the values of $type will be, you have to do some research/experimenting to find out what the actual values would be.)

[adrive]

so db connections are either objects or resource types only in php??

i'll try these out, thanks alot!