How to Delete Multiple Records Using Laravel Eloquent

An instance of Collection does not have a delete method. You do have a destroy method on an instance of Model which will accept an array of ids.

You could handle this in a couple of ways: (i) use the existing destroy() method in your controller and accept either an id or an array of ids

public function destroy($id)
{
    if (is_array($id)) 
    {
        Product::destroy($id);
    }
    else
    {
        Product::findOrFail($id)->delete();
    }
    // redirect or whatever...
}

(ii) I prefer to route something like this to its own method, i.e. create a new method in the controller, e.g.

public function destroyMany(array $ids)
{
    Product::destroy($ids);
    // redirect or whatever...
}

@Jeffrey Am unable to create new forum thread, the POST button is automatically disabled even when recapcha is marked.

@ayekoto Be sure to add a subject in the subject line. The line is not very obvious, look at the thick colored portion at the top of the page with a blinking cursor.

@Stirnwendy Giving it to you, as I feel more comfortable passing in an array of id's to:

$org->products()->whereIn('id', $ids)->delete()

This way, a malicious user will not be able to delete products that do not belong to his organization, which he can easily do using Product::destroy().

Just so you know, there's also a truncate() method that'll delete all the rows and reset any auto_increment counter.

Thanks to cgabbanini. so helpful. I was just thinking that I can't use destroy function on collection but that's the way to go around..

$collection = ModelName::where('condition', 'value')->get(['id']);
ModelName::destroy($collection->toArray());

gmanish his answer is the best one... Remember ,always check how many queries you run...

His is just one query.. the other ones are multiple queries.

You could also do this with the builder if you wanted to delete the products with a list of userid's

DB::table('products')
 ->join('users','products.user_id' ,'=' ,'users.id')
 ->whereIn('users.id', $explodedUserIds)
 ->delete();

Hi,

if you have a Collection from a relationship for example, you can do :

$entities = $user->entities;
$entityIds = $entities->map( function($entity) {
    return [$entity['id']];
});
Entity::whereIn('id', $entityIds)->deleted();

I had the same need and this works fine.

Hi, I think you should try this codes

  public static function delete_data(){
        $id=request()->segment(2);
        $sql=InsertModel::where('id',$id)->delete();
    }

  $id=[4,5,6,7,8,9,10];
$result=myModel::whereIn('id',$id)->delete();
print_r($result);

Relation also can perform a delete

$this->hasMany(Bit::class)->delete();

Late, but found this awesome solution: (each->)

$org->products()->whereIn('id', $ids)->each->delete()