Is there any way to connect to multiple dynamic databases in controller side using cakephp 3.7?

Question

We are using a connection manager to do the process but we are unable to achieve the thing that we needed. we tried different ways to unable to connect to dynamic multiple databases. below is the code which we are using.

php 5.6 above with cakephp 3.7 versions.

use Cake\Controller\Component;
use Cake\ORM\TableRegistry;
use Cake\Datasource\ConnectionManager;
use Cake\Database\Connection; 
use Cake\Database\Driver\Mysql;

public function setDatabase($company_id, $datasource = 'default') {
       $dbConf = ConnectionManager::getConfig($datasource); //Here connect to dynamic database.
       $dbConf['database'] = "db_".$company_id;//changing database name to which we need to connect with same configurations
       $dbConf['name'] = "company";
       $dbConf['encoding'] = 'utf8';
       ConnectionManager::setConfig('company', $dbConf );
       // ConnectionManager::config('company', $dbConf );
       $JobSeekers = TableRegistry::get('JobSeekers');
       $JobSeekers_details = $JobSeekers->find('all'); // firing query jobseekers table but still it's excueting in default db instead of company db.which trows error
       $JobSeekers_data = $JobSeekers_details->first();
      pr($JobSeekers_data);
}

What we need is jobseeker query must be execute in company level database but we are getting following error which says connection still in default db.

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'default_db.job_seekers' doesn't exist

Might be a useful read https://stackoverflow.com/questions/29981890/multiple-database-connection-in-cakephp-3 — RiggsFolly, Jul 25 '19 at 08:55
Or this https://stackoverflow.com/questions/38587294/connect-with-multiple-database-in-cakephp-3 — RiggsFolly, Jul 25 '19 at 08:56
Or this https://stackoverflow.com/questions/20917647/how-to-connect-two-db-in-cakephp — RiggsFolly, Jul 25 '19 at 08:57
@RiggsFolly. Surely will look into them. Thanks for the references — PHP CODER, Jul 25 '19 at 09:02

Is there any way to connect to multiple dynamic databases in controller side using cakephp 3.7?

0 Answers0