如何在 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
廣告