Laravel 8 - Changing database connection for model

Question

I am using laravel 8 and would like to query a model from my production database.

I tried the following:

DB::connection('mysql_prod')->Company::where('symbol', $symbol)
            ->first();

However, I get the following error:

Undefined property: Illuminate\Database\MySqlConnection::$Company

I would like to get a laravel model - in this case Company - back.

Any suggestions how to implement this?

John Lobo · Accepted Answer · 2021-07-04 08:16:27Z

2

use on if you are changing for one query.

 Company::on('mysql_prod')->where('symbol', $symbol)->first();

define $connection property in Company model so no need to mention connection

protected $connection = 'mysql_prod';

so query is

Company::where('symbol', $symbol)->first();

answered Jul 4, 2021 at 8:06

John Lobo

15.4k2 gold badges18 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Thx for your reply! I would like to define the connection property locally as I only want to change the connection in this 1 function.

@Carol.Kar use on Company::on('mysql_prod')->where('symbol', $symbol)->first();

Davit Zeynalyan · Accepted Answer · 2021-07-04 08:16:17Z

1

You can use

Company::on('mysql_prod')->where('symbol', $symbol)
            ->first();

answered Jul 4, 2021 at 8:16

Davit Zeynalyan

8,6485 gold badges33 silver badges57 bronze badges