Eloquent to access another DB | Rex's Personal Site

class SomeController extends BaseController {

    public function someMethod()
    {
        $someModel = new SomeModel;

        $someModel->setConnection('mysql2'); // non-static method

        $something = $someModel->find(1);

        $something = SomeModel::on('mysql2')->find(1); // static method

        return $something;
    }

}

class SomeController extends BaseController {

public function someMethod()

{

$someModel = new SomeModel;

$someModel->setConnection('mysql2'); // non-static method

$something = $someModel->find(1);

$something = SomeModel::on('mysql2')->find(1); // static method

return $something;

}

Create another class to extend model

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class ChangeSiteM extends Model {
    //protected $connection = 'mysql-tw';

    public function __construct(){
        $this->connection = 'mysql-tw';
    }
}

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

class ChangeSiteM extends Model {

//protected $connection = 'mysql-tw';

public function __construct(){

$this->connection = 'mysql-tw';

}

Reference:

https://stackoverflow.com/questions/31847054/how-to-use-multiple-databases-in-laravel

M	T	W	T	F	S	S
	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	26	27
28	29	30	31