ADOdb: Multi Database Connection



Someday, you may need problem that must connect to more than one kind database. Example, staffing database in oracle and finance in mysql. You must collaborate 2 database in one application.

<?php 
    include('adodb.inc.php');     
    # load code common to ADOdb 

    $conn1 = &ADONewConnection('mysql');  
    # create a mysql connection 
    $conn2 = &ADONewConnection('oracle');  
    # create a oracle connection 

    $conn1->PConnect($server, $userid, $password, $database); 
    $conn2->PConnect(false, $ora_userid, $ora_pwd, $oraname); 

    $conn1->Execute('insert ...'); 
    $conn2->Execute('update ...'); 
?>


Series this article:
ADOdb: Introduction
ADOdb: Connection Statement
ADOdb: Advance Select Statement
ADOdb: How to show tables
ADOdb: How to show fields
ADOdb: How to show databases
ADOdb: Caching of Recordset
ADOdb: Recordset to HTML
ADOdb: Multi Database Connection
ADOdb: Data Dictionary
ADOdb: Quick Export Data
ADOdb: Insert data style
ADOdb: Replace Data
ADOdb: Log Query
PHP ADOdb: Understanding Pivot Table For Reporting
PHP ADOdb: Creating Pivot Table
PHP ADOdb: Creating Query to Build Pivot Table


Tag: adodb, database, database layer Category: PHP Database Post : October 30th 2007 Read: 5,027 Bookmark and Share

blog comments powered by Disqus