How to confirm a request to add an entry to the database via mail?

Question

PHP

Tell me where to dig if I want to implement the confirmation process for adding an entry to the database via mail. That is, a person leaves some data on the site and sends it. And before the data was added to the database, the data must be sent to the mail and, upon confirmation through the mail, it was added to the database.

Answer 1

I would do so. Immediately write to the database, put an additional verify field, false by default. The script writes to the database, gets the record ID, generates a link to the confirmation script and sends it to the mail. The verification script only gets the record ID and sets the verify field to true. Wherever you need to implement verify. Periodically, either cron or manually clean the database.

Answer 2

The data, if there is not much of it, can be written immediately upon receipt with GET parameters to the confirmation link, add a field with the date of filling and a signature - a hash from (all data + mail address + salt known only to the site) and send to this mail. By reference, check if the hash converges and if the date is fresh. If everything is OK - then write to the database.
No intermediate storage is required.