how to delete multiple ids in laravel?

Question

my table name is paids and i want to delete all the ids which have same ot_id here is my databsae

i have data like this

 |id|  |ot_id|
   1      20
   2      20
   3      20
   4      20
   5      20
   6      20

public function deleteOT($id)
{
    $deleteid = Paid::where();
    return Common::Message("Order Taker", 3);
}

here i want to delete how i can do that in laravel?

Donkarnash · Accepted Answer · 2020-12-09 08:41:49Z

3

You should spend some time reading Laravel docs, which are very good source for learning the basics.

public function deleteOt($id)
{
    Paid::where('ot_id', $id)->delete();

    return Common::Message("Order Taker", 3);
}

answered Dec 9, 2020 at 8:41

Donkarnash

12.9k5 gold badges30 silver badges43 bronze badges

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

Comments

M. K. T. M. Sameera · Accepted Answer · 2020-12-10 08:26:59Z

2

To select multiple rows at once you can use, whereIn()

public function deleteOt($id)
{
   Paid::whereIn('id', $ids)->delete();
   return Common::Message("Order Taker", 3);
}

edited Dec 10, 2020 at 8:26

answered Dec 9, 2020 at 9:56

M. K. T. M. Sameera

1481 gold badge2 silver badges14 bronze badges

1 Comment

Nico Haase Over a year ago

Please add some explanation to your answer such that others can learn from it

Pankaj Maurya · Accepted Answer · 2020-12-09 10:15:09Z

0

1. $id => it should be an array when you delete multiple ids.

     public function deleteOt($id) {
           Paid::whereIn('id', $ids)->delete();
           return Common::Message("Order Taker", 3);
     }

answered Dec 9, 2020 at 10:15

community wiki

Pankaj Maurya

Collectives™ on Stack Overflow

how to delete multiple ids in laravel?

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related