如何在CakePHP中为一个模型动态使用多个数据库?mysql

无论如何，这是我的最终解决方案，我将其放入app/Model/AppModel.php：

class AppModel extends Model { /** * Connects to specified database * * @param String name of different database to connect with. * @param String name of existing datasource * @return boolean true on success, false on failure * @access public */ public function setDatabase($database, $datasource = 'default') { $nds = $datasource . '_' . $database;
$db = &ConnectionManager::getDataSource($datasource);

  $db->setConfig(array(
    'name'       => $nds,
    'database'   => $database,
    'persistent' => false
  ));

  if ( $ds = ConnectionManager::create($nds, $db->config) ) {
    $this->useDbConfig  = $nds;
    $this->cacheQueries = false;
    return true;
  }

  return false;
}

} 这就是我在我中使用它的方式app/Controller/CarsController.php：

class CarsController extends AppController { public function index() { $this->Car->setDatabase('cake_sandbox_client3');

$cars = $this->Car->find('all');

$this->set('cars', $cars);

}

} 我敢打赌，我不是这个问题的第一个或最后一个。所以我真的希望这些信息能找到人们和CakePHP社区。来源：stack overflow