public function index(Request $request) { $Member = new Member(); //============================================ // Eloquent ORM /* 插入一条数据 $Member->nickname = $request->nickname; $Member->save(); */ /* 先查找再更新的方式 $Member = Member::find('1'); $Member->nickname = $request->nickname; $Member->save(); */ /* 指定条件更新的方式: 把uid=1和employee_id=0020行的nickname更改为abc $res = Member::where('uid', 1) ->where('employee_id', '0020') ->update(['nickname' => 'abc']); */ /* create方式新增数据, $filltable的字段允许, $guarded 的字段不允许 $res = Member::create(['uid' => '12', 'employee_id' => '00019', 'nickname' => 'aaa']); */ /* 通过属性取的数据, 没有则新增 $res = Member::firstOrCreate(['uid' => '12', 'employee_id' => '00019']); */ /* 返回的对象没有插入数据库, 需要再调用save()才能写入 $res = Member::firstOrNew(['uid' => '12', 'employee_id' => '00019']); */ /* 知道主键值的情况, 直接销毁 $res = Member::destroy(12); // 删除模型主键为12的 $res = Member:destroy([1, 12]); // 删除多个 */ /* 条件删除 $res = Member::where('employee_id', '00019')->delete(); */ /* 软删除, 保证有字段deleted_at, 并设置下面三项, 软删后, 字段值为时间戳 1. use Illuminate\Database\Eloquent\SoftDeletes; 2. use SoftDeletes; 3. protected $dates = ['deleted_at']; $res = $Member->where('site_id', '1')->delete(); */ /* 不含软删除的查询 $res = Member::where('site_id', 1) ->get(); */ /* 含有软删除数据的查询 $res = Member::withTrashed() ->where('site_id', 1) ->get(); */ /* 取回只含软删除的数据 $res = $Member->onlyTrashed() ->where('site_id', 1) ->get(); */ //============================================ // SQL Queries (见模型中的DB操作) $res = $Member->show(); /* $data = [$request->url, $request->title]; $res = $Member->add($data); */ /* $res = $Member->edit($request->url, $request->site_id); */ /* $where = "site_id = {$request->site_id}"; $res = $Member->del($where); */ echo '<pre>'; print_r($res); }