Laravel get all database connection name

Question

I have multiple database defined in my laravel installation inside database.php and I would like to loop all database and perform the same operation in everyone. Something like this:

foreach ($somethingunknown as $connection){
    DB::connection($connection)->table('users')->where('id','=',1)->delete();
}

What is the best way to get all database name? Maybe if possible something with wildcard support.

Likely a typo, but ->where('id,'=',1) is a syntax error, should be ->where('id','=',1) (missing a ' after id) — Tim Lewis
– Tim Lewis, Commented Nov 20, 2019 at 16:27
@TimLewis That wasn't he point of the question, but nice catch. Edited. — Alexandre Danault
– Alexandre Danault, Commented Nov 20, 2019 at 18:36
@AlexandreDanault Haha yeah. I could have edited myself (as like I said, figured it was a typo), but I tend to let the asker do that just it case it is, in fact, an error in their code. Thanks for fixing! — Tim Lewis
– Tim Lewis, Commented Nov 20, 2019 at 18:43

Alexandre Danault · Accepted Answer · 2019-11-20 16:12:14Z

2

This:

config('database.connections')

returns an array of all your connections and their settings.

answered Nov 20, 2019 at 16:12

Alexandre Danault

8,6923 gold badges34 silver badges35 bronze badges

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

Collectives™ on Stack Overflow

Laravel get all database connection name

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related