Laravel: connect to databases dynamically

by

The simplest solution is to set your database config at runtime. Laravel might expect these settings to be loaded from the config/database.php file, but that doesn’t mean you can’t set or change them later on.

The config loaded from config/database.php is stored as database in Laravel config. Meaning, the connections array inside config/database.php is stored at database.connections.

So you can easily override/change these connections like this:

Config::set("database.connections.mysql", [
    "host" => "...",
    "database" => "...",
    "username" => "...",
    "password" => "..."
]);

From there on out, any Eloquent models that use this mysql connection will be using this new database connection config.

I’d recommend doing this in a Service Provider if possible.

More Related Contents:

  1. SQLSTATE[HY000] [2002] A connection attempt failed.. – When attempting to connect from Local to remote server
  2. How do I store a custom user selected CSS template style (like wordpress visual editor)? [closed]
  3. Laravel – only a zero is saved to the database
  4. How to use multiple databases in Laravel
  5. How to do this in Laravel, subquery where in
  6. Laravel 5 PDOException Could Not Find Driver
  7. How to create Helper Methods on Laravel not a Facade
  8. Laravel migration: unique key is too long, even if specified
  9. Laravel: PDOException: could not find driver
  10. Laravel Eloquent select all rows with max created_at
  11. Laravel OrderBy relationship count
  12. Laravel 5.2 – Use a String as a Custom Primary Key for Eloquent Table becomes 0
  13. How to bind parameters to a raw DB query in Laravel that’s used on a model?
  14. Laravel Migration table already exists, but I want to add new not the older
  15. How to execute raw queries with Laravel 5.1?
  16. “No such file or directory” or “No such host is known” when running migrations
  17. Laravel $q->where() between dates
  18. belongsToMany relationship in Laravel across multiple databases
  19. How Can I Set the Default Value of a Timestamp Column to the Current Timestamp with Laravel Migrations?
  20. Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL)
  21. Laravel Eloquent get results grouped by days
  22. php artisan migrate throwing [PDO Exception] Could not find driver – Using Laravel
  23. Change name of Laravel’s created_at and updated_at
  24. Base table or view not found: 1146 Table Laravel 5
  25. How do I get database column names in Laravel?
  26. How to get MySql 8 to run with laravel? [duplicate]
  27. Eloquent many-to-many-to-many – how to load distant relation easily
  28. laravel 5 : Class ‘input’ not found
  29. Mysql InnoDB engine in Laravel
  30. Create a Insert… Select statement in Laravel

Leave a Comment