How to catch SQL Exception in Laravel 5

Try this

try {  //Your code} catch(\Illuminate\Database\QueryException $ex){   dd($ex->getMessage()); }

use Illuminate\Database\QueryException; try {      //Your code    } catch(QueryException $ex){       dd($ex->getMessage());     }

php sql laravel laravel-5

My case: add \ before Exception class otherwise it not handle

try{//write your codes here}catch(\Exception $e) {            Log::error($e->getMessage());        }

php sql laravel laravel-5

Make sure to use the Exception library in your controller. From there you can do:

try{    Some queries . . .}catch(Exception $e){    return response()->json([      'error' => 'Cannot excecute query',    ],422);}

CodeHunter