How to get database name in Laravel 9 ?

• Get the database name using env helper function

  You can use the env helper function in controller or blade file to get the database name in Laravel.

  Here you can place below code in your view file to get the connected database name.

  {{  env('DB_DATABASE') }}
  

  You can also use the env helper function in your controller’s method. You can use the echo function with it to display the database name on your computer screen.

  //Controller's method
  $databaseName = env('DB_DATABASE');
  
  

• Get the database name using config helper function in Laravel

  You can use the config helper function to get the database name in Laravel. Here we have two different ways to get the database name using the config helper function.

  You can change the connection name from mysql to sqlite or pgsql as per your requirement. You can use the config helper function in your controller’s method or view file.

  Place code in Controller’s method (app\Http\Controllers<HomeController>.php)

  $databaseName = config('database.connections.mysql.database');
  
  $databaseName = Config::get('database.connections.'.Config::get('database.default'));
  

  Place code in view file (resources\views<welcome>.blade.php)

  
  {{ config('database.connections.mysql.database') }}
  

• Get the database name using DB facade in Laravel

  You can use the DB facade with connection() and getDatabaseName() method to get the database name in Laravel. First, you have to import the DB facade (use Illuminate\Support\Facades\DB;) at the top of the controller file to use it in your controller’s method.

  use Illuminate\Support\Facades\DB;
  

  Place code in controller’s method (app\Http\Controllers\HomeController.php)

  $databaseName = \DB::connection()->getDatabaseName();
  

  Place code in view file (resources\views\welcome.blade.php)

  {{ $databaseName = \DB::connection()->getDatabaseName() }}
  

Back to code snippet queries related laravel