验证接收值以及值的格式
$data = $this->_vali([
'contact_phone.require' => '请填写手机号码',
'contact_phone.mobile' => '手机号码格式错误!',
'password.require' => '请填写登录密码',
'type.value' => 4, //默认值
'password.min:4' => '登录密码不能少于4位字符!',
]);
操作:添加
$this->app->db->name($this->table)->insert($data) //$this->table表名 //$data 验证后的数据
操作:删除
$this->app->db->name('表名')->where($data)->delete()
操作:修改
$this->app->db->name('SystemUser')->where(['id' => $user['id']])->update([
'login_ip' => $this->app->request->ip(),
'login_at' => $this->app->db->raw('now()'),
'login_num' => $this->app->db->raw('login_num+1'),
]);
操作:查询
$query = $this->_query($this->table)->where(['uuid' => $this->uuid, 'type' => 4]);
$result = $query->whereIn('status', [1, 2])->order('id desc')->page(true, false, false, 15); //page 分页