change database connection in laravel model

Question

So i work with Laravel 4.2, what i want is in one of my models use an external database, this is my model code :

<?php class McibModel extends Eloquent {     /**       * The database table used by the model.       *       * @var string       */     //here i should call the external database table     protected $table = 'agencies'; } 

So please if someone has any idea i will be very appreciative.

Answer 1

Different models can have different database connections. So your models use the normal default connection - but your 'McibModel' model can use another connection:

class McibModel extends Model {      protected $connection= 'second_db_connection';      protected $table = 'agencies';  } 

Then in your DB connection file - you would have something like this:

return array(     'connections' => array(         'mysql' => array(             'driver'    => 'mysql',             'host'      => 'localhost',             'database'  => 'database1',             'username'  => 'user1',             'password'  => 'pass1'             'charset'   => 'utf8',             'collation' => 'utf8_unicode_ci',             'prefix'    => '',         ),          'second_db_connection' => array(             'driver'    => 'mysql',             'host'      => 'localhost',             'database'  => 'database2',             'username'  => 'user2',             'password'  => 'pass2'             'charset'   => 'utf8',             'collation' => 'utf8_unicode_ci',             'prefix'    => '',         ),     ),