mysql/php help

[Opserty]

There are hundreds upon thousands of PHP & MySQL tutorials out there, do a bit of searching!

No-one is going to give you all the code. Break down your solution to begin with and then look up how you need to each part...

E.g. Password Recovery:

1. Generate a temporary random hash for the password recovery, store it in the database along with the time it was made. (The hash can be a md5() of the time and some random number, for example)
2. Send a link to the page in an email to the email of user's account, (the link should include the hash in the url e.g. restpw.php?hash=....)
3. On resetpw.php check there is a hash, if yes, then verify that the hash hasn't expired (like say after 1 day the hash is no longer valid (this is a timestamp comparison))
4. If the hash is valid then provide them with a form to edit & confirm the new password
5. Store the new password in the DB.
6. Optional: Send an email to the user that the password has been reset