Dynamically Change database connection for web route laravel

Question

I want to change the database connection dynamically. I have created middleware for changing database connections. it works on API routes. But it does not work on the web routes.

below middleware code:

public function handle($request, Closure $next)
    {
        $cookie_name = 'x-connection-object';
        if(!empty($_COOKIE[$cookie_name])) {
            $connection = trim($_COOKIE[$cookie_name]);
            $db = strlen($connection) ? $connection : 'test213';
            \Config::set('database.default', 'mysql');
            $user = User::where('code', 'like', $db)->first();
            if($school) {
                \Config::set('database.default', $user->connection_name);
            } else {
                $error['institute_code'][]='Please Check Code';
                return response()->json(['errors'=>$error],422);
            }
        }
        return $next($request);
    }

I checked Database Name while running it shows the old database name it does not show the new database name.

sajjad · Accepted Answer · 2022-06-25 00:56:46Z

1

use below code in Middleware

\Illuminate\Support\Facades\DB::setDefaultConnection('connection1');

and for another connection

\Illuminate\Support\Facades\DB::setDefaultConnection('connection2');

answered Jun 25, 2022 at 0:56

sajjad

4875 silver badges14 bronze badges

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

Collectives™ on Stack Overflow

Dynamically Change database connection for web route laravel

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