Laravel Ajax Multiple Delete Records using Checkbox Example

Laravel 8 ajax multiple delete records using checkbox example. In this tutorial, you will learn how to how to delete multiple rows using checkbox in jQuery ajax laravel 8 app.

Sometimes you need delete multiple records from table and database with checkboxes using jQuery ajax in laravel 8 app. So, You just need to follow some given steps to done of these delete multiple rows using checkbox in jQuery ajax laravel 8 app.

How to delete multiple rows using checkbox in jQuery ajax laravel

Follow the below given steps and delete multiple rows with checkbox using ajax in PHP Laravel 8 app:

• Step 1 – Install Laravel 8 App
• Step 2 – Connecting App to Database
• Step 3 – Create Model and Migration
• Step 4 – Add Routes
• Step 5 – Create Controllers By Artisan
• Step 6 – Create Blade Views
• Step 7 – Run Development Server
• Step 8 – Test This App

Step 1 – Install Laravel 8 App

First of all, Execute the following command on terminal to download or install laravel 8 fresh new setup:

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

Step 2 – Connecting App to Database

After that, open “.env” file and update the database name, username, and password in the env file:

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=Enter_Your_Database_Name
DB_USERNAME=Enter_Your_Database_Username
DB_PASSWORD=Enter_Your_Database_Password

Step 3 – Create Modal and Migration

In this step, create category table migration and create category Modal by using the following command:

php artisan make:model Category -m

Navigate database/migrations/ and open create_categorys_table.php file. Then update the following code into this file:

    public function up()
    {
        Schema::create('categories', function (Blueprint $table) {
            $table->id();
            $table->string('name');
            $table->text('description');
            $table->timestamps();
        });
    }
   

Now run the following command

php artisan migrate

Next, open Category.php model file and update the following code into it, which is placed on app/Models/:

Step 4 – Add Routes
Next step, Navigate to “routes/web.php” file and add the following routes into your web.php file:
use App\Http\Controllers\CategoryController;

Route::get('cat', [CategoryController::class, 'index']);
Route::delete('category/{id}', [CategoryController::class, 'destroy']);
Route::delete('delete-multiple-category', [CategoryController::class, 'deleteMultiple']);
Step 5 – Create Controllers by Artisan
Next step, execute the following command on terminal to create controller file that named CategoryController:
php artisan make:controller CategoryController 
This command will create CategoryController by the artisan command.
Next, Navigate to app/http/controller and open CategoryController.php.Then update the following methods into your controller file:
delete();
        return back()->with('success','Category deleted successfully');
    }   

    public function deleteMultiple(Request $request)
    {
        $ids = $request->ids;
        Category::whereIn('id',explode(",",$ids))->delete();
        return response()->json(['status'=>true,'message'=>"Category deleted successfully."]);
        
    }

}
Step 6 – Create Blade Views
In this step, create one blade views file for rendering data on it. So navigate to resources/views folder and create the blade view as following:
Create first file name index.blade.php and update the following code into it:



    >




PHP delete multiple records by selecting checkboxes using javascript
@if ($message = Session::get('success'))

{{ $message }}

@endif
Delete All

@if($categories->count())
@foreach($categories as $key => $category)

@endforeach
@endif



S.No.
Category Name
Category Details
Action


{{ ++$key }}
{{ $category->name }}
{{ $category->description }}

{!! Form::open(['method' => 'DELETE','route' => ['category.destroy', $category->id],'style'=>'display:inline']) !!}
{!! Form::button('Delete', ['class' => 'btn btn-danger btn-xs','data-toggle'=>'confirmation','data-placement'=>'left']) !!}
{!! Form::close() !!}


 



Step 7 – Run Development Server
In this step, use the following php artisan serve command to start your server locally:
php artisan serve
Step 8 – Test This App
Now, open browser and hit the following url on it for test this app:
Conclusion
Laravel 8 ajax multiple delete records using checkbox example. In this tutorial, you have learned how to how to delete multiple rows using checkbox in jQuery ajax laravel 8 app.
Recommended Laravel Posts

 
Related