Variable database setting Cakephp

Question

I'm searching a way to create a variable database in Cakephp. I'm creating a website in wich the database setting (user, pass, db) depends of the user who logg's in. The database settings come from another database. Thanks in advance,

Aäron

-- ANSWER

Thanks for your quick reply. I know how to switch between databases, but the database settings have to be variable. Example

   $db = $this->DB_SET['DB_SET']['db']; //from model DB_SET the database 
    $db_login= $this->DB_SET['DB_SET']['login'];
    $db_host= $this->DB_SET['DB_SET']['host'];
    $db_pass= $this->DB_SET['DB_SET']['pass'];
    var $db2 = array(
            'driver' => 'mysql',
            'persistent' => false,
            'host' => $db_host,
            'login' => $db_login,
            'password' => $db_pass,
            'database' => $db,
            'prefix' => '',
            'encoding' => 'UTF8',
            'port' => '',
        );

jeremyharris · Accepted Answer · 2012-05-31 14:10:54Z

2

If you're looking to create database connections on the fly, you may want to use ConnectionManager::create().

// get logged in user's id and create a connection for them
$id = $this->Auth->user('id');
ConnectionManager::create("user_$id_db", array(
  'driver' => 'mysql',
  'persistent' => false,
  'host' => $db_host,
  'login' => $db_login,
  'password' => $db_pass,
  'database' => $db,
  'prefix' => '',
  'encoding' => 'UTF8',
  'port' => '',
));

Then set your models to use it when you're ready.

// get logged in user's id and use their connection
$id = $this->Auth->user('id');
$this->Model->setDataSource("user_$id_db");

answered May 31, 2012 at 14:10

jeremyharris

7,88224 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Variable database setting Cakephp

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related