Laravel Eloquent multiple database [duplicate]

Question

I have multiple database connected into my web app.

These are: write and read

I have this eloquent database query:

$users = User::whereIsAdmin(0)->get();

I want this db query to use the read database since by default my app is reading in the write database.

How would I do that?

Thanks!

Taha Paksu · Accepted Answer · 2017-04-03 11:45:20Z

2

I looked at the source code of Laravel Eloquent Models, and here:

It says on should be used to change connections.

So:

User::on("read")->whereIsAdmin(0)->get();

answered Apr 3, 2017 at 11:34

15.6k2 gold badges50 silver badges83 bronze badges

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

4 Comments

I will try that. That looks promising :)

I am getting this error: Non-static method Illuminate\Database\Eloquent\Model::setConnection() should not be called statically

Updated my answer

perfect! This is what i'm looking for :)