
How to get database name in Laravel 9 ?
Today we are going to learn about "how to get the database name in Laravel 9
". Here we have different ways to get the name of the database which is connected to the Laravel application.
Simply you can visit the .env file to see the database name which is at the root of your project directory and you can also write some code in the controller or view file to get the database name in Laravel.
Here we can use below code in controller as well as view file to get the database name in Laravel.
env('DB_DATABASE');
-
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() }}
If you like what you are reading, please consider buying us a coffee ( or 2 ) as a token of appreciation.
Don't forget to share this article! Help us spread the word by clicking the share button below.
We appreciate your support and are committed to providing you valuable and informative content.
We are thankful for your never ending support.
Random Code Snippet Queries: Laravel
- How to get specific columns using Laravel eloquent methods
- Update record after find method in lavavel
- Json encode method in laravel
- Call to a member function pluck() on null
- How to pass two variables in HREF in laravel
- SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key
- How to remove P tag from CkEditor in Laravel?
- The POST method is not supported for this route. Supported methods: PUT.
- SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'posts_user_id_foreign'; check that column/key exists
- How to display validation error in laravel
- How to check duplicate entry in laravel
- Array to string conversion laravel blade
- Laravel route redirect not working
- Route group with URI prefix using middleware and route name prefixes
- How to create laravel project using composer
- Laravel save object to database
- Return redirect laravel not working
- Retrieve count of nested relationship data in Laravel
- How to get tomorrow and yesterday date in laravel
- Class 'App\Providers\Auth' not found
- Insert Comma Separated Values in laravel
- Syntax error or access violation: 1072 Key column 'role_id' doesn't exist in table (SQL: alter table `users` add constraint `users_role_id_foreign` foreign key (`role_id`) references `roles` (`id`))
- Add class to body in laravel view
- Class App\Http\Controllers\Admin\UserController Does Not Exist
- How to display order by null last in laravel