Connection to DataBase out eZ

Tuesday 18 October 2005 4:17:22 am

First of all, you will need the Oracle database extension. Then you'll need to call the method <i>instance</i> of the class <i>eZDB</i>:

$db =& eZDB::instance( $databaseImplementation, $databaseParameters, $forceNewInstance );

$databaseParameters is an array with these keys (some of them are optional): server, user, password, database, use_slave_server, slave_server, slave_password, slave_database, charset, socket, builtin_encoding, connect_retries, use_persistent_connection and show_errors. Take a look in lib/ezdb/classes/ezdb.php for more information.

Then you can query your database:

$result = $db->query( $sql );

or

$resultArray = $db->arrayQuery( $sql );

independent eZ Publish developer and service provider | http://blog.coomanskristof.be | http://ezpedia.org

Tuesday 18 October 2005 6:31:07 am

Hi kristof,
I was read ezdb.php file...but..
How I get extension's Oracle??....
Where I can to install the extension

Natalia ....

Tuesday 18 October 2005 1:48:41 pm

Hi Kristof,

Can't I connect directly to Oracle without using the extension? Since PHP is Oracle capable what are the cons of doing it that way?

I wan't to create a module which uses an external database...what are my options.

Regards

Wednesday 19 October 2005 7:12:56 am

Indeed, you can connect to an Oracle database with the PHP Oracle functions. The only con I can imagine is that if you'll ever want to switch to another database, you'll have to rewrite that part of the code.

independent eZ Publish developer and service provider | http://blog.coomanskristof.be | http://ezpedia.org

Wednesday 07 December 2005 3:05:46 am

Hi
Please we can to use ezdb() without the ezoracle extensions.
coz I want to retrive data from oracle only and i am not need to transform my DB of ezpublish to oracle DB.
Plz, can you explain the steps to retrive data from oracle using ezdb() ???
Thank you for your help

Wednesday 07 December 2005 6:30:35 am

Thank you Mr.Björn
In ez I create a module in it, in oracledata.php I create a class, on it I connect to oracle and execute a query and display the data this process execute without the ezoracle extension but but in this class I used a OCIlogon, OCIParse and OCIExecute without ezdb()
Ok the case is how to use ezdb on my module to connect oracle database as a slave DB because I want to keep my MySql DB and want to connect to Oracle DB.
best Regards,
Amer Azzaz
amer_azzaz@hotmail.com