用户更改密码的时候,sql为update member set password = $password,login=1,expire_time=time()+3600 where id=$id //假设表为member,密码字段为password,登录身份为login,密码有效期字段为expire,而且有效期为1小时。
更新密码的SQL update member set password ='$password',login=1,expire_time=date_add(now(),interval 10 day) where id=$id登录时候 update member set login=2 where expire_time < NOW()
update member set password ='$password',login=1,expire_time=date_add(now(),interval 10 day) where id=$id登录时候
update member set login=2 where expire_time < NOW()