Php automatically listens to a certain field value of the Mysql database table. when this value changes, the database update operation is triggered. php automatically listens to a field value of the Mysql database table. when this value changes, the database update operation is triggered.. For example, if the user enters a wrong password to lock the user's account, it will be automatically unlocked three hours later ------ solution ------------------ that's easy 1. user input error 2. php updates database field block write current time User php automatically listens to a certain field value of Mysql database table when this value changes triggers database update operation
Php automatically listens to a field value in the Mysql database table. when this value changes, the database update operation is triggered. For example, if the user enters a wrong password to lock the user's account, it will be automatically unlocked three hours later.
------ Solution --------------------
That's easy
1. user input error
2. php updates the current time when the database field block is written.
The next time you log on, verify that the password is correct, and check whether the block is obtained. if the acquisition time is greater than 3 hours, the default block reset time is unblock.
Of course, you can also check whether the account is block.
