Double Opt-In Registration and Login

[inuwolf]

Hi. I'm looking for your standard PHP MySQL login system, but I need one that sends the registree an email with a confirmation link they must follow to complete their registration. I've Googled this extensively, but all the scripts that support confirmation emails are far more complicated than I need (vSignup was a great system but it offered too many features, eg, heirarchical user groups.) Anyone have or know where I can find a script for a simple PHP MySQL login with confirmation emails? (If you can't post the link, sticky me.)

While I'm on that note: I'd also like to have the session terminate as soon as the user closes the page, to eliminate the need for a logout button(obviously I'm trying to keep this as simple as possible). Anyone have a script for this?

Thanks. I really appreciate all the pointers I've been given since I got here.

[HughMungus]

Are you using a database? If so, what's hard about using php's mail function and a link to a page that updates a field in the database to indicate that they did click on the link in the email?

e.g.

1. User enters info and submits.

2. Form submit page sends an mail to user with a link that's something like:

...www.yoursite.com/confirm.php?email=[e-mail]

3. User gets email and clicks the link that goes to confirm.php which updates the database based on their email address and voila, they're opted in.

[inuwolf]

...nothing. Thanks!
(I began learning PHP yesterday)

[HughMungus]

Well, all you need to learn is how to use the mail function (easy) and how to update a database with a php page and query string (easy).