How to check in the database in the background?

Question

Yii

Good afternoon, on the site I am doing the Subscription function, that is, the account is given 1 month of free use. Where, in what place of the project you need to register a trigger or a function that will always compare data and turn off those that have expired (Now this is done only after a person logs into the account)

Answer 1

Add a field to the user where to store the last subscription date.

class User {
    public function isSubscriptionWorks() {
        return $this->subscibed_at > strtotime('1 month ago');
    }
}

Answer 2

The simplest solution is to run tasks with cron.

Answer 3

If it is still not clear, then no triggers are needed .
A "deactivated account" is one whose subscription has expired.