如何使用CakePHP上的数据库postgres参考设置database.config信息？

Question

I want to set the database config from CakePhP 2.x with data from database

Example - database.config:

public $bd_test = array (
        'datasource' => 'Database/Postgres',
        'persistent' => false,
        'host' => 'localhost',
        'login' => 'root',
        'password' => 'root',
        'database' => 'bd_test',
        'port' => '5432',
        //'encoding' => 'UTF-8'
);

Should looks like:

$dataFromDb = $this->Model->find('all', array('fields' => array('host', 'login', 'password', 'database', 'port'), 'conditions' => array('database' => 'bd_test')));

public $bd_test = array (
        'datasource' => 'Database/Postgres',
        'persistent' => false,
        'host' => $dataFromDb['host'],
        'login' => $dataFromDb['login'],
        'password' => $dataFromDb['password'],
        'database' => $dataFromDb['database'],
        'port' => '5432',
        //'encoding' => 'UTF-8'
);

Something like that.. I guess that the Idea is clear, right? If need some more information, please tell me. Thanks.

Answer 1

You should be able to set config-datasets at runtime with Configure::write('nameofconfigfield,'value'); If this does'nt work, I'm sorry. I'm not familiar with CakePHP 2.x, I only used 3.x.

I answered like I understood your question. But I don't know what you want to achieve with changing the DB connection at runtime.