Posted by "bruce" on 09/25/26 11:26

jim...

pretty much what i had thought about... question.. how does one correctly!!!
set up a cron process...

i assume that i can write a quick perl/php app that iterates through the
'emailconfirmTBL' looking at the date, and the confirm status. if the
cleanup app sees any records that are over a certain age, and haven't been
confirmed, it can simply delete the record. but shouldn't the cleanup also
do a rollback/delete of the user registration records as well...

this kind of approach would lend itself to being monitored by an admin who
could then look to see where in the process a given user is/was...

any good/quick guides you can point me to!

thanks

-bruce


-----Original Message-----
From: Jim Moseby [mailto:JMoseby@nrbindustries.com]
Sent: Monday, September 12, 2005 8:56 AM
To: 'bedouglas@earthlink.net'; php-general@lists.php.net
Subject: RE: [PHP] confirmation email script/code


> has anybody come across a really good 'open source' chunk of code for
> sending/recieving confirmation emails from an app... i'd like
> to allow the
> user to register, and send them an email that they then have
> to hit the link
> to complete the process..

It is strightforward to write this yourself. In my simple example, I
generate a 32 byte random ID when the user registers and save it along with
his data in the DB. Then, I send him an email with a link like this:

www.example.com/register.php?id=7H7dh869ha320J6GhAs89L0lJ00j09df?action=conf
irm

When he clicks the link, I flip a flag in his DB record that he has
confirmed.

I have cron periodically go and clean up unconfirmed records that have timed
out.

JM

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[Back to original message]