批量删除在Laravel 4.1,基于ID或对象数组 [英] Mass delete in Laravel 4.1, based on array of ids or objects
问题描述
我只是想知道这是否是可能的。
我知道,当你有多个行插入,你可以建立一个数组,这样做:
DB ::表('some_table') - GT;插入($数组);
但据我读过,做同样的删除似乎并不可能,我想知道是否有人知道的方式做这样的事情:
DB ::表('some_table') - GT;删除($数组);
在Laravel 4.1删除记录的方法很多
1)当你想从数据库中删除记录,只需调用删除方法:
$影响= DB ::表(用户) - GT;其中('ID','=', 1) - GT;删除();
2)希望通过其ID为快速删除记录?没问题。只是ID传递到删除方法:
$ =影响DB ::表(用户) - GT;删除(1);
3)如果您想通过ID一次删除多个记录,通过他们的ID在一个数组 - 使用下面的
$ users_to_delete =阵列(1,2,3);
DB:表(用户) - GT;其中('ID',$ users_to_delete) - GT;删除();
4)如果您想通过ID一次删除多条记录,传递用户的数组 - 使用下面的
由数字0,1,2索引 //(区分A)用户领域..
$ users_to_delete =阵列(
0=>阵列('1','弗兰克','史密斯','不管'),
'1'=>阵列('5','约翰','生','Whateverelse'),
); $ ids_to_delete = array_map(函数($项目){$回报项目[0];} $ users_to_delete); DB:表(用户) - GT;其中('ID',$ ids_to_delete) - GT;删除(); 通过键索引//(情况B)用户领域
$ users_to_delete =阵列(
0=>阵列('ID'=>'1','名'=>'弗兰克','姓'=>'史密斯','标题'=>'不管'),
'1'=>阵列('ID'=>'5','名'=>'约翰','姓'=>'约翰逊','标题'=>'Whateverelse'),
); $ ids_to_delete = array_map(函数($项目){$返回项['身份证'];} $ users_to_delete); DB:表(用户) - GT;其中('ID',$ ids_to_delete) - GT;删除();
5)删除现有的模型,通过按键
用户::销毁(1);
用户::破坏(阵列(1,2,3));
用户::破坏(1,2,3);
6)当然,你也可以运行在一组模型删除查询:
$ affectedRows =用户::在这里('票','>',100) - GT;删除() ;
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);
Many ways of deleting records in Laravel 4.1
1) When you want to delete records from your database, simply call the delete method:
$affected = DB::table('users')->where('id', '=', 1)->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) If you want to delete multiple records by id at once, passing their ids in an array - use the following
$users_to_delete = array(1, 2, 3);
DB::table('users')->whereIn('id', $users_to_delete)->delete();
4) If you want to delete multiple records by id at once, passing an array of users - use the following
//(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) Deleting An Existing Model By Key
User::destroy(1);
User::destroy(array(1, 2, 3));
User::destroy(1, 2, 3);
6) Of course, you may also run a delete query on a set of models:
$affectedRows = User::where('votes', '>', 100)->delete();
这篇关于批量删除在Laravel 4.1,基于ID或对象数组的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!