laravel catch queryexception code example

Example 1: laravel handle queryexception

try {
  $this->model->create($data);

} catch (Illuminate\Database\QueryException $e) {
  dd($e);

} catch (PDOException $e) {
  dd($e);
}

Example 2: how to catch query exception in laravel 8

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.
}

Tags:

Php Example