Techsolutionstuff

How To Delete Multiple Records Using Checkbox In Laravel

Techsolutionstuff's photo
Techsolutionstuff

In this example I will show you how to delete multiple records using checkbox in laravel or delete multiple rows in laravel using jquery.

Many times we have multiple record in database and whenever we want to delete records it is time consuming to delete records one by one, So, in this example we can delete multiple records using checkbox or we can delete all records at a same time,

So, let's start and follow below steps.

Step 1 : Install Laravel

Install laravel application. if you don't have laravel application in your system. so copy below command and create laravel application

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

Step 2 : Database Setup

In this step, we will configure database for example database name, username, password etc. for our demo of laravel. So, open .env file and fill all details like as bellow.

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=database name(blog)
DB_USERNAME=database username(root)
DB_PASSWORD=database password(NULL)

Step 3 : Add Dummy Records Using Tinker

Now, Run below command in your terminal to add multiple dummy user's data , it will inserted 200 records automatically.

php artisan tinker
factory(App\User::class, 200)->create();

Read More : Create Dummy Data Using Tinker In Laravel

Step 4 : Create Controller DeleteUserController

After executed step 3 now create controller on this path app\Http\Controllers\DeleteUserController.php and add below command.

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\User;

class DeleteUserController extends Controller
{
    public function contactlist(Request $request)
    {
        $list = User::orderby('id', 'desc')->get();
        return view('delete_multiple_user')->with('list', $list);
    }

    public function multipleusersdelete(Request $request)
    {
        $id = $request->id;
        foreach ($id as $user) 
        {
            User::where('id', $user)->delete();
        }
        return redirect();
    }
}

Step 5 : Add Route

Now Add route in routes/web.php

<?php

use Illuminate\Support\Facades\Route;

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

Route::get('contactlist', 'DeleteUserController@contactlist');
Route::post('multipleusersdelete', 'DeleteUserController@multipleusersdelete');

Read More : Laravel AJAX CRUD Example Tutorial

Step 6 : Create Blade File

We need to create blade file for view output , So create new blade file in this path contactlist\resources\views\delete_multiple_user.blade.php and add below code.

<!DOCTYPE html>
<html>
<head>
    <title>How to Delete Multiple Records in Laravel - Techsolutionstuff</title>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/css/bootstrap.min.css">
    <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js"></script>
</head>
<body>
    <h1>How to Delete Multiple Records in Laravel - Techsolutionstuff</h1>
    <form method="post" action="{{url('multipleusersdelete')}}">
        {{ csrf_field() }}
        <br>
        <input class="btn btn-success" type="submit" name="submit" value="Delete All Users"/>
        <br><br>
        <table class="table-bordered table-striped" width="50%">
            <thead>
                <tr>
                    <th class="text-center">S.No.</th>
                    <th class="text-center">User Name</th>
                    <th class="text-center"> <input type="checkbox" id="checkAll"> Select All</th>
                </tr>
            </thead>
            <tbody>
                <?php
                $i=1;
                foreach ($list as $key => $value) {
                    $name = $list[$key]->name;
                    ?>
                    <tr>
                        <td class="text-center">{{$i}}</td>
                        <td class="text-center">{{$name}}</td>
                        <td class="text-center"><input name='id[]' type="checkbox" id="checkItem" 
                         value="<?php echo $list[$key]->id; ?>">
                        </tr>
                        <?php $i++; }?>
                    </tbody>
                </table>
                <br>
            </form>
            <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
        </script>
        <script language="javascript">
            $("#checkAll").click(function () {
                $('input:checkbox').not(this).prop('checked', this.checked);
            });
        </script>
    </body>
    </html>

Now , We are done with our code

So, copy below command and run in terminal.

php artisan serve

After that run this project in your browser.

http://localhost:8000/contactlist

Read More : Import Export CSV/EXCEL File In Laravel

Thank you for reading. I hope you enjoyed the article!.

LaravelPHPMySQLjQueryHTML