validate your account by clicking on a link in the email

[runnerjp]

hey guys i have a registration page and what  whant to do is make it so users have to validate an account by clicking on a link in the email like you see on most sites.

 

 

how would i do this??

[flappy_warbucks]

what i would do is give the user a unique reference number and save that into a SQL database.

 

then i would make a page called validate.php and have a link in the email pointing to that page, for example:

 

www.mysite.com/validate.php?v=unique_ref_num

 

that way u can lift the code from the address mar, and compare that to the SQL, if they have clicked the link and the two match up (i.e. the link address and the SQL) then you know the email address is valid.

[runnerjp]

that a good idea...BUT... sounds complex lol gotta figure out how to do all that :|

[flappy_warbucks]

You could include a valid column in your database, and just set that to 1 (or true) where the UIN is.

 

$UIN = $_REQUEST['V'];

include "database.php";

$QUERY = "UPDATE USER_ACCOUNTS SET VALID=1 WHERE $UIN='V'";
$MYSQL_QUERY($QUERY);

[flappy_warbucks]

You could include a valid column in your database, and just set that to 1 (or true) where the UIN is.

 

$UIN = $_REQUEST['V'];

include "database.php";

$QUERY = "UPDATE USER_ACCOUNTS SET VALID=1 WHERE $UIN='$UIN'";
$MYSQL_QUERY($QUERY);

 

sorry my muistake V should be $UIN in the query my bad

[runnerjp]

iu will have a go at it ty