Multiple DB Connections in Laravel 5

Few day back while developing an application I come up to a point where I need to connect to the different database dynamically. I google around and I found few good solution in multiple websites; So I thought to stitch them into a single piece.

Before proceeding we first have to edit our database.php which is located in /config/database.php for Lavael 4.2 it is in app/config/database.php.

Now that we have set the DB connections it’s time to use it

Defining in Model

If have Model which uses a different database then we can define it at the model level like this:

In Eloquent Query

In DB Query

Let me know through the comment if I missed out any point. Cheers!

About Rana Ghosh

I'm a PHP, MySQL, jQuery expert, and designing specialist. My elating approach of seeing web world with a different sight leaves others amazed. My skills include codeigniter, Laravel. I enjoy taking challenges. I love to play FIFA Online 3. View all posts by Rana Ghosh →

Creating Simple Product using WooCommerce CRUD

25 03 2018
0

new way of creating, updating or deleting a product or an order using CRUD method. In this tutorial, we'll be learning how to use it to create or update a product.

MySQL Query to Get All Coupon

06 01 2018
3

blished WooCommerce Coupon.

Keyboard Shortcuts for NetBeans, Sublime Text and PhpStorm

10 12 2017
5

keyboard hack ;) Spend time finding the correct menu for a specific action and forgot afterwards. Then why not use keyboard shortcuts which might come handy.

How to Get Order Details by Order ID

mmerce full order details by Order ID? Don't worry in this tutorial I have written one function that will help to get the details in a fraction of a second.

2 thoughts on “Multiple DB Connections in Laravel 5”

Susie April 22, 2017 at 3:05 am

+1
Reply
ucretsiz December 23, 2020 at 10:19 am

I think this is a real great article. Much thanks again. Fantastic.
Reply

Multiple DB Connections in Laravel 5