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
Laravel tutorial full playlist • Laravel 9 tutorial

[@codestepbystep]

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

[@ektapatel_18]

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');

[@FarhanKhan-on9dc]

well i guess thats not possible, your code wont work like this

[@FarhanKhan-on9dc]

also if iam wrong kindly perform it and show me a screenshot

[@ashokbishwas]

Best of the best. plz make laravel project live video.

[@patitorodri]

thanks man, really clear

[@laibagillani2905]

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

[@yulius4527]

so we can't join tables from another server ?

[@sonukumargupta5230]

Thank You

[@saikumarkandikonda431]

yes joins can be applied on different databases as well

[@atiqulislam2626]

Yes

[@tariqkhan5206]

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();

[@skymatrix554]

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

[@sandipbamaniya8559]

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

[@DevsSebas]

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

[@mohamedanwar8165]

Thanks

[@hirucci8986]

Thanks a lot sir

[@ashokbishwas]

Interview question answer;
Everything is possible for computer. Joining two tables of different database is also possible.

[@hariprasadhari5045]

I think that joins can only apply on same data base

[@hariprasadhari5045]

if its wrong please replay me

[@laxmankumarrawat5690]

@@hariprasadhari5045 Yes join two table on different database
Model1::where('postID',$postID)
->join('database2.table2 as db2','Model1.id','=','db2.id')
->select(['Model1.*','db2.firstName','db2.lastName'])
->orderBy('score','desc')
->get();

[@manishakoladara8013]

is this possible second connection from another server database?

[@syedrizvi7455]

JOIN can apply on tables with in the same DB

[@zoyamalik8738]

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

[@TusharZambare]

but how to join databases tables 🤔 any solution

[@mitalgal7467]

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

[@eloircasas3827]

What if there is a different username on each database?

[@enas9895]

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

[@dannielmagano790]

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

[@aliefrahman694]

How to connect both mysql and sqlite?

[@ahangkhaneh]

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

[@codestepbystep]

Yes

[@ahangkhaneh]

@@codestepbystep So How? Would you please explain or give me a reference to learn that?

[@prachipandey8857]

@@codestepbystep same question sir❓?

[@SH-oe6vl]

Call to undefined method Illuminate\Database\MySqlConnection::tabel()
getting this error

[@tariqkhan5206]

It's table not tabel

[@melaniefisher2653]

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

[@ahangkhaneh]

Please answer my question.

[@insightfulpod]

Thank you