How to delete multiple row from DB table by laravel?

Question

I want to delete all comments from comments table.I did that by doing this but this is not the laravel way. Anyone answer the correct steps please .

$comments = Comment::where('post_id',$id)->get();
    if(count($comments)>1)
    {
        $comment_id= [];
        foreach ($comments as $i)
        {
            $comment_id[] = $i->id;
        }
        for($i=0;$i<count($comments);$i++)
        {
            Comment::find($comment_id[$i])->delete();
        }
    }
    elseif (count($comments)==1)
    {
        $comments->delete();
    }

Please scepicify the name of the fields. and the 'Something by Laravel in destroy method' — Jacky Montevirgen
– Jacky Montevirgen, Commented Jan 9, 2017 at 1:06

Evgeniy Maynagashev · Accepted Answer · 2017-01-09 06:38:20Z

24

Since each Eloquent model serves as a query builder, try this, all in one line:

Comment::where('post_id',$id)->delete();

Tested in tinker, works as expected, returns count of deleted rows.

Documentation: https://laravel.com/docs/5.3/queries#deletes

answered Jan 9, 2017 at 6:38

Evgeniy Maynagashev

6901 gold badge8 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

2 revs, 2 users 50% · Accepted Answer · 2021-04-05 11:24:57Z

3

DB::table('users')->whereIn('id', $ids_to_delete)->delete();

or

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

edited Apr 5, 2021 at 11:24

community wiki

2 revs, 2 users 50%
Mohammad Ali Abdullah

1 Comment

Cosmin Staicu Over a year ago

Please add some comments about your code and how does it answers the question.

Robson · Accepted Answer · 2021-03-31 18:59:08Z

2

You can try the following approach:

public function deleteAll(Request $request)
{
    $ids = $request->ids;
    Comment::whereIn('id',explode(",",$ids))->delete();
}

edited Mar 31, 2021 at 18:59

Robson

8135 gold badges23 silver badges44 bronze badges

answered Mar 31, 2021 at 10:23

Monir Khan

311 bronze badge

Comments

Enver · Accepted Answer · 2021-08-24 16:24:30Z

0

Collect only ids from your command like below and destroy by model.

$yourRaws = YourModel::where('name', 'Enver')->get();
...
YourModel::destroy($yourRaws->pluck('id')->toArray());

Enjoy Your Coding !

answered Aug 24, 2021 at 16:24

Enver

6168 silver badges8 bronze badges

Collectives™ on Stack Overflow

How to delete multiple row from DB table by laravel?

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related