I have been conducting extensive research and reading various documentations, but unfortunately, I haven't found a solution to my problem.
Currently, I have two databases connected through the Propel configuration. Both databases share the same structure and tables.
For each database, I have created a schema.xml file named as db1.schema.xml and db2.schema.xml respectively.
In addition, I made modifications to my config.php file:
<?php
$serviceContainer = \Propel\Runtime\Propel::getServiceContainer();
// Rest of the PHP code...
I also made changes to my propel.json file:
{
"propel": {
// JSON configuration data...
}
Despite these modifications, I am unsure about what steps to take next. How can I specify in my query which database to use?
<?php
require_once 'vendor/autoload.php';
require_once 'generated-conf/config.php';
use nhlonline\AuthorQuery;
$author = AuthorQuery::create()->find();
foreach($author as $pub){
echo $pub->getFirstName() . '<br>';
}
?>
Even when attempting the above, I encountered an error (The AuthorQuery class file is correctly located in the folder):
Fatal error: Uncaught Error: Class 'Base\AuthorQuery' not found in C:\xampp\htdocs\nhlonline\nhlonline\AuthorQuery.php:15 Stack trace: #0 C:\xampp\htdocs\nhlonline\vendor\composer\ClassLoader.php(444): include() #1 C:\xampp\htdocs\nhlonline\vendor\composer\ClassLoader.php(322): Composer\Autoload\includeFile('C:\xampp\htdocs...') #2 [internal function]: Composer\Autoload\ClassLoader->loadClass('nhlonline\Autho...') #3 C:\xampp\htdocs\nhlonline\test.php(8): spl_autoload_call('nhlonline\Autho...') #4 {main} thrown in C:\xampp\htdocs\nhlonline\nhlonline\AuthorQuery.php on line 15