laravel5.2 batch deletion-Laravel-php.cn

laravel5.2 batch deletion

王林

Release： 2023-05-20 16:26:40

Original

641 people have browsed it

Laravel 5.2 is a modern PHP framework that is loved by many developers. In Laravel, adding, deleting, checking and modifying data is a very common operation, and batch deletion is no exception. This article will introduce how to batch delete data using Laravel 5.2.

Preparation

Before we begin, we need to create a sample project to demonstrate the operation of batch deletion of data. Enter the following command in the command line:

laravel new batch-delete-example

Copy after login

Then enter the project directory and run the following command to create a data table named posts:

php artisan make:model Post -m

Copy after login

Then add the following code in the Post model:

<?php

namespace App;

use IlluminateDatabaseEloquentModel;

class Post extends Model
{
    protected $fillable = ['title', 'content'];
}

Copy after login

Fill in some sample data in the fill file DatabaseSeeder.php:

<?php

use IlluminateDatabaseSeeder;

class DatabaseSeeder extends Seeder
{
    public function run()
    {
        factory(AppPost::class, 10)->create();
    }
}

Copy after login

Finally run the following command to populate the data:

php artisan migrate --seed

Copy after login

Delete data in batches

In Laravel, we can use the delete method provided by Eloquent to delete records.

If we want to delete a single record, we can do this:

$post = Post::find(1);
$post->delete();

Copy after login

But what if we want to delete multiple records in batches? At this time we can use the whereIn method, which can receive an array, query the records that meet the conditions in the specified field and delete them.

Let’s take a look at the basic syntax first:

Post::whereIn('id', $ids)->delete();

Copy after login

Among them, $ids is an array containing multiple id values, representing the id value of the record we want to delete.

For example, if we want to delete three records with IDs 1, 3, and 5, we can do this:

$ids = [1, 3, 5];
Post::whereIn('id', $ids)->delete();

Copy after login

Of course, we can also delete records based on other conditions. For example, if we want to delete all records created earlier than 2022, we can do this:

Post::where('created_at', '<', '2022-01-01 00:00:00')->delete();

Copy after login

It should be noted that using the whereIn method will automatically be converted into a delete statement, so it will not retrieve all records that meet the criteria and delete them individually. Instead, these records will be deleted directly at the database level, so use with caution.

Confirm deletion operation

When we use the delete method to delete a record, Laravel does not provide a confirmation operation, which means that once the deletion operation is performed, it cannot be undone.

If we want to confirm the user's deletion operation, we can add a confirmation pop-up window on the front end or a confirmation box on the back end to let the user confirm whether they want to delete the record.

In this article, we use SweetAlert to create a confirmation pop-up window.

First, run the following command in the command line to install SweetAlert:

npm install sweetalert2

Copy after login

Then add the SweetAlert CSS and JS files in app.blade.php:

<!DOCTYPE html>
<html>
    <head>
        <title>Laravel</title>
        <link rel="stylesheet" type="text/css" href="{{ asset('css/app.css') }}">
        <link rel="stylesheet" type="text/css" href="https://cdn.jsdelivr.net/npm/sweetalert2@10.16.0/dist/sweetalert2.min.css">
        <script src="{{ asset('js/app.js') }}"></script>
        <script src="https://cdn.jsdelivr.net/npm/sweetalert2@10.16.0/dist/sweetalert2.min.js"></script>
    </head>
    <body>
        @yield('content')
    </body>
</html>

Copy after login

Then in Add the following code to the blade template:

<form method="post" action="{{ route('posts.destroy', $post->id) }}" style="display: inline-block;">
    @csrf
    @method('DELETE')
    <button type="submit" class="btn btn-danger btn-sm"
        onclick="event.preventDefault();
        Swal.fire({
            title: '确定删除吗？',
            icon: 'warning',
            showCancelButton: true,
            confirmButtonText: '确认删除',
            cancelButtonText: '取消'
        }).then((result) => {
            if (result.value) {
                this.parentElement.submit();
            }
        });"
    >删除</button>
</form>

Copy after login

In it, we define an event for clicking the delete button, which will pop up a confirmation pop-up window when the user clicks the delete button. If the user clicks the confirm button, JavaScript submits the form and deletes the corresponding record.

It should be noted that in the form form of the deletion operation, we added @csrf and @method('DELETE'). This is because the deletion operation in Laravel needs to be submitted through the HTTP DELETE method. The browser only supports GET and POST methods, so you need to use hidden input to specify the request method.

Unless necessary, we should try to avoid using batch deletion operations, because it may lead to irreparable loss of data. If you need to delete a single record, you can use the delete method provided by Eloquent, which will ask the user to confirm the deletion before deleting the record. If you need to delete multiple records, you can use the whereIn method, but be careful to confirm before use.

The above is the detailed content of laravel5.2 batch deletion. For more information, please follow other related articles on the PHP Chinese website!