如何在 Laravel 5 中刪除單條記錄?


有多種方法可以實現。讓我們測試一些示例,幫助我們刪除 Laravel 中的單條記錄。

假設我們建立了一個名為users的表,如下所示:

mysql> select * from users;
+----+---------------+------------------+--------------+------------+------+
| id |     name      |    email         |    password  |    address | age |
+----+---------------+------------------+--------------+------------+------+
| 1  |     Siya Khan | siya@gmail.com   | hgfdv3vhjd   |   Xyz      | 20  |
| 2  |    Rehan Khan | rehan@gmail.com  | cskjg367dv   |   Xyz      | 18  |
| 3  |    Rehan Khan | rehan@gmail.com  | dshjgcv2373h | testing    | 20  |
| 4  |         Rehan | rehan@gmail.com  |   abcd       | vci4hn4f4  | 15  |
| 5  | Nidhi Agarwal | nidhi@gmail.com  | fjh99302v    | abcd       | 20  |
| 6  | Ashvik Khanna | ashvik@gmail.com | 83bg44f4f    | oooo       | 16  |
| 7  |   Viraj Desai | viraj@gmail.com  | ppsdkj39hgb2 | test       | 18  |
| 8  |   Priya Singh | priya@gmail.com  | chjbbvgy3ij  | test123    | 20  |
+----+---------------+------------------+--------------+------------+------+

示例 1

可以使用find()方法,它接受一個鍵值作為引數,並返回具有給定鍵作為主鍵的模型。delete()方法刪除當前記錄。以下示例演示如何使用這兩個方法刪除記錄:

<?php namespace App\Http\Controllers; use Illuminate\Http\Request; use App\Models\User; class UserController extends Controller { public function index() { $userDetails = User::find(9); $deleteuser = $userDetails->delete(); if ($deleteuser) { echo "Record deleted from table successfully"; } else { echo "Error in Deletion"; } } }

輸出

以上程式碼的輸出如下:

Record deleted from table successfully

示例 2

可以在 where 子句中新增條件,以從表中刪除記錄,如下所示:

<?php namespace App\Http\Controllers; use Illuminate\Http\Request; use App\Models\User; class UserController extends Controller{ public function index() { $deleteuser = User::where('id', '=', 11)->delete(); if ($deleteuser) { echo "Record deleted from table successfully"; } else { echo "Error in Deletion"; } } }

輸出

以上程式碼的輸出為:

Record deleted from table successfully

示例 3

還可以使用destroy()方法從表中刪除記錄。

<?php namespace App\Http\Controllers; use Illuminate\Http\Request; use App\Models\User; class UserController extends Controller { public function index() { $deleteuser = User::destroy(12);; if ($deleteuser) { echo "Record deleted from table successfully"; } else { echo "Error in Deletion"; } } }

輸出

以上程式碼的輸出為:

Record deleted from table successfully

示例 4

如果要一次刪除多條記錄,可以按如下所示操作:

<?php namespace App\Http\Controllers; use Illuminate\Http\Request; use App\Models\User; class UserController extends Controller{ public function index() { $deleteuser = User::destroy([15,16,17]); if ($deleteuser) { echo "Record deleted from table successfully"; } else { echo "Error in Deletion"; } } }

輸出

以上程式碼的輸出為:

Record deleted from table successfully

更新於:2022年8月30日

478 次瀏覽

開啟你的職業生涯

完成課程獲得認證

開始學習
廣告