How to handle Query Exception in Laravel?

Question

I'm looking for any way to handle the QueryException using the laravel framework.

Is there any possible way to prevent the usual user from getting such an error with a handler?

I tried to prevent that black detailed error page not to be visible to any user.

Does this answer your question? How do I catch a query exception in laravel to see if it fails? — Sumit Wadhwa
– Sumit Wadhwa, Commented Jan 18, 2021 at 18:13
@ s.wadhwa yes it does work. But I'm looking for something to be applied to all functions. — Mohamed Mahfouz
– Mohamed Mahfouz, Commented Jan 18, 2021 at 18:17
You can also look the Ashraf Hefny answer in the question provided by s.wadhwa to apply it to all functions. — porloscerros Ψ
– porloscerros Ψ, Commented Jan 18, 2021 at 18:34
There's a whole section in the documentation on error handling. I suggest you take a look at that as well, but most important is setting APP_DEBUG to false for non development environments. — apokryfos
– apokryfos, Commented Jan 18, 2021 at 19:04

STA · Accepted Answer · 2021-01-18 18:31:09Z

1

Catch an exception on using try-catch statements :

Use Exception;

try
{
   // write your codes here
}
catch(\Exception $e)
{
   //dd($e->getMessage());
   return "Something Went Wrong";
}

If you want to catch PDO Exception :

use PDOException;

try
{
   //write your codes here
} 
catch(\PDOException $e)
{
   //dd($e->getMessage());
   return "Something Went Wrong":
}

answered Jan 18, 2021 at 18:31

STA

35.3k9 gold badges49 silver badges62 bronze badges

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

1 Answer 1