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.

Check your database details in .env file.Correct your database connection in .env file.It should work for you. — Chonchol Mahmud
– Chonchol Mahmud, Commented Jan 2, 2017 at 9:28
I don't want to fix it, I purposely broke it to try and display a custom view. My question is, HOW do I display a CUSTOM view. — Ashkru
– Ashkru, Commented Jan 2, 2017 at 9:28

shoieb0101 · Accepted Answer · 2017-01-02 09:43:03Z

4

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.

edited Jan 2, 2017 at 9:43

answered Jan 2, 2017 at 9:37

shoieb0101

1,58210 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Ashkru Over a year ago

Thank you, is there any way I can do something similar to handle 500 error codes?

shoieb0101 Over a year ago

if you want to show a custom view for http error, I think you can put your error files in views/errors/error_code.blade.php ( in your case views/errors/500.blade.php). Laravel should pull that file automatically. Please accept the answer if it solved your issue.

Collectives™ on Stack Overflow

Handling DB failed to connect in laravel?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related