PHP Yii: Database connect in runtime

Question

I would like to connect to a second database with Yii at runtime. The database name would come from a database table after the user to login.

I saw in a tutorial I should do this:

$db2 = Yii::createComponent(array(
    'class' => 'EMongoClient',
    'server' => 'mongodb://127.0.0.1:27017',
    'db' => $emp['database']
));

Yii::app()->setComponent('db2',$db2);

But in my controler when I access Yii::app()->db2 get the error:

Property "CWebApplication.db2" is not defined

What am I doing wrong?

Daniel Galvan · Accepted Answer · 2013-12-04 05:25:34Z

3

The following works for me:

Yii::app()->mongodb->setActive(false);
Yii::app()->mongodb->setServer('mongodb://localhost:27017');
Yii::app()->mongodb->setDb('db1');
Yii::app()->mongodb->setActive(true);

edited Dec 4, 2013 at 5:25

answered Dec 4, 2013 at 5:19

Daniel Galvan

464 bronze badges

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

Comments

CreatoR · Accepted Answer · 2013-10-17 14:48:45Z

1

UPDATED: Try, instead instance, pass configurations:

Yii::app()->setComponent( 'db2', array(
                                      'class' => 'EMongoClient',
                                      'server' => 'mongodb://127.0.0.1:27017',
                                      'db' => $emp['database']
                                  )
);

Or, you may create special index on params in configurations, such as:

  ...
  'params' => array(
         'db2' => null,
     ),

And the use Yii::app()->params['db2'] = $db2

edited Oct 17, 2013 at 14:48

answered Oct 17, 2013 at 13:54

CreatoR

1,65210 silver badges14 bronze badges

6 Comments

Leonardo Delfino Over a year ago

when I try to do this, I get the following error: Missing argument 2 for CModule::setComponent()

Leonardo Delfino Over a year ago

My problem is not with the creation of the component. Soon after creating if I access Yii::app()->db2 its works, but when I try to access via another model or controller I get the error

CreatoR Over a year ago

Ok, try Yii::app()->setComponents( array('db2'=>$db2)); (with "s"). Or try Yii::app()->setComponent('db2', <array of configurations>)

CreatoR Over a year ago

Interesting. Another thought: reserv name db2 in main configuration and try to change it instanse. If not working, than you may create special key in 'params' and change it... try please

Leonardo Delfino Over a year ago

when i try to access Yii::app()->params['db2'] its returns null.. I am trying to change the parameters inside a module, you know if yii have any restrictions in this regard?

|

Asgaroth · Accepted Answer · 2013-10-18 02:09:51Z

From this comment:

My problem is not with the creation of the component. Soon after creating if I access Yii::app()->db2 its works, but when I try to access via another model or controller I get the error

I think you are setting this component only once somewhere, and then making subsequent requests to different controllers.

You need to put the code, somewhere it is being called EVERYTIME, on every Request. thats how PHP works, there is no "global application state"

by default Yii comes with protected/components/controller.php has base controller for the rest of the app.

my suggestion would be to put your code on the init() method of that controller, so that it always gets called.

You mentioned the database name comes from a table once the user logs in, so you need to save that value in the session, in other to be able to access it in the other requests:

<?php

// After login in
Yii::app()->user->setState('db_name', $db_name);

// in protected/components/controller.php
public function init()
{
    if (!Yii::app()->user->isGuest) {
        $db2 = Yii::createComponent(array(
            'class' => 'EMongoClient',
            'server' => 'mongodb://127.0.0.1:27017',
            'db' => Yii::app()->user->getState('db_name')
        ));

        Yii::app()->setComponent('db2',$db2);
    }
}

Hope it helps, I am assuming many things here :)

Collectives™ on Stack Overflow

PHP Yii: Database connect in runtime

3 Answers 3

Comments

6 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related