Laravel 7/6 Simple CRUD Application Example Tutorial

In this tutorial you will learn about the Laravel 7/6 Simple CRUD Application Example Tutorial and its application with practical example.

In this Laravel 7/6 Simple CRUD Application Example Tutorial I’ll show you how to create a simple crud application in laravel 7/6. In this example we will learn how to create a simple crud operation application in laravel 7/6. In this laravel 7/6 crud application we will be using jQuery and ajax to delete data from datatable crud app and MySQL database in laravel 7/6 app. In this article, you will learn how to create fully functional CRUD (Create, Read, Update and Delete) Application In laravel.

Table Of Contents−

Laravel 7/6 Simple CRUD Application Example Tutorial

Step 1: Install Laravel New Setup
Step 2: Setup Database Credentials

Step 3: Generate Model and Migration
Step 4: Add Routes for CRUD Operation
Step 5: Create Resource CRUD Controller

Step 6: Create the blade view
Step 7: Start Development Server

Step 1: Install Laravel New Setup

First of all we need to create a fresh laravel project, download and install Laravel using the below command

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

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

Step 2: Setup Database Credentials

Now, lets create a MySQL database and connect it with laravel application. After creating database we need to set database credential in application’s .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

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

Step 3: Generate Model and Migration

Now, in this step we will create model and migration file. Please run the following command:

php artisan make:model Product-m

1	php artisan make:model Product-m

The above command will create one model name Product and also create one migration file for Product table. Now, 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->increments('id'); 
            $table->string('title'); 
            $table->string('product_code'); 
            $table->text('description'); 
            $table->timestamps(); 
        }); 
    } 
   
    /** 
     * Reverse the migrations. 
     * 
     * @return void 
     */ 
    public function down() 
    { 
        Schema::dropIfExists('products'); 
    } 
}

<?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->increments('id');

$table->string('title');

$table->string('product_code');

$table->text('description');

$table->timestamps();

});

}

/**

* Reverse the migrations.

* @return void

public function down()

{

Schema::dropIfExists('products');

}

Now, in this step we will create model and migration file. Please run the following command:

php artisan migrate

1	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);
 }

use Illuminate\Support\Facades\Schema;

public function boot()

{

Schema::defaultStringLength(191);

}

And then run this below command :

 php artisan migrate:fresh

1	php artisan migrate:fresh

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

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

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Product extends Model

{

protected $fillable = [

'title',

'product_code',

'description',

];

}

Step 4: Add Routes For CRUD Operation

After this, we need to define routes in “routes/web.php” file. Lets open “routes/web.php” file and add the following routes in it.

routes/web.php

<?php 
 
 Route::get('/', function () {
     return view('welcome');
 });
  
Route::resource('products', 'ProductController');

<?php

Route::get('/', function () {

return view('welcome');

});

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

Step 5: Create Resource CRUD Controller

In this step we will create a resource controller using following artisan command:

php artisan make:controller ProductController  --resource

1	php artisan make:controller ProductController --resource

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

Next open controller, Go to app/HTTP/Controller/ProductController and update the below code into your controller file:

<?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');
}
}

<?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');

}

Step 6: Create the blade view

Create the product folder. After successfully create product folder , we will create following blade files for CRUD (Create, Retrieve, Update, Delete) operations.

Layout.blade.php
List.blade.php
Create.blade.php

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</title>
<link href="//maxcdn.bootstrapcdn.com/bootstrap/4.1.1/css/bootstrap.min.css" rel="stylesheet" id="bootstrap-css">
<style>
body{
background-color: #25274d;
}
.container{
background: #ff9b00;
padding: 4%;
border-top-left-radius: 0.5rem;
border-bottom-left-radius: 0.5rem;
}
</style>
</head>
<body>
<div class="container">
<br><br><br>
@yield('content')
</div>
</body>
</html>

<!DOCTYPE html>

<html>

<head>

<title>Laravel CRUD Tutorial With Example</title>

<style>

body{

background-color: #25274d;

}

.container{

background: #ff9b00;

padding: 4%;

border-top-left-radius: 0.5rem;

border-bottom-left-radius: 0.5rem;

}

</style>

</head>

<body>

@yield('content')

</div>

</body>

</html>

List.blade.php

@extends('product.layout')
@section('content')
<a href="{{ route('products.create') }}" class="btn btn-success mb-2">Add</a> 
<br>
<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>
<td colspan="2">Action</td>
</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><a href="{{ route('products.edit',$product->id)}}" class="btn btn-primary">Edit</a></td>
<td>
<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
</tbody>
</table>
{!! $products->links() !!}
</div> 
</div>
@endsection

@extends('product.layout')

@section('content')

<br>

<thead>

<tr>

<th>Title</th>

<th>Product Code</th>

<th>Description</th>

<th>Created at</th>

<td colspan="2">Action</td>

</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><a href="{{ route('products.edit',$product->id)}}" class="btn btn-primary">Edit</a></td>

<td>

<form action="{{ route('products.destroy', $product->id)}}" method="post">

@method('DELETE')

<button class="btn btn-danger" type="submit">Delete</button>

</form>

</td>

</tr>

@endforeach

</tbody>

</table>

{!! $products->links() !!}

</div>

@endsection

Create.blade.php

@extends('product.layout')
@section('content')
<h2 style="margin-top: 12px;" class="text-center">Add Product</a></h2>
<br>
<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>
</div>
</div>
</form>
@endsection

@extends('product.layout')

@section('content')

<h2 style="margin-top: 12px;" class="text-center">Add Product</a></h2>

<br>

<strong>Title</strong>

<span class="text-danger">{{ $errors->first('title') }}</span>

</div>

<strong>Product Code</strong>

<span class="text-danger">{{ $errors->first('product_code') }}</span>

</div>

<strong>Description</strong>

<span class="text-danger">{{ $errors->first('description') }}</span>

</div>

<button type="submit" class="btn btn-primary">Submit</button>

</div>

</form>

@endsection

Edit.blade.php

@extends('product.layout')
@section('content')
<h2 style="margin-top: 12px;" class="text-center">Edit Product</a></h2>
<br>
<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>
</div>
</div>
</form>
@endsection

@extends('product.layout')

@section('content')

<h2 style="margin-top: 12px;" class="text-center">Edit Product</a></h2>

<br>

<form action="{{ route('products.update', $product_info->id) }}" method="POST" name="update_product">

@method('PATCH')

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

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

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

<button type="submit" class="btn btn-primary">Submit</button>

</div>

</form>

@endsection

Step 7: Run Development Server

Now we are ready to run our example so lets start the development server using following artisan command –

php artisan serve

1	php artisan serve

Now, open the following URL in browser to see the output –

http://localhost:8000/products

1	http://localhost:8000/products

AngularJS

CodeIgniter

Laravel

Node Js

Wordpress

More Blog

Learn

ABOUT PAGES

Laravel 7/6 Simple CRUD Application Example Tutorial