- 增删改操作
- 新增方法如下,注意:默认模型接管 created_at和updated_at: (注意碰到updated_at报错一定要记得在模型文件里添加public $timestamps = false;)
$users = new User();
$users->id = ‘27’;
$users->username = ‘辉夜’;
$users->password = ‘123’;
$users->gender = ‘女’;
$users->email = ‘huiye@163.com’;
$users->price = ‘320.00’;
$users->details = ‘123’;
$users->uid = “1008”;
$users->status = ‘1’;
$users->create_time = “2018-10-20 12:32:33”;
$users->update_time = ‘2020-09-22 20:21:38’;
$users->save();
b. 更新,只要是查找到一条数据的情况下使用save()就是更新
$users = User::find(24);
$users->username = ‘杜牧’;
$users->save();
c. 使用update()方法实现批量更新
User::where(‘username’, ‘杜牧’)
->update([
‘username’ => ‘李白’
]);
e. 使用create()方法实现新增,但需要在模型端设置批量赋值的许可:(这个方法主要是防止上传的数据有杂七杂八的值)
User::create([
‘username’ => ‘上官’,
‘password’ => ‘123’,
‘gender’ => ‘女’,
‘email’ => ‘shangguan@163.com’,
‘price’ => ‘320.00’,
‘details’ => ‘123’,
‘uid’ => ‘1009’,
‘status’ => ‘1’,
‘create_time’ => ‘2003-10-22 05:20:54’,
‘update_time’ => ‘2077-06-02 05:20:54’
]);
模型端代码:
protected $fillable = [
‘username’,
‘password’,
‘gender’,
‘email’,
‘price’,
‘details’,
‘uid’,
‘status’,
‘create_time’,
‘update_time’
];
//也可以取消批量赋值限制直接在模型端代码下输入:protected $guarded = []; 就可以全部开放
f. 使用detete()方法,可以删除数据:
$users = User::find(30);
$users->delete();
//批量删除
$users = User::where(‘username’, ‘辉夜’);
$users->delete();
g. 如果你是通过组件id删除,那使用destroy(id)方法,免去查询操作;
//通过主键删除,删掉了id为1的记录
User::destroy(1);
User::destroy([1, 2, 3]);