CODEWITHSUNDEEP
phpmysqldatabaselaraveleloquent
Rodolfo Jorge Nemer Nogueira
Rodolfo Jorge Nemer Nogueira

Reputation: 5100

Eloquent joins and queries in different databases on Laravel 5.3

How do I run this simple Mysql query in Laravel, from two different databases? 

SELECT * FROM database1.table1, database2.table2

And how I do joins in Eloquent on different databases?

Upvotes: 0

Views: 3421

Answers (2)

aynber
aynber

Reputation: 23010

As I mentioned, if the databases are on the same server and the mysql user has access to both databases, you can pass the tables in with DB::raw:

$q1 = DB::table(DB::raw('database1.table1 AS db1_tb1'))->select('*');
$results = DB::table(DB::raw('database2.table2 AS db2_tb2'))->select('*')
->union($q1)
->get();

For a join:

DB::table(DB::raw('database1.table1 AS db1_tb1'))
   ->join(DB::raw('database2.table2 AS db2_tb2'),'db1_tb1.first_key','=','db2_tb2.second_key')

Upvotes: 4

Antonio Carlos Ribeiro
Antonio Carlos Ribeiro

Reputation: 87719

You cannot use different connections to do that, so you should do something like:

$result = DB::connection('database1')->table('contacts')->get()
            ->union(
                DB::connection('database2')->table('contacts')->get()
            );

And if your Query Builder is does not return collections: 

$result = collect(DB::connection('database1')->table('contacts')->get())
            ->union(
                collect(DB::connection('database2')->table('contacts')->get())
            );

Upvotes: 3

Related Questions