Laravel crud – Build Your First CRUD App

Laravel CRUD – CRUD is the basic requirement of the any project. In this tutorial we will learn CRUD operation with server-side form validation. You will learn easy to insert update delete operation with laravel Applications from scratch.

We will create crud (create/read/update/delete) for product management. We will validate crud application forms with server-side validation. In this product crud management, we will use the resource controller and route.

Laravel Crud Tutorial

Contents

  • Install Laravel Fresh Project
  • Generate Model and Migration
  • Create Resource Route & Controller
  • Create the blade view
  • Start Development Server
  • Conclusion

Install Laravel Fresh Project

We need to install laravel 6 fresh application using below command, Open your command prompt and run the below command :

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

After successfully install laravel 6 Application, Go to your project root directory and find the .env file and setup database credential, If you don’t find the .env file then rename the .env.example file to .env

Configuration in .env

In this step, we will set database credential in .env file. Let’s open .env file.

 
DB_CONNECTION=mysql 
DB_HOST=127.0.0.1 
DB_PORT=3306 
DB_DATABASE=here your database name here
DB_USERNAME=here database username here
DB_PASSWORD=here database password here

 Generate Model and Migration

Now we will create table named Products and its migration file. use the below command:

php artisan make:model Product -m

This command will create a model named Products and also create one migration file for Product table. After successfully run the command go to database/migrations file and put the below here :

 
<?php 
  
use Illuminate\Support\Facades\Schema; 
use Illuminate\Database\Schema\Blueprint; 
use Illuminate\Database\Migrations\Migration; 
   
class CreateProductsTable extends Migration 
{ 
    /** 
     * Run the migrations. 
     * 
     * @return void 
     */ 
    public function up() 
    { 
        Schema::create('products', function (Blueprint $table) { 
            $table->bigIncrements('id'); 
            $table->string('title'); 
            $table->string('product_code'); 
            $table->text('description'); 
            $table->timestamps(); 
        }); 
    } 
   
    /** 
     * Reverse the migrations. 
     * 
     * @return void 
     */ 
    public function down() 
    { 
        Schema::dropIfExists('products'); 
    } 
} 

Next, migrate the table using the below command.

php artisan migrate

If you found any query builder error in command prompt go to  => app\Providers\AppServiceProvider.php and put the below code here :

 use Illuminate\Support\Facades\Schema;
 
public function boot()
{
    Schema::defaultStringLength(191);
}

And then run this below command :

 php artisan migrate:fresh

Now, add the fillable property inside Book.php file.

<?php
 namespace App;
 use Illuminate\Database\Eloquent\Model;
 class Product extends Model
 {
     protected $fillable = [
     'title',
     'product_code',
     'description'
    ];
 }

Create Resource Route & Controller

Create the ProductController using the below command.

php artisan make:controller ProductController  --resource

This command will create a contoller name ProductController and also inside by default seven methods like index, store, create, update, destroy, show, edit.

Next, We need to add the resource route. Go to routes/web.php put the below routes here :

<?php 

Route::get('/', function () {
return view('welcome');
});

Route::resource('products', 'ProductController');

Next open controller, Go to app/HTTP/Controller/ProductController and put the below code here :

<?php
  
namespace App\Http\Controllers;
  
use App\Product;
use Illuminate\Http\Request;
use Redirect;
use PDF;
  
class ProductController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        $data['products'] = Product::orderBy('id','desc')->paginate(10);
  
        return view('product.list',$data);
    }
   
    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        return view('product.create');
    }
  
    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
        $request->validate([
            'title' => 'required',
            'product_code' => 'required',
            'description' => 'required',
        ]);
  
        Product::create($request->all());
   
        return Redirect::to('products')
       ->with('success','Greate! Product created successfully.');
    }
   
    /**
     * Display the specified resource.
     *
     * @param  \App\Product  $product
     * @return \Illuminate\Http\Response
     */
    public function show(Request $request)
    {
        
    }
   
    /**
     * Show the form for editing the specified resource.
     *
     * @param  \App\Product  $product
     * @return \Illuminate\Http\Response
     */
    public function edit($id)
    {   
        $where = array('id' => $id);
        $data['product_info'] = Product::where($where)->first();

        return view('product.edit', $data);
    }
  
    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  \App\Product  $product
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, $id)
    {
        $request->validate([
            'title' => 'required',
            'product_code' => 'required',
            'description' => 'required',
        ]);
        
        $update = ['title' => $request->title, 'description' => $request->description];
        Product::where('id',$id)->update($update);
  
        return Redirect::to('products')
       ->with('success','Great! Product updated successfully');
    }
  
    /**
     * Remove the specified resource from storage.
     *
     * @param  \App\Product  $product
     * @return \Illuminate\Http\Response
     */
    public function destroy($id)
    {
        Product::where('id',$id)->delete();
  
        return Redirect::to('products')->with('success','Product deleted successfully');
    }
    
}

Create the blade view

Next, We need to create some blade view files, Go to app/resources/views/ and create one folder name product. Inside the product folder create the following blade files.

  1. Layout.blade.php
  2. List.blade.php
  3. Create.blade.php
  4. Edit.blade.php
Layout.blade.php
<!DOCTYPE html>
<html>
  <head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <meta name="csrf-token" content="{{ csrf_token() }}">
    <title>Laravel CRUD Tutorial With Example - w3path.com</title>
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.1.3/css/bootstrap.min.css" />
  </head>
  <body>
    <div class="container">
      @yield('content')
    </div>
  </body>
</html>
List.blade.php
@extends('product.layout')
  
@section('content')
 <div class="row">
  <div class="col-sm-6">
    <h4>Product List</h4>
  </div>
  <div class="col-sm-6 text-right">
    <a href="{{ route('products.create') }}" class="btn btn-success mb-2">Add</a> 
  </div>
</div>

 <div class="row">
      <div class="col-12">          
        <table class="table table-bordered" id="laravel_crud">
         <thead>
            <tr>
               <th>Id</th>
               <th>Title</th>
               <th>Product Code</th>
               <th>Description</th>
               <th>Created at</th>
               <th colspan="2" class="text-center">Action</th>
            </tr>
         </thead>
         <tbody>
            @foreach($products as $product)
            <tr>
               <td>{{ $product->id }}</td>
               <td>{{ $product->title }}</td>
               <td>{{ $product->product_code }}</td>
               <td>{{ $product->description }}</td>
               <td>{{ date('Y-m-d', strtotime($product->created_at)) }}</td>
               <td class="text-center">
                <a href="{{ route('products.edit',$product->id)}}" class="btn btn-primary">Edit</a></td>
               <td class="text-center">
               <form action="{{ route('products.destroy', $product->id)}}" method="post">
                {{ csrf_field() }}
                @method('DELETE')
                <button class="btn btn-danger" type="submit">Delete</button>
              </form>
              </td>
            </tr>
            @endforeach

            @if(count($products) < 1)
              <tr>
               <td colspan="10" class="text-center">There are no product available yet!</td>
              </td>
            </tr>
            @endif
         </tbody>
        </table>
        {!! $products->links() !!}
     </div> 
 </div>
 @endsection  
Create.blade.php
@extends('product.layout')

@section('content')
<div class="row">
    <div class="col-sm-6">
        <h4>Add Product</h4>
    </div>
    <div class="col-sm-6 text-right">
        <a href="{{ route('products.index') }}" class="btn btn-danger mb-2">Go Back</a> 
    </div>    
</div>
<hr />

<form action="{{ route('products.store') }}" method="POST" name="add_product">
    {{ csrf_field() }}
     
    <div class="row">
        <div class="col-md-12">
            <div class="form-group">
                <strong>Title</strong>
                <input type="text" name="title" class="form-control" placeholder="Enter Title">
                <span class="text-danger">{{ $errors->first('title') }}</span>
            </div>
        </div>
        <div class="col-md-12">
            <div class="form-group">
                <strong>Product Code</strong>
                <input type="text" name="product_code" class="form-control" placeholder="Enter Product Code">
                <span class="text-danger">{{ $errors->first('product_code') }}</span>
            </div>
        </div>
        <div class="col-md-12">
            <div class="form-group">
                <strong>Description</strong>
                <textarea class="form-control" col="4" name="description" placeholder="Enter Description"></textarea>
                <span class="text-danger">{{ $errors->first('description') }}</span>
            </div>
        </div>
        <div class="col-md-12">
            <button type="submit" class="btn btn-primary">Submit</button>
            <a href="{{ route('products.index') }}" class="btn btn-danger">Cancel</a> 
        </div>
    </div>     
</form>
@endsection
Edit.blade.php
@extends('product.layout')

@section('content')

<div class="row">
  <div class="col-sm-6">
    <h4>Edit Product</h4>
  </div>
  <div class="col-sm-6 text-right">
    <a href="{{ route('products.index') }}" class="btn btn-danger mb-2">Go Back</a> 
  </div>    
</div>
<hr />
 
<form action="{{ route('products.update', $product_info->id) }}" method="POST" name="update_product">
  {{ csrf_field() }}
  @method('PATCH')
   
  <div class="row">
      <div class="col-md-12">
          <div class="form-group">
              <strong>Title</strong>
              <input type="text" name="title" class="form-control" placeholder="Enter Title" value="{{ $product_info->title }}">
              <span class="text-danger">{{ $errors->first('title') }}</span>
          </div>
      </div>
      <div class="col-md-12">
          <div class="form-group">
              <strong>Product Code</strong>
              <input type="text" name="product_code" class="form-control" placeholder="Enter Product Code" value="{{ $product_info->product_code }}">
              <span class="text-danger">{{ $errors->first('product_code') }}</span>
          </div>
      </div>
      <div class="col-md-12">
          <div class="form-group">
              <strong>Description</strong>
              <textarea class="form-control" col="4" name="description" placeholder="Enter Description" >{{ $product_info->description }}</textarea>
              <span class="text-danger">{{ $errors->first('description') }}</span>
          </div>
      </div>
      <div class="col-md-12">
          <button type="submit" class="btn btn-primary">Submit</button>
          <a href="{{ route('products.index') }}" class="btn btn-danger">Cancel</a> 
      </div>
  </div>
   
</form>
@endsection

Start Development Server

In this step, we will use the PHP artisan serve command. It will start your server locally

php artisan serve

If you want to run the project diffrent port so use this below command

php artisan serve --port=8080

Now we are ready to run our example open the below URL in the browser.

http://localhost:8000/products

Conclusion

In this article, We have successfully created laravel 6 CRUD Application (Create, Read, Update, Delete) with example. Our examples run quickly.

If you have found this article useful, share this article with your friends and leave comment if you have any question or thoughts. Your responses are highly appreciated.

Be First to Comment

Leave a Reply

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