How to use multiple databases dynamically for one model in CakePHP

by

This gentleman (Olivier) had the same problem! (A year ago) He wrote a small adaptation for the Controllers! It’s pretty small and it turns out, it works in 1.3 and 2.x.

Anyhow, this is my final solution, that I put in the app/Model/AppModel.php:

class AppModel extends Model
{
  /**
   * Connects to specified database
   *
   * @param String name of different database to connect with.
   * @param String name of existing datasource
   * @return boolean true on success, false on failure
   * @access public
   */
    public function setDatabase($database, $datasource="default")
    {
      $nds = $datasource . '_' . $database;      
      $db  = &ConnectionManager::getDataSource($datasource);

      $db->setConfig(array(
        'name'       => $nds,
        'database'   => $database,
        'persistent' => false
      ));

      if ( $ds = ConnectionManager::create($nds, $db->config) ) {
        $this->useDbConfig  = $nds;
        $this->cacheQueries = false;
        return true;
      }

      return false;
    }
}

And here is how I used it in my app/Controller/CarsController.php:

class CarsController extends AppController
{
  public function index()
  {
    $this->Car->setDatabase('cake_sandbox_client3');

    $cars = $this->Car->find('all');

    $this->set('cars', $cars);
  }

}

I’m betting, I’m not the first or last one with this problem. So I really hope this information will find people & the CakePHP community.

More Related Contents:

  1. How to store repeating dates keeping in mind Daylight Savings Time
  2. PHP Fatal error: Class ‘PDO’ not found
  3. SQLSTATE[HY000] [1045] Access denied for user ‘username’@’localhost’ using CakePHP
  4. CakePHP Database connection “Mysql” is missing, or could not be created
  5. UNION syntax in Cakephp
  6. Check if laravel model got saved or query got executed
  7. How to create this type of JSON data from PHP [closed]
  8. how to write php code for the key press enter button when fill the form?
  9. Create hyperlink from html table row to open record on a new page
  10. mysql_fetch_array(): supplied argument is not a valid MySQL result resource [duplicate]
  11. I don’t know what’s wrong with my code. I’m a newbie. The prob is – Notice: Undefined variable: result [duplicate]
  12. SELECT COUNT(*) AS count – How to use this count
  13. How to execute two mysql queries as one in PHP/MYSQL?
  14. How to upload images into MySQL database using PHP code
  15. selecting unique values from a column
  16. Post and get at the same time in php
  17. MySQL – Access denied for user [duplicate]
  18. Calling stored procedure with Out parameter using PDO
  19. Setting up Laravel on a Mac php artisan migrate error: No such file or directory [duplicate]
  20. How to display an BLOB image stored in MySql database?
  21. CakePHP remember me with Auth
  22. What is the best way to insert multiple rows in PHP PDO MYSQL?
  23. How to bind LIKE values using the PDO extension?
  24. How do I set the selected item in a drop down box
  25. Fatal error: Call to undefined function mysqli_result()
  26. access denied for user @ ‘localhost’ to database ” [closed]
  27. Warning: PDO::__construct(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in
  28. WordPress Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /wp-includes/wp-db.php:1570
  29. How can I employ “if exists” for creating or dropping an index in MySQL?
  30. PHP MySQL pagination with random ordering

Leave a Comment