Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.
Hi, I have to connect to Multiple databases from my laravel framework.
We are setup with three servers. First is the web server, and there are two licence servers. The licence servers basically have one table each that contains there login info and available licenses. This is a basic c++ to php http call with an RSA encryption. Not really important info for this question.
The main web server would need to update both licence server tables whenever a user adds a licence or changes their password, or even when the first signup need to make a new entry in both licence server tables. So the long and short is I will need to interact with 3 server database in many different parts of our web server.
Where do I start with laravel? Add all three dB info to the globe files? How mysql1 mysql2, and mysql3?
And how do I define this in a model? In my user model I would need to tell each call what dB to get or put to.
Thanks for any advice on getting started.
Si
This is described in the documentation
https://laravel.com/docs/5.7/database#using-multiple-database-connections
Just add each of your connection details to config/database.php
In your model you can add
protected $connection = "connetion_name";
connection_name needs to match the name in you config. You can then use eloquent as normal.
Great thanks!
@SiNi_Si - if me response answers your question can please mark as solved so others can find the solution
sorry for the dumb question, but how do you make it solved?
@SiNi_Si - I take it you found it but for anyone else - click the tick icon next to the correct response
I did find this link and thought it might be useful to someone else.
Please or to participate in this conversation.