How to use multiple db2 databases in laravel?
How to use multiple db2 databases in laravel?
1 answer
by
domenico ,
a month ago
@deron
To use multiple DB2 databases in Laravel, you can follow these steps:
- Configure database connections in your config/database.php file. You can create multiple database connections by adding them to the connections array in the configuration file. For example:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 |
'connections' => [
'default' => [
'driver' => 'db2',
'database' => env('DB_DATABASE', 'homestead'),
'host' => env('DB_HOST', '127.0.0.1'),
'username' => env('DB_USERNAME', 'homestead'),
'password' => env('DB_PASSWORD', 'secret'),
'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',
'prefix' => '',
'schema' => 'YOUR_SCHEMA',
'commands' => [],
],
'secondary' => [
'driver' => 'db2',
'database' => env('DB_SECONDARY_DATABASE', 'secondary'),
'host' => env('DB_SECONDARY_HOST', '127.0.0.1'),
'username' => env('DB_SECONDARY_USERNAME', 'homestead'),
'password' => env('DB_SECONDARY_PASSWORD', 'secret'),
'charset' => 'utf8',
'prefix' => '',
'schema' => 'SECONDARY_SCHEMA_NAME',
],
],
|
- Update your .env file to include the connection details for each database. For example:
1 2 3 4 5 6 7 8 9 10 11 |
DB_CONNECTION=default DB_HOST=127.0.0.1 DB_DATABASE=homestead DB_USERNAME=homestead DB_PASSWORD=secret DB_SECONDARY_CONNECTION=secondary DB_SECONDARY_HOST=127.0.0.1 DB_SECONDARY_DATABASE=secondary DB_SECONDARY_USERNAME=homestead DB_SECONDARY_PASSWORD=secret |
- Utilize the DB facade to switch between connections in your code. You can specify the connection to use for each query by calling the connection method on the DB facade. For example, to query data from the secondary database, you can do:
1
|
$data = DB::connection('secondary')->table('table_name')->get();
|
By following these steps, you can easily use multiple DB2 databases in your Laravel application.