Cakephp为整个项目切换数据库连接

Question

How can I switch the database for the entire project like this example:

User 1 uses database test1

User 2 uses database test2

User 3 uses database test3

Like this above... Those ID from User, will come from the default database ( Login page )

PS: Sorry for my bad english, I need some more information, please tell me.

Answer 1

Create multiple database configurations in database.php

Let say we have default, test1, test2, test3 configurations.

As you said user data is in default db config and I consider that you are using AUTH COMPONENT for authorization.

Now add following function in AppController

    public function beforeFilter() {
        //call change db config function on user login and pass which config need to use
        if( $this->Auth->loggedIn() ) {
            //user login
            ///Some logic to select db config according login user.
            $dbConfig = "result of logic which return db config name";
            $this->_userSpecificDbConfig($dbConfig);
            }
    }

    private function _userSpecificDbConfig($dbConfig) {
        //get model name
        $model =  $this->name;
        //set db configuration for user
        switch($dbConfig) {
            case 'test1':
                $this->{$model}->useDbConfig = "test1";
                break;
            case 'test2':
                $this->{$model}->useDbConfig = "test2";
                break;
            case 'test3':
                $this->{$model}->useDbConfig = "test3";
                break;
            default: 
                $this->{$model}->useDbConfig = "default";
        }
    }

Try this code.