MySQL Forums
Forum List  »  PHP

"activating" a user via unique code and e-mail in PHP and MySQLi
Posted by: J Malleus
Date: July 13, 2020 08:02PM

I have two PHP files that collect user information. After someone uses the first one, and enters an e-mail, I want to store this data in the DB and create a unique ID or code that corresponds to that entered e-mail and is set to "inactive".

A message is then dispatched to that e-mail and contains the ID, passed to the second script via the URL. Then the second script reads this, and if the ID checks out, the e-mail is then "activated" and the script proceeds, else, the script produces an error.

I am very new to PHP and MySQL, so any pointers would be great. I've already created the MySQLi DB but haven't added any rows/columns to it yet. I definitely want to use unique index and constraints.

I hope I explained this okay. :) Thanks!!

Options: ReplyQuote

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.