Posted by Stefan Rybacki on 07/21/05 23:05

Johan wrote:
> I am using a mysql db
>

>

So what about this:

emails are stored in a database.
say the table holding the emails contains the following columns:

id, email, activationkey, sent, activated, senttime

in your php script that sends activation emails (e.g. sendactivationmails) you just get
all emails that are not already sent and those that are sent but not activated after a while.
Now you send your activation emails to each retrieved email with an activation key (you
create before sending e.g. by calling $key=md5(time().$email.random data); and the id
attached to a link like this:

http://www.foobar.com/activateemail.php?id=$id&key=$key

after successfully sending the email you update the activationkey and the senttime in your
database.


the second script e.g. activateemail.php retrieves an id and a key, which you check in
your database and if they match you set the activated attribute.

Any questions?

Regards
Stefan

[Back to original message]