laravel5.3軟刪除

2019-11-11 05:33:59

字體：大中小

來源：轉載

供稿：網友

1、首先在模型中要使用SoftDeletestrait,該trait為軟刪除提供一系列相關方法，具體可參考源碼Illuminate/Database/Eloquent/SoftDeletes ，此外還要設置$date屬性數組，將deleted_at置于其中：

<?phpnamespace App/Model/Backend;use App/Http/Response;use Illuminate/Database/Eloquent/Model;use Illuminate/Database/Eloquent/SoftDeletes;use Request;class User extends Model{ use SoftDeletes; PRotected $table = 'users'; //表名 protected $primaryKey = 'id'; //主鍵 protected $datas = ['deleted_at'];

2、向數據庫中的相應數據表添加 delete_at 字段

#生成一個遷移文件php artisan make:migration add_deleted_at_to_users_table --table=users #執行遷移文件php artisan migrate<?php use Illuminate/Database/Schema/Blueprint; use Illuminate/Database/Migrations/Migration; class AlterPostsDeletedAt extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::table('posts', function (Blueprint $table) { $table->softDeletes(); }); } #模型里面執行delete方法就行了 self::whereIn('id', $ids)->delete(); //刪除用戶 withTrashed() 顯示所有數據 onlyTrashed() 顯示刪除數所 restore()還原數據

上一篇：透明位圖測試

下一篇：Apache Commons工具集簡介