Handling DB failed to connect in laravel?

Question

I was wondering if there was a way where I can display a custom view when laravel fails to connect to the database? I have tried googling an answer for this but it really doesn't display anything useful.

I currently get:

Whoops, looks like something went wrong.

2/2
QueryException in Connection.php line 770:
SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES) (SQL: select * from `users` where `users`.`id` = 1 limit 1)

Thanks.

Answer 1

In your app/Exceptions/Handler.php, go to render method . You can add the following exception checking to handle query and pdo exception

    if ($e instanceof \Illuminate\Database\QueryException) {
        dd($e->getMessage());
        //return response()->view('custom_view');
    } elseif ($e instanceof \PDOException) {
        dd($e->getMessage());
        //return response()->view('custom_view');
    }

Replace dd($e->getMessage()); with your custom code.