Laravel 8 tutorial - Multiple Database Connection

In this laravel 8 and laravel 9 version API tutorial, we learn how to make multiple database connections in laravel with a simple way. This video is made by anil Sidhu in the English language.

Multiple DB Connection
DB config
Make Controller and Model
Multiple DB with Query Builder
Multiple DB with Model
Interview Question

[codestepbystep]

Please support me by subscribe, like and comment :) thank you

[ektapatel_]

Yes, it's possible as long as they are on the same server, for example: $result = \DB::table('db1. users') ->join('db2. users', 'db2.users.id', '=', 'db1.users.id') ->select('db1.users.id', 'db2.user.id');

[laibagillani]

SQL Server allows you to join tables from different databases as long as those databases are on the same server. The join syntax is the same; the only difference is that you must fully specify table names

[sandipbamaniya]

is it possible to connect live server database to local server like xampp?

[tariqkhan]

Yes it is possible just use the db name with both of the tables. Like:
Return Model_name::join('db1.tablename', 'db2.tablename.id', '=', 'db1.tablename.id')
->select('tablename.*)
->get();

[saikumarkandikonda]

yes joins can be applied on different databases as well

[skymatrix]

I am having ERP software in laravel, I have 100+database in it , each organisation have different database how to create 100+ database for ERP, any solution is having for this problem, please help me to solve this

[DevsSebas]

so good bro, but i need see the Divice model please(the estructure) thansk..

[manishakoladara]

is this possible second connection from another server database?

[syedrizvi]

JOIN can apply on tables with in the same DB

[ahangkhaneh]

Hey Anile. Can Laravel connect to two databases in different servers?

[hariprasadhari]

I think that joins can only apply on same data base

[zoyamalik]

Aik database ma agr multiple tables bna rahy hy to ksay kry gy

[enas]

there are many problems
1- create one migrations table for all databases not create one for each
2- any migration for any database add it in migrations table in mysql driver example (create table students in mysql2 migration recored in migrations table in mysql not mysql2 🙃
3- if you try build relation through another table belogns to different database driver not work
4- php artisan migrate:fresh give table exisits but not drop from second database

[eloircasas]

What if there is a different username on each database?

[TusharZambare]

but how to join databases tables 🤔 any solution

[mitalgal]

Sir I’m not able to get data by using model

[dannielmagano]

Hi sir. I got an Error
SQLSTATE[HY000] [1045] Access denied for user 'forge'@'localhost' (using password: NO) (SQL: select * from `users`)

[SH-oevl]

Call to undefined method
getting this error

[melaniefisher]

Hello bro, can you open your telegram? I want to buy these tools.