All Objects Has Different Db Connections

Hello, I have problem.

I have objects` db. here is db_name db_username db_password.

I need that when I select object it would create a connection with its own database and would further work with it…

I share my code for this problem.

Object class




 /**

     * @params object from database with db connection inforamtion

     * @return db connection parameters

     */

    public function setDb(){

        $definition = [

            'class' => 'yii\db\Connection',

            'dsn' => 'mysql:host=10.100.1.40;dbname=db_'.$this->company_code,

            'username' => 'user_'.$this->company_code,

            'password' => $this->db_password,

            'charset' => 'utf8',

        ];

        Yii::$app->set('dbd',$definition);

    }



Extended ActiveRecord class




namespace app\models;


use Yii;


class ModelBaseDifferentDb extends ModelBases

{

    /**

     * @return db connection parameters

     */

    public static function getDb()

    {

            return Yii::$app->get('dbd');

    }

}



when I sellected object




// in first $model object I have only id from sellect form.

// load all connection data from database

 $model= $model->findOne($model->id);

                $model->setDb();



In another class:




class Classname extends ModelBaseDifferentDb

{

    /**

     * class function

     */

}



Sorry for my english :) hopes this helps :)

P.S. I waiting comments. Its good solution or no?