Laravel 8 tutorial - Multiple Database Connection

[@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

[@patitorodri]

thanks man, really clear

[@sandipbamaniya8559]

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

[@saikumarkandikonda431]

yes joins can be applied on different databases as well

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

[@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 ?

[@DevsSebas]

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

[@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

[@sonukumargupta5230]

Thank You

[@syedrizvi7455]

JOIN can apply on tables with in the same DB

[@manishakoladara8013]

is this possible second connection from another server database?

[@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❓?

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

[@hirucci8986]

Thanks a lot sir

[@TusharZambare]

but how to join databases tables 🤔 any solution

[@aliefrahman694]

How to connect both mysql and sqlite?

[@zoyamalik8738]

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

[@eloircasas3827]

What if there is a different username on each database?

[@mohamedanwar8165]

Thanks

[@mitalgal7467]

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

[@atiqulislam2626]

Yes

[@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

[@SH-oe6vl]

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

[@tariqkhan5206]

It's table not tabel

[@dannielmagano790]

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

[@ahangkhaneh]

Please answer my question.

[@melaniefisher2653]

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

[@insightfulpod]

Thank you