Wednesday 07 December 2005 7:19:39 am
"the idea is that i will still use the mysql connection as a master connection, and for a specific case i want to use the oracle driver to connect to the oracle database to retreive some data for display." Yes, I understood.
"how can i configure ezdb to use the ezoracle extension to do so? the installation guide shows how to use the oracle connection as a master database connection and not as an oxiliary connection. "
You must pass some extra parameters to eZDB::instance() in this case. Example:
$parameters = array( 'server' => 'localhost',
'user' => 'scott',
'password' => 'tiger',
'database' => 'orcl' );
$db =& eZDB::instance( 'ezoracle', $parameters, true );
$result = $db->arrayQuery( 'SELECT * FROM tab' );
foreach ( $result as $row )
echo $row['tname'] . "\n";
|