Laravel Eloquent | change database name within the same connection

Question

Im wondering is it possible to change database name within the same connection?

The reason is that Im working on a report which needs to loop through all of the databases (more than 100) within the same connection (host, user, pass).

Currently I just manually add the database name before each table name in query. Like:

"SELECT * FROM `database_a`.`users` WHERE ...";

I made some searches on Google with "change database name" or "switch database..." but most of them are about creating different connections array in config/database.php but thats not my case (with more than 100 databases)

Thanks

What kind of database?

jbrahy
– jbrahy

2017-06-23 20:44:59 +00:00
Commented Jun 23, 2017 at 20:44 — jbrahy
– jbrahy, Commented Jun 23, 2017 at 20:44

Eimantas Dev · Accepted Answer · 2017-01-24 22:46:57Z

4

What about defining database in table selection ?

class Book extends Model {

    protected $table = 'database1.books'

}

class Book2 extends Model {

    protected $table = 'database2.books'

}

answered Jan 24, 2017 at 22:46

Eimantas Dev

1,38613 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Louis L Over a year ago

Im using raw query :((

EddyTheDove · Accepted Answer · 2017-01-25 01:03:53Z

1

Since you are only changing the database name, create an array with all your databases names. Then using query builder you can do in a loop

DB::table($databasesArray[0].'.table_name')->where(...)

I think this would put you in the right track. E.g:

$databases = ['db1','db2'];

foreach($databases as $db) {
    $users [] = DB::table($db.'.users')->where('status', 'active')->get();
}
// $users = all users from all Databases

answered Jan 25, 2017 at 1:03

EddyTheDove

13.2k2 gold badges40 silver badges46 bronze badges

1 Comment

Louis L Over a year ago

Yeah thats what im doing, however I dont think thats good approach because I have to manually build the database name array. Thanks anw

Collectives™ on Stack Overflow

Laravel Eloquent | change database name within the same connection

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related