問題描述

我只是想知道是否有可能.

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 傳遞到刪除方法中即可:

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();

這篇關于如何使用 Laravel 4.1 基于 id 或對象數組執行批量刪除?的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！