title: How do you connect to MySQL and Oracle in CodeIgniter?
body: <p>I am confused as to how to configure CodeIgniter to use more than one database.  I have data in an Oracle database retrieved via PDO and a MySQL db which is using the "built in" configuration for CI.  From what I can see, I only have the main configuration file that allows me to config one database (in this case the MySQL one)</p>
  
  <p>How do I get data back from more than one database in the same webpage/view?  Say I have MySQL built in to the main config page. Do I just make another connection in my controller (do I do it the "regular" old non-framework way), fetch my array and send that array to the view?  In other words my main configured database can use the built in CI activerecord type queries but my other databases can't take advantage of that?</p>
  
  <p>Is this pretty much the way it is with all php frameworks?  YOu end up making connections in your controller, the old fashioned way, and sending data to the view?</p>
  
  <p>Thanks.</p>
  
  <p>EDIT:  I guess I'm saying the model for the second database ends up in the controller...which is bad isn't it?</p>
  
  <p>EDIT:  Oracle was just an example.  It could be any database CI can natively talk to.</p>
  
  <p>EDIT:  For CI, I think this is the answer:</p>
  
  <p><a href="http://codeigniter.com/user_guide/database/connecting.html" rel="nofollow noreferrer">http://codeigniter.com/user_guide/database/connecting.html</a></p>
  
  <p>though I'm not sure how to use it.</p>
  
  <p>EDIT:  Found it here too:  <a href="http://www.gotphp.com/codeigniter-multiple-database-support/5468/" rel="nofollow noreferrer">http://www.gotphp.com/codeigniter-multiple-database-support/5468/</a> better.</p>
  
  <p>-- these are assuming the built in drivers for CI.  this does not answer then you have multiple databases and non-CI drivers</p>