Model Based Setting Different Connection
Submitted by dhrubo001 - 9 years ago
Model Based Setting Different Connection when working with 2 or more database in laravel
1. First Create You Connection in database.php
'mysql' => array(
'driver' => 'mysql',
'host' => 'localhost',
'database' => 'superadmin',
'username' => 'root',
'password' => 'knwall',
'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',
'prefix' => '',
),
'mysql2' => array(
'driver' => 'mysql',
'host' => 'localhost',
'database' => 'framework',
'username' => 'root',
'password' => 'knwall',
'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',
'prefix' => '',
),
2.Now just specify which connection to use in models default will use the "mysql" connection
A)Organization.php
class Organization extends Eloquent{
//// will use "mysql
}
B)class FrameworkOrganization extends Eloquent{
protected $connection = 'mysql2'; /// Other connection
}
Stats
-
4 likes
- 5890 views