How to do password expiry in php or mysql?

[rupalee]

How to do password expiry in php or mysql?

[Rabbit]

You do it by storing the expiration date in the table and then retrieving the date from the table when authenticating the user.

[HaLo2FrEeEk]

Pretty much what rabbit said, to expand a little bit though, when the user logs in you check the current time against the expiry time. If the current time is less than the expiry time, continue with the login, if it is greater, notify the user that their password has expired and give them the option to change it. Don't allow the login if the current time is greater than the expiry time.

[rupalee]

Yup,..thanks ..i will try this.