Laravel 6 crud Insert Update Delete operations Example

Technology, Laravel, php, Programming Leave a comment

Today, We want to share with you Laravel 6 crud Insert Update Delete operations Example and demo.In this post we will show you wordpress plugin require another plugin, hear for CRUD (Create Read Update Delete) in a Laravel 6 App we will give you demo and example for implement.In this post, we will learn about Laravel 6 CRUD (Create Read Update Delete) Tutorial For Beginners with an example.

Laravel 6 crud Insert Update Delete operations Example and demo

There are the Following The simple About Insert Update and Delete records from MySQL with Laravel 6 Full Information With Example and source code.

As I will cover this Post with live Working example to develop How to create CRUD operations (Insert,Update and Delete) in Laravel 6, so the Laravel 6 get data from mysql is used for this example is following below.

Phase 1 : Install Laravel 6

run simple bellow command To fresh Install Laravel 6

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

Phase 2: Laravel 6 Database Configuration

changes some config in .env file

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=memberfamilyinfo
DB_USERNAME=memberfamilyinfo
[email protected]@#$%$*&

Phase 3: Laravel Define a Migration

make a Laravel 6 crud application for member

php artisan make:migration create_members_table --create=members


<?php
 
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
  
class CreateMembersTable extends Migration
{
    public function up()
    {
        Schema::create('members', function (Blueprint $table) {
            $table->increments('id');
            $table->string('name');
            $table->text('detail');
            $table->timestamps();
        });
    }
  
    public function down()
    {
        Schema::dropIfExists('members');
    }
}

Phase 4: Define a Laravel 6 Resource Route

routes/web.php

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

Phase 5: Add Laravel 6 Controller and Model

php artisan make:controller MemberController --resource --model=Member

app/Http/Controllers/MemberController.php

<?php
  
namespace App\Http\Controllers;
  
use App\Member;
use Illuminate\Http\Request;
  
class MemberController extends Controller
{
    public function index()
    {
        $members = Member::latest()->paginate(5);
        return view('members.index',compact('members'))
            ->with('i', (request()->input('page', 1) - 1) * 5);
    }
   
    public function create()
    {
        return view('members.create');
    }
  
    public function store(Request $request)
    {
        $request->validate([
            'name' => 'required',
            'detail' => 'required',
        ]);
  
        Member::create($request->all());
        return redirect()->route('members.index')
                        ->with('success','Member created successfully.');
    }
   
    public function show(Member $member)
    {
        return view('members.show',compact('member'));
    }
   
    public function edit(Member $member)
    {
        return view('members.edit',compact('member'));
    }
  
    public function update(Request $request, Member $member)
    {
        $request->validate([
            'name' => 'required',
            'detail' => 'required',
        ]);
  
        $member->update($request->all());
  
        return redirect()->route('members.index')
                        ->with('success','Member updated successfully');
    }
  
    public function destroy(Member $member)
    {
        $member->delete();
        return redirect()->route('members.index')
                        ->with('success','Member deleted successfully');
    }
}

app/Member.php

<?php
  
namespace App;
use Illuminate\Database\Eloquent\Model;
class Member extends Model
{
    protected $fillable = [
        'name', 'detail'
    ];
}

Phase 6: Add Laravel 6 Blade Files

resources/views/members/layout.blade.php

<!DOCTYPE html>
<html>
<head>
    <title>Laravel 6 CRUD Application - tamilrokers.com</title>
    <link href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.0.0-alpha/css/bootstrap.css" rel="stylesheet">
</head>
<body>
  
<div class="container">
    @yield('content')
</div>
   
</body>
</html>

resources/views/members/index.blade.php

@extends('members.layout')
 
@section('content')
    <div class="row">
        <div class="col-lg-12 margin-tb">
            <div class="pull-left">
                <h2>Simple Laravel 6 CRUD Example from scratch - pakainfo.com</h2>
            </div>
            <div class="pull-right">
                <a class="btn btn-success" href="{{ route('members.create') }}"> Create New Member</a>
            </div>
        </div>
    </div>
   
    @if ($message = Session::get('success'))
        <div class="alert alert-success">
            <p>{{ $message }}</p>
        </div>
    @endif
   
    <table class="pakainfo table table-bordered">
        <tr>
            <th>No</th>
            <th>Name</th>
            <th>Details</th>
            <th width="280px">Action</th>
        </tr>
        @foreach ($members as $member)
        <tr>
            <td>{{ ++$i }}</td>
            <td>{{ $member->name }}</td>
            <td>{{ $member->detail }}</td>
            <td>
                <form action="{{ route('members.destroy',$member->id) }}" method="POST">
   
                    <a class="btn btn-info" href="{{ route('members.show',$member->id) }}">Show</a>
    
                    <a class="btn btn-primary" href="{{ route('members.edit',$member->id) }}">Edit</a>
   
                    @csrf
                    @method('DELETE')
      
                    <button type="submit" class="btn btn-danger">Delete</button>
                </form>
            </td>
        </tr>
        @endforeach
    </table>
  
    {!! $members->links() !!}
      
@endsection

resources/views/members/create.blade.php

@extends('members.layout')
  
@section('content')
<div class="row pakainfo">
    <div class="col-lg-12 margin-tb">
        <div class="pull-left">
            <h2>Add New Member</h2>
        </div>
        <div class="pull-right">
            <a class="btn btn-primary" href="{{ route('members.index') }}"> Back</a>
        </div>
    </div>
</div>
   
@if ($errors->any())
    <div class="alert alert-danger">
        <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 action="{{ route('members.store') }}" method="POST">
    @csrf
  
     <div class="row pakainfo">
        <div class="col-xs-12 col-sm-12 col-md-12">
            <div class="form-group dsp">
                <strong>Name:</strong>
                <input type="text" name="name" class="form-control" placeholder="Name">
            </div>
        </div>
        <div class="col-xs-12 col-sm-12 col-md-12">
            <div class="form-group dsp">
                <strong>Detail:</strong>
                <textarea class="form-control" style="height:150px" name="detail" placeholder="Detail"></textarea>
            </div>
        </div>
        <div class="col-xs-12 col-sm-12 col-md-12 text-center">
                <button type="submit" class="btn btn-primary">Submit</button>
        </div>
    </div>
   
</form>
@endsection

resources/views/members/edit.blade.php

@extends('members.layout')
   
@section('content')
    <div class="row pakainfo">
        <div class="col-lg-12 margin-tb">
            <div class="pull-left">
                <h2>Edit Member</h2>
            </div>
            <div class="pull-right">
                <a class="btn btn-primary" href="{{ route('members.index') }}"> Back</a>
            </div>
        </div>
    </div>
   
    @if ($errors->any())
        <div class="alert alert-danger">
            <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 action="{{ route('members.update',$member->id) }}" method="POST">
        @csrf
        @method('PUT')
   
         <div class="row pakainfo">
            <div class="col-xs-12 col-sm-12 col-md-12">
                <div class="form-group dsp">
                    <strong>Name:</strong>
                    <input type="text" name="name" value="{{ $member->name }}" class="form-control" placeholder="Name">
                </div>
            </div>
            <div class="col-xs-12 col-sm-12 col-md-12">
                <div class="form-group dsp">
                    <strong>Detail:</strong>
                    <textarea class="form-control" style="height:150px" name="detail" placeholder="Detail">{{ $member->detail }}</textarea>
                </div>
            </div>
            <div class="col-xs-12 col-sm-12 col-md-12 text-center">
              <button type="submit" class="btn btn-primary">Submit</button>
            </div>
        </div>
   
    </form>
@endsection

resources/views/members/show.blade.php

@extends('members.layout')
@section('content')
    <div class="row pakainfo">
        <div class="col-lg-12 margin-tb">
            <div class="pull-left">
                <h2> Show Member</h2>
            </div>
            <div class="pull-right">
                <a class="btn btn-primary" href="{{ route('members.index') }}"> Back</a>
            </div>
        </div>
    </div>
   
    <div class="row pakainfo">
        <div class="col-xs-12 col-sm-12 col-md-12">
            <div class="form-group dsp">
                <strong>Name:</strong>
                {{ $member->name }}
            </div>
        </div>
        <div class="col-xs-12 col-sm-12 col-md-12">
            <div class="form-group dsp">
                <strong>Details:</strong>
                {{ $member->detail }}
            </div>
        </div>
    </div>
@endsection

Web Programming Tutorials Example with Demo

Read :

Also Read This 👉   Laravel Insert Update Delete in Eloquent ORM laravel

Summary

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

I hope you get an idea about Laravel 6 CRUD Application Tutorial.
I would like to have feedback on my infinityknow.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.

Related posts:

  1. Laravel 6 Insert Update and Delete record from MySQL
  2. Insert update delete Using Laravel 5.2 Ajax CRUD laravel without refresh page
  3. laravel 6 Update Data in AJAX CRUD Operations
  4. Laravel Insert Update Delete Multiple checkbox value Example
  5. Laravel 6 CRUD Tutorial With Example from scratch
  6. PHP MySQL CRUD Create, Insert, Update and Delete operations