ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools

Trace:
v5:reference:loadbalancer:adodbloadbalancerconnection

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
Last revisionBoth sides next revision
v5:reference:loadbalancer:adodbloadbalancerconnection [2017/04/18 03:09] – [$connectionType] mnewnhamv5:reference:loadbalancer:adodbloadbalancerconnection [2017/04/25 03:14] – mnewnham
Line 3: Line 3:
 <WRAP right box> <WRAP right box>
 == Applies To == == Applies To ==
-ADOdb Load Balancer+[[v5:loadbalancer:index|ADOdb Load Balancer]]
 == See Also == == See Also ==
-[[v5:reference:loadbalancer:getadodbobject|getADODbObject()]]\\ 
 [[v5:reference:loadbalancer:addconnection|addConnection()]] [[v5:reference:loadbalancer:addconnection|addConnection()]]
 == Syntax == == Syntax ==
Line 20: Line 19:
 </WRAP> </WRAP>
 ===== Description ===== ===== Description =====
-The class ''ADOdbLoadBalancerConnection'' is the replacement for [[v5:reference:connection:adonewconnection|adoNewConnecton()]] and instantiates an ADOdb connection that can be retrieved and added to the connection pool. +The class ''ADOdbLoadBalancerConnection'' is the replacement for [[v5:reference:connection:adonewconnection|adoNewConnecton()]] and creates a template ADOdb connection that can be retrieved and added to the connection pool. 
 + 
 +Note that a connection is not established when the class is instantiated, it is delayed until an ADOdb command such as //**execute**// is issued, or a Load Balancer internal command such as [[v5:reference:loadbalancer:clusterexecute|clusterExecute()]] is issued. This means that a connection number is consumed even if the connection parameters are invalid. Care should be taken when using commands such as [[v5:reference:loadbalancer:removeconnection|removeConnection()]] that rely on a connection number. 
 ------------------------ ------------------------
 ===== Parameters ===== ===== Parameters =====
Line 31: Line 33:
  
 ==== $persistantConnection ==== ==== $persistantConnection ====
 +This parameter forces the ADOdb connection to be made with a [[v5:reference:connection:pconnect|persistant]] connection.
 ==== Other Parameters ==== ==== Other Parameters ====
 The other parameters are defind the same as the equivalent connection parameters in ADOdb . The other parameters are defind the same as the equivalent connection parameters in ADOdb .
Line 37: Line 39:
 ===== Usage ==== ===== Usage ====
 <code php> <code php>
-$driver = 'mysqli'; 
-$db = new ADOdbLoadBalancer( $driver ); 
  
 +$db = new ADOdbLoadBalancer;
 +
 +$driver = 'mysqli';
 $database = 'employees'; $database = 'employees';
 $user     = 'adodb'; $user     = 'adodb';
Line 53: Line 56:
   $password,    $password, 
   $database );   $database );
-$db0->getADODbObject();+
 $db->addConnection( $db0 ); $db->addConnection( $db0 );
  
Line 66: Line 69:
   $password,    $password, 
   $database );   $database );
-$db1->getADODbObject();+
 $db->addConnection( $db1 ); $db->addConnection( $db1 );
  
Line 79: Line 82:
   $password,    $password, 
   $database );   $database );
-$db2->getADODbObject(); 
 $db->addConnection( $db2 ); $db->addConnection( $db2 );
  
 </code> </code>
  
v5/reference/loadbalancer/adodbloadbalancerconnection.txt · Last modified: 2017/04/27 01:07 by mnewnham