Codeigniter – Using Multiple Databases

by

There is a bug in codeigniter. Inserting one line into a class will fix the whole thing. Here is the original source: http://koorb.wordpress.com/2007/11/16/codeigniter-connect-to-multiple-databases/

** This fix does not apply to PostgreSQL

Here is a copy just in case that site goes down.

The line number has changed. Here is the bug fix from codeigniter:

start bugfix

Description

all of the database calls go to the same database (last one initialized)

To fix the problem change the simple_query function in /system/database/DB_driver.php:

function simple_query($sql)
{
    if ( ! $this->conn_id)
    {
        $this->initialize();
    }
   
    $this->db_select(); //<-----------------  Added this line
    return $this->_execute($sql);
}

This completely fixes the problem, so you can do stuff like this in a model

$this->legacy_db = $this->load->database('legacy', true);

More Related Contents:

  1. PHP – Change value y,n in database [closed]
  2. strange character encoding of stored data , old script is showing them fine new one doesn’t
  3. Advantages / Disadvantages of pconnect option in CodeIgniter
  4. want to convert a string into array [duplicate]
  5. Comma separated numeric values – PHP CodeIgniter
  6. I want to use jquery nested sortable plugin with drag and drop in codeigniter using mysqli
  7. Using PHP data in MySQL [closed]
  8. Php: How to protect images for downloading [duplicate]
  9. Set up the base url in codeigniter
  10. How to loop through a mysql result set
  11. Codeigniter: Passing data from controller to view
  12. Best method of including views within views in CodeIgniter
  13. .htaccess issues: No input file specified
  14. How to get the total number of rows of a GROUP BY query?
  15. CodeIgniter: Load controller within controller
  16. Loading view outside view folder with CodeIgniter
  17. Is there any way to check the performance of mysql Indexing
  18. Codeigniter Sessions not working after migration
  19. Proper Repository Pattern Design in PHP?
  20. retrieve data from db and display it in table in php .. see this code whats wrong with it?
  21. How do I remove ‘index.php’ from URL in CodeIgniter?
  22. Using LIKE in bindParam for a MySQL PDO Query [duplicate]
  23. Codeigniter: Best way to structure partial views
  24. Codeigniter: fatal error call to undefined function mysqli_init()
  25. mysqli – fetch_Array error call to a member function fetch_array() on a non-object mysqli [duplicate]
  26. How do I loop through JSON array
  27. is_unique for codeigniter form validation
  28. Getting data from post array in CodeIgniter
  29. $_POST empty on utf-8 characters
  30. Routes in Codeigniter – Automatically

Leave a Comment