How to specify database connection using statement method in Laravel

Question

I am running a raw query on Laravel using DB::statement() method. This statement needs to fetch data from my secondary database.

I wonder if there is any clean way to specify database connection to this method instead of using database name prefix before all fields.

Bogdan · Accepted Answer · 2015-12-28 19:05:48Z

5

Yes, you can use the connection method, which accepts any connection name stored in the config/database.php file:

DB::connection('pgsql')->statement('your statement here...');

You can read more in the Using Multiple Database Connections Documentation.

answered Dec 28, 2015 at 19:05

Bogdan

44.7k12 gold badges130 silver badges130 bronze badges

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

1 Comment

Bogdan Over a year ago

@JON The Database Connections Docs show that the API works exactly the same. I am using connections in one of my projects which runs on 5.6 and it works just fine, so the problem must be with your code not the Laravel API.

Collectives™ on Stack Overflow

How to specify database connection using statement method in Laravel

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related