如何根据ID或对象数组使用Laravel 4.1执行批量删除? [英] How do I perform a Mass delete using Laravel 4.1, based on array of ids or objects?
问题描述
我只是想知道是否有可能.
I just wanted to know if it's possible.
我知道当您要插入多行时,您可以构建一个数组并执行以下操作:
I know when you have multiple rows to insert, you can just build an array and do something like:
DB::table('some_table')->insert($array);
但据我所知,似乎无法进行删除操作,我想知道是否有人知道做某事的方法:
But as far as I've read, doing the same for deleting doesn't seem to be possible, I'd like to know if anyone know of a way to do something like:
DB::table('some_table')->delete($array);
推荐答案
在Laravel 4.1中删除记录的多种方法
1)如果要从数据库中删除记录,只需调用delete方法:
1) When you want to delete records from your database, simply call the delete method:
$affected = DB::table('users')->where('id', '=', 1)->delete();
2)是否想通过其ID快速删除记录?没问题.只需将ID传递到delete方法即可:
2) Want to quickly delete a record by its ID? No problem. Just pass the ID into the delete method:
$affected = DB::table('users')->delete(1);
3)如果要一次通过ID删除多条记录,并将其ID传递到数组中,请使用以下
$users_to_delete = array(1, 2, 3);
DB::table('users')->whereIn('id', $users_to_delete)->delete();
4)如果要一次通过ID删除多条记录,并传递一组用户-请使用以下
//(case A) User fields indexed by number 0,1,2..
$users_to_delete = array(
'0'=> array('1','Frank','Smith','Whatever'),
'1'=> array('5','John','Johnson','Whateverelse'),
);
$ids_to_delete = array_map(function($item){ return $item[0]; }, $users_to_delete);
DB::table('users')->whereIn('id', $ids_to_delete)->delete();
//(case B) User fields indexed by key
$users_to_delete = array(
'0'=> array('id'=>'1','name'=>'Frank','surname'=>'Smith','title'=>'Whatever'),
'1'=> array('id'=>'5','name'=>'John','surname'=>'Johnson','title'=>'Whateverelse'),
);
$ids_to_delete = array_map(function($item){ return $item['id']; }, $users_to_delete);
DB::table('users')->whereIn('id', $ids_to_delete)->delete();
5)通过密钥删除现有模型
5) Deleting An Existing Model By Key
User::destroy(1);
User::destroy(array(1, 2, 3));
User::destroy(1, 2, 3);
6)当然,您也可以在一组模型上运行删除查询:
6) Of course, you may also run a delete query on a set of models:
$affectedRows = User::where('votes', '>', 100)->delete();
这篇关于如何根据ID或对象数组使用Laravel 4.1执行批量删除?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!