All I'm trying to do is verify a query.
'SELECT * from table_that_does_not_exist'
Without that erroring out, I'd like to know it failed so I can return a response that states "Error: table does not exist" or the generic error.
asked Nov 12, 2015 at 19:45
4 Answers
The simplest way to catch any sql syntax or query errors is to catch an Illuminate\Database\QueryException after providing closure to your query:
try {
$results = \DB::connection("example")
->select(\DB::raw("SELECT * FROM unknown_table"))
->first();
// Closures include ->first(), ->get(), ->pluck(), etc.
} catch(\Illuminate\Database\QueryException $ex){
dd($ex->getMessage());
// Note any method of class PDOException can be called on $ex.
}
If there are any errors, the program will die(var_dump(...)) whatever it needs to.
Note: For namespacing, you need to first \ if the class is not included as a use statement.
Also for reference:
answered Nov 12, 2015 at 21:01
-
4For Laravel 5.5 this answer doesn't work for me. Please refer to this question: stackoverflow.com/questions/49881563/… Commented Apr 21, 2018 at 3:13
-
In my case sometime mysql server goes down, we are working to fix though. IN the meantime, how to handle this connection error showing (SQLSTATE[HY000] [1045] Access denied for user) explicitly and show soft error message?– Anto SCommented Aug 23, 2020 at 6:36
-
@Butterfly That's beyond the scope of this question. Try searching Stackoverflow for that error, or ask a new question. Commented Aug 24, 2020 at 3:59
-
1Reference link is broken, this one works: laravel.com/api/8.x/Illuminate/Database/QueryException.html– Asaf MCommented Sep 22, 2021 at 13:49
-
1Worked for Lumen 8, thanks! I was using just
Exceptionwhich didn't catchQueryException, now when specified\Illuminate\Database\QueryExceptionit captures it!– SinišaCommented Feb 12, 2022 at 6:48
Wrap the lines of code you wish to catch an exception on using try-catch statements
try
{
//write your codes here
}
catch(Exception $e)
{
dd($e->getMessage());
}
Do not forget to include the Exception class at the top of your controller by saying
Use Exception;
answered Jan 15, 2019 at 9:04
-
5This is exactly what I was trying to do, I didn't have use Exception at the top of my controller file but wasn't getting an error when trying to use it. Thanks a million! Commented May 19, 2019 at 4:14
-
-
1or just use backslash before exception so it doesn't need to "Use Exception;" : catch(\Exception $e) Commented Nov 14, 2023 at 5:25
If you want to catch all types of database exceptions you can catch it on laravel Exception Handler
if ($exception instanceof \PDOException) {
# render a custom error
}
for more details about how to use laravel Exception Handler check https://laravel.com/docs/7.x/errors
answered Oct 23, 2018 at 12:17
-
1Please really should upvote this. Best answer by far, thanks! Commented Oct 22, 2019 at 22:55
-
-
Thanks Ashraf , that is very helpful. Example in app/Exceptions/Handler.php : public function report(Throwable $exception) { if ($exception instanceof \PDOException) { dd("Error connecting to database, please turn on MySQL database server"); } parent::report($exception); }– Naim R.Commented Jul 2, 2021 at 7:07
Laravel 8.x
try {
$model->save(); // Use Eloquent: https://laravel.com/docs/8.x/eloquent
} catch (\Throwable $e) {
return 'My error message';
}
Note* Need to specify \Throwable $e no Throwable $e.
answered Dec 18, 2021 at 19:37
Eloquentfor your queries, you could usefirstOrFail()on aDB::raw()query. Or atry{ } catch (Illuminate\Database\QueryException $ex){ }try { $results = \DB::connection("example")->select(\DB::raw("SELECT * FROM unknown_table"))->first(); } catch(\Illuminate\Database\QueryException $ex){ die("Caught an error"); }Throws anddies"Caught an error". Did you have the \ before Illuminate? I just realized I forgot that in my first comment. Also, you$exwould extend the baseExceptionclass, so you can call$ex->getMessage()to return the exact error.