Laravel Change Connection Dynamically

by

I will go for a helper here. Let’s create one in app/Helpers/DatabaseConnection.php. 

namespace App\Helpers;
use Config;
use DB;

class DatabaseConnection
{
    public static function setConnection($params)
    {
        config(['database.connections.onthefly' => [
            'driver' => $params->driver,
            'host' => $params->host,
            'username' => $params->username,
            'password' => $params->password
        ]]);

        return DB::connection('onthefly');
    }
}

And now somewhere in controller we try

use App\Helpers\DatabaseConnection;
... 

$params = Database::find( 1 );
$connection = DatabaseConnection::setConnection($params);
$users = $connection->select(...);

Note: Not tested. I hope it works or simply guide you

More info:

More Related Contents:

  1. Laravel one to many relation with a one to one relation
  2. How to use multiple databases in Laravel
  3. PDOException SQLSTATE[HY000] [2002] No such file or directory
  4. Get the Last Inserted Id Using Laravel Eloquent
  5. Laravel: Error [PDOException]: Could not Find Driver in PostgreSQL
  6. How to connect to mssql using pdo through PHP and Linux?
  7. Proper Repository Pattern Design in PHP?
  8. Laravel – Database, Table and Column Naming Conventions?
  9. Laravel nested relationships
  10. laravel 4 custom named password column
  11. How to build an public/private API for some website without involve their developers for an Android client app [closed]
  12. Laravel requires the Mcrypt PHP extension
  13. How to to send mail using gmail in Laravel?
  14. How to insert multiple rows from a single query using eloquent/fluent
  15. Laravel – Eloquent or Fluent random row
  16. How to sort a Laravel query builder result by multiple columns?
  17. Extension gd is missing from your system – laravel composer Update
  18. Can’t install laravel installer via composer
  19. Laravel 4 – logging SQL queries
  20. Laravel catch TokenMismatchException
  21. How Follow the Don’t Repeat Yourself Principle When Consuming My Own Laravel API?
  22. phpmyadmin automatic logout time
  23. How to select all column name from a table in laravel?
  24. Call to undefined method Maatwebsite\Excel\Excel::load()
  25. Why I am getting an error when using w3school tutorial? [duplicate]
  26. Laravel error: Missing required parameters for route
  27. disable csrf in laravel for specific route
  28. Laravel pluck fields from relations
  29. laravel 5 : Class ‘input’ not found
  30. Merge ‘with’ and ‘whereHas’ in Laravel 5

Leave a Comment