E-Mail confirmation on Login System Registration?

[lopes_andre]

Hi,

 

I need to implement an E-Mail confirmation system on the actual login system registration.

 

I don't have sure on how to do it, please give me some clues.

 

My actual users table is like this:

CREATE TABLE `users` (
`UserID` INT(25) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`Username` VARCHAR(65) NOT NULL ,
`Password` VARCHAR(32) NOT NULL ,
`EmailAddress` VARCHAR(255) NOT NULL
);

 

I'am thinking in send an e-mail with a link to the user activate their account.

 

My question... How to implement a system like that?

 

I will have to create a field "Active" the values should be "0" for Inactive and "1" for Active. But how to generate a key to send by URL to the user activate?

 

PS: Please tell me if I don't explained well, my english is poor.

 

Best Regards,

André.

[Daniel0]

Not really that much related to MySQL specifically...

 

To create a random string you can just do e.g. md5(microtime()); or you could write a function:

function generateRandomString($length = 50)
{
$chars = array_merge(range('a', 'z'), range(0, 9));
$charsMax = count($chars);

$string = null;
for ($i = 0; $i < $length; $i++) {
	$string .= $chars[rand(0, $charsMax)];
}

return $string;
}

 

Anyway, just create a two fields: is_activated (tinyint(1) default 0) and activation_code (char (length=whatever you want))

 

So put the activation code in the row and send the code to their email. Then they can verify using that and you can set is_activated to 1. When logging in you just need to check if is_activated=1.

[lopes_andre]

Thanks for your reply.

 

Best Regards, André.

[lopes_andre]

I will need also to implement an "Password Forgotten System". My passwords are MD5 encrypted... How to implement a Password Forgottem System with MD4 Passwords?

 

Best Regards, André.

[Daniel0]

Just generate a new one and send them the new password. Hashing algorithms are one-way so it's impossible to get the plaintext value without brute-force.