How to verify email address in php + mysql?

Question

PHP

It is necessary to send a link to the mail in php + mysql, after clicking on which the user account is confirmed

Answer 1

When registering, you create a field in mysql in which you store a unique e-mail address confirmation key, and send a link (or just this key) to the mail and redirect the user to the page where you need to enter it. When you enter the correct key (or when you follow the link from the letter, check the GET parameter and compare it with
the entry in mysql) - update the entry in the database, indicating that the user has successfully confirmed the registration.

Answer 2

Additionally, I would also like to bind to ip, otherwise the option above is completely correct