Differences

This shows you the differences between two versions of the page.

--- activerecord:setdatabaseadaptor [2015/12/06 02:25] – mnewnham
+++ v5:activerecord:setdatabaseadaptor [2022/06/09 18:14] – setDatabaseAdaptor -> setDatabaseAdapter dregad
@@ Line 1: / Line 1: @@
-====== setDatabaseAdaptor ======
+====== setDatabaseAdapter ======
 ~~NOTOC~~
 <WRAP right box>
+== See Also ==
+[[v5:activerecord:dbat|$_dbat Class Variable]]
 == Syntax ==
    bool ADODB_Active_Record::setDatabaseAdapter(
@@ Line 9: / Line 11: @@
 </WRAP>
 ===== Description =====
-This allows links the Active Record class to an ADOdb database connection. The method returns true if it is a valid connection, or false if not. The optional ''$label'' parameter allows multiple database connections to be assigned to the same ADODB_Active_Record class
+This links the Active Record class to an ADOdb database connection. The method returns true if it is a valid connection, or false if not.
+The optional ''$label'' parameter allows multiple database connections to be assigned to the same ADODB_Active_Record class. Note that even though multiple connections can be attached to the base class, only one can be used, so the class must be extended  to use the connections
 ------------------------
 ===== Usage =====
+Example, using single connection
 <code php>
-$db = NewADOConnection(...);
+$db = newAdoConnection('mysqli');
-$db2 = NewADOConnection(...);
+$db->connect(...);
+$ADOdb_Active_Record::setDatabaseAdapter($db);
+</code>
+Example, multiple connections
+<code php>
+$db  = NewADOConnection('mysqli');
+$db2 = NewADOConnection('oci8');
-ADOdb_Active_Record::SetDatabaseAdapter($db2);
+$db->connect(...);
+$db2->connect(...);
-$activeRecs = $db->GetActiveRecords('table1');
+ADOdb_Active_Record::SetDatabaseAdapter($db,'mConnection');
+ADOdb_Active_Record::SetDatabaseAdapter($db2,'oConnection');
-foreach($activeRecs as $rec)
+class mPerson extends ADODB_Active_Record
 {
-   $rec2 = new ADOdb_Active_Record('table2',$db2);
+    /*
-   $rec2->id = $rec->id;
+    * Assigns the mysql connection to this class
-   $rec2->name = $rec->name;
+    */
-   $rec2->Save();
+    public $_dbat = 'mConnection';
 }
+class oPerson extends ADODB_Active_Record
+{
+    /*
+    * Assigns the oracle connection to this class
+    */
+    public $_dbat = 'oConnection';
+}
 </code>