Email Verification Link Updates DB?

[denzlite]

is there a way when sending a ton of emails that i can

place a unique link within each email -

when user clicks link - database is updated -

webpage opens with confirmation message -

much appreciated, jason

[djjjozsi]

create a new field to the database table, called : code

make a string , use the microteime, the parts of the email, and its ID, and a random number using rand() , and the session_id() , and encrypt this whole string with SHA1 ,
take into the link as activation value. And update the table with this code to store this string.

The user click on this code , and activate.php will validate it.

how to make it better, search on php.net the rand() function.

Hello, jjozsi.

[denzlite]

Thanks!

Is there any way to find out what emails were sent? I'm sure there's a log somewhere that shows what emails PHP processed...

I'm running into a situation where folks are saying they didn't get the email - when I'm pretty sure the emails was sent....

[djjjozsi]

i suggest make an admin page, to re-send the email activation from the database.

But, do not send the emails in one cycle. And check the mail success after send, and update a last_activate_email field.

You can use a date field to know which account overstepped the activation time interval.

Hello, jjozsi.