Today, We want to share with you Laravel Exception Handling Example Tutorial For Beginners From Scratch.In this post we will show you Laravel MySQL query Exception Handling, hear for laravel catch exception in controller we will give you demo and example for implement.In this post, we will learn about Laravel Exceptions: How to Catch, Handle and Create Your Own with an example.

Laravel Exception Handling Example Tutorial For Beginners From Scratch

There are the Following The simple About Laravel Exception Handling Example Tutorial For Beginners From Scratch Full Information With Example and source code.

As I will cover this Post with live Working example to develop Exception Handling in Laravel, so the some major Laravel Exceptions for this example is following below.

• MySQL query Exception Handling in Laravel
• How to Laravel catch QueryException?
• LARAVEL 5 EXCEPTION HANDLING Example
• Debugging Queries in Laravel
• ModelNotFoundException Exception handling
• Laravel 404 Page Exceptions Handlers

Example 1 : MySQL query Exception Handling in Laravel

Handling sql based exceptions

try {
  $results = \DB::connection("atmiya25")
    ->select(\DB::raw("SELECT * FROM members"))
    ->first();
    // Closures include ->first() or ->get() or ->pluck(), etc.
} catch(\Illuminate\Database\QueryException $ex){
  dd($ex->getMessage());
  // Note any laravel controller method of class like PDOException can be called simple message on $ex.
}

Example 2 : How to Laravel catch QueryException?

Laravel MySQL query Exception Handling

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

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

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

Example 3 : LARAVEL 5 EXCEPTION HANDLING Example

public function saveCreate()
    {
        $input = Input::all();
        try
        {
            $membersite = new MemberSite;
            $membersite->siteName = $input['siteName'];
            $membersite->description = $input['description'];
            $membersite->launchDate = $input['launchDate'];
            $membersite->save();


            MemberSite::where('siteName', $membersite->siteName)->first();
            $memberID = $membersite['memberID'];//getting memberID for use in join query

            $memberFeatures = DB::table('features')->join('memberFeatures', function ($join) use ($memberID)
            {
                $join->on('memberFeatures.featureID', '=', 'features.featureID')
                    ->where('memberFeatures.memberID', '=', $memberID);
            })->get();
            $groupIDs = [];
            foreach ($memberFeatures as $m)
                $groupIDs[] = $m->groupID;

            return View::make('profiles.memberProfiles')->with('membersite', $membersite)
                ->with('groupIDs', $groupIDs)
                ->with('memberFeatures', $memberFeatures);
        }
        catch (\Illuminate\Database\QueryException $e)
        {
            return View::make('edit.create')
                ->with('status', ' Sorry, Your Website : ' . $siteName . ' Site already exist!');
        }
    }

Example 4 : Debugging Queries in Laravel

Example of the Simple Mysql Query Debugging in Laravel

$results = Member::where(function($q) use ($request) {
    $q->orWhere('member_email', 'like', '%[email protected]%');
    $q->orWhere('member_first_name', 'like', '%jaydeep%');
    $q->orWhere('member_last_name', 'like', '%Gondaliya%');
})->get();

Query exception Debugging

$results = Member::where(function($q) use ($request) {
    $q->orWhere('member_email', 'like', '%[email protected]%');
    $q->orWhere('member_first_name', 'like', '%jaydeep%');
    $q->orWhere('member_last_name', 'like', '%Gondaliya%');
})->toSql();
dd($results)

Listening For Mysql Query Events

\DB::listen(function($sql, $bindings, $time) {
    var_dump($sql);
    var_dump($bindings);
    var_dump($time);
});

Example 5 : ModelNotFoundException Exception handling

ModelNotFoundException

//ModelNotFoundException in Laravel
public function search(Request $request)
{
    try {
        $member = Member::findOrFail($request->input('member_id'));
    } catch (ModelNotFoundException $exception) {
        return back()->withError($exception->getMessage())->withInput();
    }
    return view('members.search', compact('member'));
}

Display an error in Blade view files

Search for members by ID

@if (session('error'))
    
{{ session('error') }}
@endif

Example 6 : Laravel 404 Page Exceptions Handlers

Creating A Laravel 404 Page Using Custom Exception Handlers

app/Exception/Handler.php

public function render($request, Exception $e)
{
// Laravel NotFoundHttpException
    if($e instanceof NotFoundHttpException)
    {
          return response()->view('errors.missing', [], 404);
    }
    return parent::render($request, $e);
}

Include On the Top first

use Symfony\Component\HttpKernel\Exception\NotFoundHttpException;

resources/views/errors/404.blade.php

Laravel Create a 404 Page Not Found HTTP Error Exception Handler

    


404

You broke the balance of the internet
The page you are showing for was moved or deleted, removed, renamed
or might never you existed. You stumbled upon a any routers broken link 🙁

Angular 6 CRUD Operations Application Tutorials

Read :

• Technology
• Google Adsense
• Programming

Summary

You can also read about AngularJS, ASP.NET, VueJs, PHP.

I hope you get an idea about Laravel Exception Handling Example Tutorial For Beginners From Scratch.
I would like to have feedback on my Pakainfo.com blog.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, don’t forget to share.