Laravel 5.2 CRUD (Create Read Update Delete) Example from Scratch

Leave a Comment / php / By

Laravel 5.2 CRUD (Create Read Update Delete) Example from Scratch

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

Laravel 5.2 CRUD (Create Read Update Delete) Example from Scratch

I am going to explain how to create a single module with Laravel CRUD (Create, Read, Update, Delete) application.Kindly follow each step to create a simple CRUD application.I assure you, if you follow these steps properly then you won’t get any error.In this CRUD application, you can add new product, edit those products, view product details and delete product.

Before going to start, kindly let you know following things :

  • Know about PHP OOP Concept, Click here to know Basic concept of Object Oriented Programming
  • What is resource route ?
  • How to validating request data ?

Step 1: Install Laravel 5.2

If Laravel is not installed in your system then first install with following command and get fresh Laravel project.

composer create-project --prefer-dist laravel/laravel blog "5.2.*"

When you run above command then it create application with name blog in your system.From Laravel 5, you have to install laravelcollective/html for Form class.To know the installation process of laravelcollective/html, kindly go through this url HTML/FORM not found in Laravel 5?.

Step 2: Create products table and model

Follow the simple step to create products table in your database.First create migration for products table using Laravel 5 php artisan command,so first run this command –

php artisan make:migration create_products_table

After this command, you will see a migration file in following path database/migrations and you have to simply put following code in migration file to create products table.

  1. use IlluminateDatabaseSchemaBlueprint;
  2. use IlluminateDatabaseMigrationsMigration;
  4. class CreateProductsTable extends Migration
  5. {
  6.     public functionup()
  7. {
  8.         Schema::create('products',function(Blueprint $table){
  9. $table->increments('id');
  10. $table->string('name');
  11. $table->text('details');
  12. $table->timestamps();
  13. });
  14. }
  15.     public functiondown()
  16. {
  17.         Schema::drop("products");
  18. }
  20. }
use IlluminateDatabaseSchemaBlueprint;use IlluminateDatabaseMigrationsMigration;class CreateProductsTable extends Migration{    public function up()    {        Schema::create('products', function (Blueprint $table) {            $table->increments('id');            $table->string('name');            $table->text('details');            $table->timestamps();        });    }    public function down()    {        Schema::drop("products");    }}

Save this migration file and run following command

php artisan migrate

After create ‘products’ table, yor should create model for product table.Create file in following path app/Product.php and put bellow couple of code in Product.php file:

app/Product.php

  1. namespace App;
  2. use IlluminateDatabaseEloquentModel;
  4. class Product extends Model
  5. {
  6.     public $fillable=['name','details'];
  7. }
namespace App;use IlluminateDatabaseEloquentModel;class Product extends Model{    public $fillable = ['name','details'];}

Step 3: Add Route and Controller

To handling request, you need to create route for products CRUD, so just add resource route in your routes file.I added resource route because it will add index, show, create, show and delete routes automatically.So put bellow line of code in your route file.

app/Http/routes.php

  1. Route::resource('productCRUD','ProductCRUDController');
Route::resource('productCRUD','ProductCRUDController');

Now we will create ProductCRUDController in following path app/Http/Controllers, all routes will manage by this ProductCRUDController.php file.

app/Http/Controllers/ProductCRUDController.php

  1. namespace AppHttpControllers;
  3. use IlluminateHttpRequest;
  4. use AppHttpControllersController;
  5. use AppProduct;
  7. class ProductCRUDController extends Controller
  8. {
  10. /**
  11.      * Display a listing of the resource.
  12.      *
  13.      * @return IlluminateHttpResponse
  14.      */
  15.     public functionindex(Request $request)
  16. {
  17. $products= Product::orderBy('id','DESC')->paginate(5);
  18. returnview('ProductCRUD.index',compact('products'))
  19. ->with('i',($request->input('page',1)-1)*5);
  20. }
  22. /**
  23.      * Show the form for creating a new resource.
  24.      *
  25.      * @return IlluminateHttpResponse
  26.      */
  27.     public functioncreate()
  28. {
  29. returnview('ProductCRUD.create');
  30. }
  32. /**
  33.      * Store a newly created resource in storage.
  34.      *
  35.      * @param  IlluminateHttpRequest  $request
  36.      * @return IlluminateHttpResponse
  37.      */
  38.     public functionstore(Request $request)
  39. {
  40. $this->validate($request,[
  41. 'name'=>'required',
  42. 'details'=>'required',
  43. ]);
  45.         Product::create($request->all());
  46. returnredirect()->route('productCRUD.index')
  47. ->with('success','Product created successfully');
  48. }
  50. /**
  51.      * Display the specified resource.
  52.      *
  53.      * @param  int  $id
  54.      * @return IlluminateHttpResponse
  55.      */
  56.     public functionshow($id)
  57. {
  58. $product= Product::find($id);
  59. returnview('ProductCRUD.show',compact('product'));
  60. }
  62. /**
  63.      * Show the form for editing the specified resource.
  64.      *
  65.      * @param  int  $id
  66.      * @return IlluminateHttpResponse
  67.      */
  68.     public functionedit($id)
  69. {
  70. $product= Product::find($id);
  71. returnview('ProductCRUD.edit',compact('product'));
  72. }
  74. /**
  75.      * Update the specified resource in storage.
  76.      *
  77.      * @param  IlluminateHttpRequest  $request
  78.      * @param  int  $id
  79.      * @return IlluminateHttpResponse
  80.      */
  81.     public functionupdate(Request $request,$id)
  82. {
  83. $this->validate($request,[
  84. 'name'=>'required',
  85. 'details'=>'required',
  86. ]);
  88.         Product::find($id)->update($request->all());
  89. returnredirect()->route('productCRUD.index')
  90. ->with('success','Product updated successfully');
  91. }
  93. /**
  94.      * Remove the specified resource from storage.
  95.      *
  96.      * @param  int  $id
  97.      * @return IlluminateHttpResponse
  98.      */
  99.     public functiondestroy($id)
  100. {
  101.         Product::find($id)->delete();
  102. returnredirect()->route('productCRUD.index')
  103. ->with('success','Product deleted successfully');
  104. }
  105. }
namespace AppHttpControllers;use IlluminateHttpRequest;use AppHttpControllersController;use AppProduct;class ProductCRUDController extends Controller{    /**     * Display a listing of the resource.     *     * @return IlluminateHttpResponse     */    public function index(Request $request)    {        $products= Product::orderBy('id','DESC')->paginate(5);        return view('ProductCRUD.index',compact('products'))            ->with('i', ($request->input('page', 1) - 1) * 5);    }    /**     * Show the form for creating a new resource.     *     * @return IlluminateHttpResponse     */    public function create()    {        return view('ProductCRUD.create');    }    /**     * Store a newly created resource in storage.     *     * @param  IlluminateHttpRequest  $request     * @return IlluminateHttpResponse     */    public function store(Request $request)    {        $this->validate($request, [            'name' => 'required',            'details' => 'required',        ]);        Product::create($request->all());        return redirect()->route('productCRUD.index')                        ->with('success','Product created successfully');    }    /**     * Display the specified resource.     *     * @param  int  $id     * @return IlluminateHttpResponse     */    public function show($id)    {        $product= Product::find($id);        return view('ProductCRUD.show',compact('product'));    }    /**     * Show the form for editing the specified resource.     *     * @param  int  $id     * @return IlluminateHttpResponse     */    public function edit($id)    {        $product= Product::find($id);        return view('ProductCRUD.edit',compact('product'));    }    /**     * Update the specified resource in storage.     *     * @param  IlluminateHttpRequest  $request     * @param  int  $id     * @return IlluminateHttpResponse     */    public function update(Request $request, $id)    {        $this->validate($request, [            'name' => 'required',            'details' => 'required',        ]);        Product::find($id)->update($request->all());        return redirect()->route('productCRUD.index')                        ->with('success','Product updated successfully');    }    /**     * Remove the specified resource from storage.     *     * @param  int  $id     * @return IlluminateHttpResponse     */    public function destroy($id)    {        Product::find($id)->delete();        return redirect()->route('productCRUD.index')                        ->with('success','Product deleted successfully');    }}

Step 4: Create Blade File

Now we will create blade file for listing, create, edit, show, form, default (which is master template).According to standard structure of Laravel, we create new layouts folder/directory in following path resources/views and create default.blade.php within that folderresources/views/layouts/.

resources/views/layouts/default.blade.php

  1. <!DOCTYPE html>
  2. <html lang="en">
  3. <head>
  4. <meta charset="utf-8">
  5. <meta http-equiv="X-UA-Compatible" content="IE=edge">
  6. <meta name="viewport" content="width=device-width, initial-scale=1">
  8. <title>Laravel CRUD</title>
  9. <link href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.0.0-alpha/css/bootstrap.css" rel="stylesheet">
  11. </head>
  12. <body>
  14. <div class="container">
  15. @yield('content')
  16. </div>
  18. </body>
  19. </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 CRUD</title>    <link href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.0.0-alpha/css/bootstrap.css" rel="stylesheet"></head><body> <div >    @yield('content')</div> </body></html>

Now we will create layout for product listing, for this we will create seperate directory name ProductCRUD which contain files related products functionality and create index.blade.php file within resources/views/ProductCRUD/.

resources/views/ProductCRUD/index.blade.php

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

Now we create new blade file to add new product within ProductCRUD folder

resources/views/ProductCRUD/create.blade.php

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

Now we create new blade file to edit product within ProductCRUD folder

resources/views/ProductCRUD/edit.blade.php

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

Now we create a new blade file form.blade.php within ProductCRUD folder

resources/views/ProductCRUD/form.blade.php

  1. <divclass="row">
  3. <divclass="col-xs-12 col-sm-12 col-md-12">
  4. <divclass="form-group">
  5. <strong>Name:</strong>
  6.                 {!! Form::text('name', null, array('placeholder' => 'Name','class' => 'form-control')) !!}
  7. </div>
  8. </div>
  10. <divclass="col-xs-12 col-sm-12 col-md-12">
  11. <divclass="form-group">
  12. <strong>Details:</strong>
  13.                 {!! Form::textarea('details', null, array('placeholder' => 'Details','class' => 'form-control','style'=>'height:100px')) !!}
  14. </div>
  15. </div>
  17. <divclass="col-xs-12 col-sm-12 col-md-12 text-center">
  18. <buttontype="submit"class="btn btn-primary">Submit</button>
  19. </div>
  21. </div>
<div >        <div >            <div >                <strong>Name:</strong>                {!! Form::text('name', null, array('placeholder' => 'Name','class' => 'form-control')) !!}            </div>        </div>        <div >            <div >                <strong>Details:</strong>                {!! Form::textarea('details', null, array('placeholder' => 'Details','class' => 'form-control','style'=>'height:100px')) !!}            </div>        </div>        <div >                <button type="submit" >Submit</button>        </div>    </div>

At Last we create a blade file to show the product details

resources/views/ProductCRUD/show.blade.php

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

Now you can build your first CRUD Application..

Show Demo

Label :

PHP

Laravel PHP Framework

MVC

Web Development

Hope this code and post will helped you for implement Laravel 5.2 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 *

86  +    =  94

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