Laravel 5.5 CRUD (Create Read Update Delete) Example from scratch

Leave a Comment / php / By

Laravel 5.5 CRUD (Create Read Update Delete) Example from scratch

In this post we will give you information about Laravel 5.5 CRUD (Create Read Update Delete) Example from scratch. Hear we will give you detail about Laravel 5.5 CRUD (Create Read Update Delete) Example from scratchAnd how to use it also give you demo for it if it is necessary.

In this Laravel tutorial, You will learn the basic CRUD (Create Read Update Delete) functionality in Laravel 5.5.

Laravel is open-source web application framework with easy documentation.

If you are thinking to build an web application from scratch in Laravel then this example will help you out.

This example is basically designed for the beginners.

In this example, you will learn how to insert form data into a database, how can you modify the existing data, in short, you will learn the complete CRUD operation with the database.


Laravel 5.5 Installation

First, I need fresh Laravel 5.5 application to start from scratch.

Run the following command to install the upgraded version of Laravel :

composer create-project --prefer-dist laravel/laravel blog

With fresh Laravel 5.5 application, You will need to require Laravel Collective package for form builder : Laravel Collective.


Database Connection

To perform CRUD operation, You need to configure the MySQL database.

Once you have installed Laravel application then you should have .env file in the root directory which contains the various settings. So we will put database credentials in the .env file.


.env 

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=blog
DB_USERNAME=root
DB_PASSWORD=xxxx


Create Member Table, Model and Controller

We will work on member table to perform all CRUD operation.

Run following command to have migration file for member table.

php artisan make:migration create_members_table

After this artisan command, You must have new migration file like “2017_09_06_071236_create_members_table.php” in following path database/migrations.

  1. <?php
  3. use IlluminateSupportFacadesSchema;
  4. use IlluminateDatabaseSchemaBlueprint;
  5. use IlluminateDatabaseMigrationsMigration;
  7. class CreateMembersTable extends Migration
  8. {
  9. /**
  10.      * Run the migrations.
  11.      *
  12.      * @return void
  13.      */
  14.     public functionup()
  15. {
  16.         Schema::create('members',function(Blueprint $table){
  17. $table->increments('id');
  18. $table->string('name');
  19. $table->string('email');
  20. $table->timestamps();
  21. });
  22. }
  24. /**
  25.      * Reverse the migrations.
  26.      *
  27.      * @return void
  28.      */
  29.     public functiondown()
  30. {
  31.         Schema::dropIfExists('members');
  32. }
  33. }
<?php

use IlluminateSupportFacadesSchema;
use IlluminateDatabaseSchemaBlueprint;
use IlluminateDatabaseMigrationsMigration;

class CreateMembersTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('members', function (Blueprint $table) {
            $table->increments('id');
            $table->string('name');
            $table->string('email');
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('members');
    }
}

Save the migration file with above code and run following command :

php artisan migrate

Now you have members table with id, name, email and timestamps fields.

Ok let’s create the model and controller in single command :

php artisan make:model Member -c

After above command, you will get the Member model and MemberController.



app/Member.php

  1. <?php
  3. namespace App;
  5. use IlluminateDatabaseEloquentModel;
  7. class Member extends Model
  8. {
  9.     protected $fillable=[
  10. 'name','email'
  11. ];
  12. }
<?php

namespace App;

use IlluminateDatabaseEloquentModel;

class Member extends Model
{
    protected $fillable = [
        'name', 'email'
    ];
}


Resource Route

Laravel provides single resource route instead of creating different different routes for each operation.


routes/web.php 

Route::resource('members','MemberController');


MemberController

You will notice that there will be some default method available with Member Controller after running artisan command.


app/Http/Controllers/MemberController.php

Put following code in Member Controller.

  1. <?php
  3. namespace AppHttpControllers;
  5. use IlluminateHttpRequest;
  6. use AppMember;
  8. class MemberController extends Controller
  9. {
  10.     public functionindex()
  11. {
  12. $members= Member::latest()->paginate(10);
  13. returnview('members.index',compact('members'))
  14. ->with('i',(request()->input('page',1)-1)*5);
  15. }
  17. /**
  18.      * Show the form for creating a new resource.
  19.      *
  20.      * @return IlluminateHttpResponse
  21.      */
  22.     public functioncreate()
  23. {
  24. returnview('members.create');
  25. }
  27. /**
  28.      * Store a newly created resource in storage.
  29.      *
  30.      * @param  IlluminateHttpRequest  $request
  31.      * @return IlluminateHttpResponse
  32.      */
  33.     public functionstore(Request $request)
  34. {
  35. request()->validate([
  36. 'name'=>'required',
  37. 'email'=>'required',
  38. ]);
  39.         Member::create($request->all());
  40. returnredirect()->route('members.index')
  41. ->with('success','Member created successfully');
  42. }
  44. /**
  45.      * Display the specified resource.
  46.      *
  47.      * @param  int  $id
  48.      * @return IlluminateHttpResponse
  49.      */
  50.     public functionshow(Member $member)
  51. {
  52. returnview('members.show',compact('member'));
  53. }
  55. /**
  56.      * Show the form for editing the specified resource.
  57.      *
  58.      * @param  int  $id
  59.      * @return IlluminateHttpResponse
  60.      */
  61.     public functionedit(Member $member)
  62. {
  63. returnview('members.edit',compact('member'));
  64. }
  66. /**
  67.      * Update the specified resource in storage.
  68.      *
  69.      * @param  IlluminateHttpRequest  $request
  70.      * @param  int  $id
  71.      * @return IlluminateHttpResponse
  72.      */
  73.     public functionupdate(Request $request,Member $member)
  74. {
  75. request()->validate([
  76. 'name'=>'required',
  77. 'email'=>'required',
  78. ]);
  79. $member->update($request->all());
  80. returnredirect()->route('members.index')
  81. ->with('success','Member updated successfully');
  82. }
  84. /**
  85.      * Remove the specified resource from storage.
  86.      *
  87.      * @param  int  $id
  88.      * @return IlluminateHttpResponse
  89.      */
  90.     public functiondestroy($id)
  91. {
  92.         Member::destroy($id);
  93. returnredirect()->route('members.index')
  94. ->with('success','Member deleted successfully');
  95. }
  96. }
<?php

namespace AppHttpControllers;

use IlluminateHttpRequest;
use AppMember;

class MemberController extends Controller
{
    public function index()
    {
        $members = Member::latest()->paginate(10);
        return view('members.index',compact('members'))
            ->with('i', (request()->input('page', 1) - 1) * 5);
    }

    /**
     * Show the form for creating a new resource.
     *
     * @return IlluminateHttpResponse
     */
    public function create()
    {
        return view('members.create');
    }

    /**
     * Store a newly created resource in storage.
     *
     * @param  IlluminateHttpRequest  $request
     * @return IlluminateHttpResponse
     */
    public function store(Request $request)
    {
        request()->validate([
            'name' => 'required',
            'email' => 'required',
        ]);
        Member::create($request->all());
        return redirect()->route('members.index')
                        ->with('success','Member created successfully');
    }

    /**
     * Display the specified resource.
     *
     * @param  int  $id
     * @return IlluminateHttpResponse
     */
    public function show(Member $member)
    {
        return view('members.show',compact('member'));
    }

    /**
     * Show the form for editing the specified resource.
     *
     * @param  int  $id
     * @return IlluminateHttpResponse
     */
    public function edit(Member $member)
    {
        return view('members.edit',compact('member'));
    }

    /**
     * Update the specified resource in storage.
     *
     * @param  IlluminateHttpRequest  $request
     * @param  int  $id
     * @return IlluminateHttpResponse
     */
    public function update(Request $request,Member $member)
    {
        request()->validate([
            'name' => 'required',
            'email' => 'required',
        ]);
        $member->update($request->all());
        return redirect()->route('members.index')
                        ->with('success','Member updated successfully');
    }

    /**
     * Remove the specified resource from storage.
     *
     * @param  int  $id
     * @return IlluminateHttpResponse
     */
    public function destroy($id)
    {
        Member::destroy($id);
        return redirect()->route('members.index')
                        ->with('success','Member deleted successfully');
    }
}


Blade View Files

In this step, I will create some view files to add members, list members, edit members with master layouts.

  • default.blade.php

  • index.blade.php

  • form.blade.php

  • create.blade.php

  • edit.blade.php

  • show.blade.php

resources/views/layouts/default.blade.php

  1. <!DOCTYPEhtml>
  2. <htmllang="en">
  3. <head>
  4. <metacharset="utf-8">
  5. <metahttp-equiv="X-UA-Compatible"content="IE=edge">
  6. <metaname="viewport"content="width=device-width, initial-scale=1">
  7. <title>Laravel 5.5 CRUD example</title>
  8. <linkhref="{{asset('css/app.css')}}"rel="stylesheet">
  9. </head>
  10. <body>
  12. <divclass="container">
  13.     @yield('content')
  14. </div>
  16. </body>
  17. </html>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <title>Laravel 5.5 CRUD example</title>
    <link href="{{asset('css/app.css')}}" rel="stylesheet">
</head>
<body>
 
<div >
    @yield('content')
</div>
 
</body>
</html>


resources/views/members/index.blade.php

  1. @extends('layouts.default')
  2. @section('content')
  3. <divclass="row">
  4. <divclass="col-lg-12 margin-tb">
  5. <divclass="pull-left">
  6. <h2>Members CRUD</h2>
  7. </div>
  8. <divclass="pull-right">
  9. <aclass="btn btn-success"href="{{ route('members.create') }}"> Create New Member</a>
  10. </div>
  11. </div>
  12. </div>
  13.     @if ($message = Session::get('success'))
  14. <divclass="alert alert-success">
  15. <p>{{ $message }}</p>
  16. </div>
  17.     @endif
  18. <tableclass="table table-bordered">
  19. <tr>
  20. <th>No</th>
  21. <th>Name</th>
  22. <th>Email</th>
  23. <thwidth="280px">Operation</th>
  24. </tr>
  25.     @foreach ($members as $member)
  26. <tr>
  27. <td>{{ ++$i }}</td>
  28. <td>{{ $member->name}}</td>
  29. <td>{{ $member->email}}</td>
  30. <td>
  31. <aclass="btn btn-info"href="{{ route('members.show',$member->id) }}">Show</a>
  32. <aclass="btn btn-primary"href="{{ route('members.edit',$member->id) }}">Edit</a>
  33.             {!! Form::open(['method' => 'DELETE','route' => ['members.destroy', $member->id],'style'=>'display:inline']) !!}
  34.             {!! Form::submit('Delete', ['class' => 'btn btn-danger']) !!}
  35.             {!! Form::close() !!}
  36. </td>
  37. </tr>
  38.     @endforeach
  39. </table>
  40.     {!! $members->render() !!}
  41. @endsection
@extends('layouts.default')
@section('content')
    <div >
        <div >
            <div >
                <h2>Members CRUD</h2>
            </div>
            <div >
                <a  href="{{ route('members.create') }}"> Create New Member</a>
            </div>
        </div>
    </div>
    @if ($message = Session::get('success'))
        <div >
            <p>{{ $message }}</p>
        </div>
    @endif
    <table >
        <tr>
            <th>No</th>
            <th>Name</th>
            <th>Email</th>
            <th width="280px">Operation</th>
        </tr>
    @foreach ($members as $member)
    <tr>
        <td>{{ ++$i }}</td>
        <td>{{ $member->name}}</td>
        <td>{{ $member->email}}</td>
        <td>
            <a  href="{{ route('members.show',$member->id) }}">Show</a>
            <a  href="{{ route('members.edit',$member->id) }}">Edit</a>
            {!! Form::open(['method' => 'DELETE','route' => ['members.destroy', $member->id],'style'=>'display:inline']) !!}
            {!! Form::submit('Delete', ['class' => 'btn btn-danger']) !!}
            {!! Form::close() !!}
        </td>
    </tr>
    @endforeach
    </table>
    {!! $members->render() !!}
@endsection



resources/views/members/show.blade.php

  1. @extends('layouts.default')
  3. @section('content')
  4. <divclass="row">
  5. <divclass="col-lg-12 margin-tb">
  6. <divclass="pull-left">
  7. <h2> Show Member</h2>
  8. </div>
  9. <divclass="pull-right">
  10. <aclass="btn btn-primary"href="{{ route('members.index') }}"> Back</a>
  11. </div>
  12. </div>
  13. </div>
  14. <divclass="row">
  15. <divclass="col-xs-12 col-sm-12 col-md-12">
  16. <divclass="form-group">
  17. <strong>Name:</strong>
  18.                 {{ $member->name}}
  19. </div>
  20. </div>
  21. <divclass="col-xs-12 col-sm-12 col-md-12">
  22. <divclass="form-group">
  23. <strong>Email:</strong>
  24.                 {{ $member->email}}
  25. </div>
  26. </div>
  27. </div>
  28. @endsection
@extends('layouts.default')
 
@section('content')
    <div >
        <div >
            <div >
                <h2> Show Member</h2>
            </div>
            <div >
                <a  href="{{ route('members.index') }}"> Back</a>
            </div>
        </div>
    </div>
    <div >
        <div >
            <div >
                <strong>Name:</strong>
                {{ $member->name}}
            </div>
        </div>
        <div >
            <div >
                <strong>Email:</strong>
                {{ $member->email}}
            </div>
        </div>
    </div>
@endsection


resources/views/members/form.blade.php

  1. <divclass="row">
  2. <divclass="col-xs-12 col-sm-12 col-md-12">
  3. <divclass="form-group">
  4. <strong>Name:</strong>
  5.             {!! Form::text('name', null, array('placeholder' => 'Name','class' => 'form-control')) !!}
  6. </div>
  7. </div>
  8. <divclass="col-xs-12 col-sm-12 col-md-12">
  9. <divclass="form-group">
  10. <strong>Email:</strong>
  11.             {!! Form::email('email', null, array('placeholder' => 'Email','class' => 'form-control')) !!}
  12. </div>
  13. </div>
  14. <divclass="col-xs-12 col-sm-12 col-md-12 text-center">
  15. <buttontype="submit"class="btn btn-primary">Submit</button>
  16. </div>
  17. </div>
<div >
    <div >
        <div >
            <strong>Name:</strong>
            {!! Form::text('name', null, array('placeholder' => 'Name','class' => 'form-control')) !!}
        </div>
    </div>
    <div >
        <div >
            <strong>Email:</strong>
            {!! Form::email('email', null, array('placeholder' => 'Email','class' => 'form-control')) !!}
        </div>
    </div>
    <div >
            <button type="submit" >Submit</button>
    </div>
</div>


resources/views/members/create.blade.php

  1. @extends('layouts.default')
  2. @section('content')
  3. <divclass="row">
  4. <divclass="col-lg-12 margin-tb">
  5. <divclass="pull-left">
  6. <h2>Add New Member</h2>
  7. </div>
  8. <divclass="pull-right">
  9. <aclass="btn btn-primary"href="{{ route('members.index') }}"> Back</a>
  10. </div>
  11. </div>
  12. </div>
  13.     @if (count($errors) > 0)
  14. <divclass="alert alert-danger">
  15. <strong>Whoops!</strong> There were some problems with your input.<br><br>
  16. <ul>
  17.                 @foreach ($errors->all() as $error)
  18. <li>{{ $error }}</li>
  19.                 @endforeach
  20. </ul>
  21. </div>
  22.     @endif
  23.     {!! Form::open(array('route' => 'members.store','method'=>'POST')) !!}
  24.          @include('members.form')
  25.     {!! Form::close() !!}
  26. @endsection
@extends('layouts.default')
@section('content')
    <div >
        <div >
            <div >
                <h2>Add New Member</h2>
            </div>
            <div >
                <a  href="{{ route('members.index') }}"> Back</a>
            </div>
        </div>
    </div>
    @if (count($errors) > 0)
        <div >
            <strong>Whoops!</strong> There were some problems with your input.<br><br>
            <ul>
                @foreach ($errors->all() as $error)
                    <li>{{ $error }}</li>
                @endforeach
            </ul>
        </div>
    @endif
    {!! Form::open(array('route' => 'members.store','method'=>'POST')) !!}
         @include('members.form')
    {!! Form::close() !!}
@endsection


resources/views/members/edit.blade.php

  1. @extends('layouts.default')
  3. @section('content')
  4. <divclass="row">
  5. <divclass="col-lg-12 margin-tb">
  6. <divclass="pull-left">
  7. <h2>Edit Member</h2>
  8. </div>
  9. <divclass="pull-right">
  10. <aclass="btn btn-primary"href="{{ route('members.index') }}"> Back</a>
  11. </div>
  12. </div>
  13. </div>
  14.     @if (count($errors) > 0)
  15. <divclass="alert alert-danger">
  16. <strong>Whoops!</strong> There were some problems with your input.<br><br>
  17. <ul>
  18.                 @foreach ($errors->all() as $error)
  19. <li>{{ $error }}</li>
  20.                 @endforeach
  21. </ul>
  22. </div>
  23.     @endif
  24.     {!! Form::model($member, ['method' => 'PATCH','route' => ['members.update', $member->id]]) !!}
  25.         @include('members.form')
  26.     {!! Form::close() !!}
  27. @endsection
@extends('layouts.default')
 
@section('content')
    <div >
        <div >
            <div >
                <h2>Edit Member</h2>
            </div>
            <div >
                <a  href="{{ route('members.index') }}"> Back</a>
            </div>
        </div>
    </div>
    @if (count($errors) > 0)
        <div >
            <strong>Whoops!</strong> There were some problems with your input.<br><br>
            <ul>
                @foreach ($errors->all() as $error)
                    <li>{{ $error }}</li>
                @endforeach
            </ul>
        </div>
    @endif
    {!! Form::model($member, ['method' => 'PATCH','route' => ['members.update', $member->id]]) !!}
        @include('members.form')
    {!! Form::close() !!}
@endsection

Now you can perform the crud application after following above steps.

  • Laravel 5.2 CRUD (Create Read Update Delete) Example

  • Laravel 5 Ajax CRUD example



Show Demo
Source Code

Hope this code and post will helped you for implement Laravel 5.5 CRUD (Create Read Update Delete) Example from scratch. if you need any help or any feedback give it in comment section or you have good idea about this post you can give it comment section. Your comment will help us for help you more and improve us. we will give you this type of more interesting post in featured also so, For more interesting post and code Keep reading our blogs

For More Info See :: laravel And github

Leave a Comment

Your email address will not be published. Required fields are marked *

5  +  5  =  

We're accepting well-written guest posts and this is a great opportunity to collaborate : Contact US