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

相关文章

• Laravel 模型中的 Fillable 属性是什么?
• Laravel 中的命名路由是什么?
• Laravel 中的中间件是什么?
• 如何在 Laravel 中使用验证?
• 如何在 Laravel 中验证数组?
• 如何在 Laravel 中对多列使用 OrderBy?
• 如何在 Laravel 中从表中获取所有列名?
• 如何使用 Laravel 的流式查询构建器进行计数选择?
• 如何使用 db::raw 在 Laravel Fluent 上更新查询?
• 如何在 Laravel 中向 MySQL 表中插入新用户?