How to check your Laravel database connection

The Laravel framework is great for swiftly building applications. It allows you to connect to a database rapidly. If you’re working on a local development project, you’ll probably need to check at some point—possibly when you’re troubleshooting—to see if the application is connected to a database.

If you need to check database connection exists or not in laravel. Then I will give you simple two examples using DB PDO and DB getDatabaseName().

How to check your Laravel database connection

A line of code will return “none” if the name of the current database connection cannot be identified. There are two methods.

1. Anywhere in a Blade template or PHP file will do.
2. Place it in a random file and dump() it to the dump server

1. Echo the Laravel database name in Blade/PHP

The following script should be added to a Blade or PHP file for the simplest solution. If there is no connection, this will return “none” or the name of the database.

<strong>Database Connected: </strong>
<?php
    try {
        DB::connection()->getPDO();
        echo DB::connection()->getDatabaseName();
        } catch (Exception $e) {
        echo 'None';
    }
?>

2. Using the dump server to check this

However, you could also put it in a controller or the boot() function in the app/Providers/AppServiceProvider.php file, in addition to Blade or PHP. Personally, I think it ought to go in the boot() procedure.

try {
    DB::connection()->getPDO();
    dump('Database connected: ' . DB::connection()->getDatabaseName());
} catch (Exception $e) {
    dump('Database connected: ' . 'None');
}

Using the php artisan dump-server command to check the database connection.

Thank you for reading check your Laravel database connection, Hope this code and post will helped you for implement How to check your Laravel database connection. if you need any help or any feedback give it in comment section or you have good idea about this post you can give it comment section. Your comment will help us for help you more and improve us. we will give you this type of more interesting post in featured also so, For more interesting post and code Keep reading our blogs