Cakephp calls data tables in different databases

When using the framework cakephp for a project, the following problem occurs: you need to create a database, link the project to the table in the new database, and use loadModel ('testquestion '); however

When using the framework cakephp for a project, the following problem occurs: you need to create a database, link the project to the table in the new database, and use loadModel ('testquestion '); then $ this-> testQuestion-> useDbConfig = 'testbase'; this logic should be correct, but the default database in database configuration is wss, this table does not exist in this database,

Php code

1. Class DATABASE_CONFIG {
3. Var $ default = array (
4. 'Driver '=> 'mysql ',
5. 'Persistent' => false,
6. 'Host' => '2017. 168.9.10 ',
7. 'Login' => 'root ',
8. 'Password' => '123 ',
9. 'Database' => 'wss ',
10. 'Encoding' => 'utf8 ',
11. 'Prefix' => '',
12. );
13. Var $ testBase = array (
14. 'Driver '=> 'mysql ',
15. 'Persistent' => false,
16. 'Host' => '2017. 168.9.10 ',
17. 'Login' => 'root ',
18. 'Password' => '123 ',
19. 'Database' => 'wss _ test ',
20. 'Encoding' => 'utf8 ',
21. 'Prefix' => '',
22. );

class DATABASE_CONFIG {var $default = array('driver' => 'mysql','persistent' => false,'host' => '192.168.9.10','login' => 'root','password' => '123456','database' => 'wss','encoding' => 'utf8','prefix' => '',);        var $testBase = array('driver' => 'mysql','persistent' => false,'host' => '192.168.9.10','login' => 'root','password' => '123456','database' => 'wss_test','encoding' => 'utf8','prefix' => '',);

When the page is displayed, the error 404 is returned. Finally, the solution is found as follows:

Php code

1. /*
2. * Model in testBase Library
3. *
4. */
5. Class TestQuestion extends AppModel {
6. Public $ name = 'preschooltestquestion ';
7. Var $ useDbConfig = 'testbase ';
8. Var $ useTable = false;
9. }

/** Model **/class TestQuestion extends AppModel {public $ name = 'preschooltestquestion '; var $ useDbConfig = 'testbase'; var $ useTable = false ;}

Create a model file named "wss_test" in the models folder and specify the database to use.

By the way: if the default database contains this table, you do not need to create a model file. For example, you can make loadModel ('testquestion') in the master/slave database; then $ this-> testQuestion-> useDbConfig = 'testbase ';