I hope that the following code help you, is a registration and activation page, its very simple and self explanatory, if you dont understand something please send me a PM.
<?php
/**
* Generate an activation code
* @param int $length is the length of the activation code to generate
* @return string
*/
function generateCode($length = 10)
{
$password="";
$chars = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890";
srand((double)microtime()*1000000);
for ($i=0; $i<$length; $i++)
{
$password .= substr ($chars, rand() % strlen($chars), 1);
}
return $password;
}
// config file with database info (db, host, user, password) and connection functions.
require("config.php");
?>
<HTML>
<HEAD>
<TITLE>Registration www.gigasoft.astahost.com</TITLE>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<style type="text/css">
body {
background-color:#131313;
font-family:Verdana, Arial;
font-weight:bold;
font-size:9px;
color:#FFFFFF;
}
.register_box {
border: 1px solid #323232;
background-color: #202020;
font-family: Verdana, Arial;
font-weight: bold;
font-size: 9px;
color: #FFFFFF;
}
</style>
</head>
<body>
<?php
$action = (isset($_REQUEST['action'])) ? $_REQUEST['action'] : "new";
switch($action) {
//--------------------------------------
// [New Registration]
//--------------------------------------
case "new":
if(!isset($_POST['register'])) {
echo "
<form action='registration.php' method='POST'>
Name: <br />
<input type='text' name='name' class='register_box'>
<br />
Email: <br />
<input type='text' name='email' class='register_box'>
<br />
Nickname: <br />
<input type='text' name='nickname' class='register_box'>
<br />
Password: <br />
<input type='password' name='password' class='register_box'>
<br />
<input type='submit' name='register' value='New Registration!' class='register_box'>
<input type='hidden' name='action' value='new'>
</form>";
}
elseif(isset($_POST['register'])) {
$name = mysql_real_escape_string($_POST['name']);
$email = mysql_real_escape_string($_POST['email']);
$nickname = mysql_real_escape_string ($_POST['nickname']);
$password = mysql_real_escape_string($_POST['password']);
$activation_code = generateCode(25);
$nameq = "SELECT name FROM registration WHERE name = '$name'";
$emailq = "SELECT email FROM registration WHERE email = '$email'";
$nickq = "SELECT nickname FROM registration WHERE nickname = '$nickname'";
//put errors into an array I need to change these if I change the db
$errors = array();
if(empty($name)) {
$errors[] = "The name field was blank! <br />";
}
$reg=mysql_query($nameq) or die(mysql_error());
if(mysql_num_rows($reg) > 0) {
$errors[] = "The name given is already in use! Please try another one! <br />";
}
if(empty($email)) {
$errors[] = "The email field was blank! <br />";
}
$reg=mysql_query($emailq) or die(mysql_error());
if(mysql_num_rows($reg) > 0) {
$errors[] = "The email given is already in use! Please try another one! <br />";
}
if(empty($nickname)) {
$errors[] = "The nickname field was blank! <br />";
}
$reg=mysql_query($nickq) or die(mysql_error());
if(mysql_num_rows($reg)>0) {
$error[] = "That nickname is already taken. Please try another one.<br />";
}
if(empty($password)) {
$errors[] = "The password field was blank! <br />";
}
if(count($errors) > 0) {
foreach($errors as $err) {
echo $err;
}
}
else {
$sqlq = "INSERT INTO registration (name, email, nickname, password, is_activated, activation_code)";
$sqlq .= " VALUES ('$name', '$email', '$nickname', '".md5($password)."', '0', '$activation_code')";
mysql_query($sqlq) or die(mysql_error());
echo "Thanks for registering! You will recieve an email shortly containing your validation code, and a link to activate your account!";
mail($email, "New Registration, www.gigasoft.astahost.com", "Thanks for registering on TRIVIA at GIGASOFT.\n\nHere are your login details:\n\nNickname: ".$nickname."\n\nPassword: ".$password."\n\nIn order to login and gain full access, you must validate your account.\n\nClick here to validate:\n\nhttp://www.gigasoft.astahost.com/trivia/registration.php?action=activate&nickname=".$nickname."&code=".$activation_code."\n\nThanks!\n\n[TavoXPerU]");
}
}
break;
case "activate":
//--------------------------------------
// [Activate Account]
//--------------------------------------
if(isset($_GET['nickname']) && isset($_GET['code'])) {
$nickname = mysql_real_escape_string($_GET['nickname']);
if(mysql_num_rows(mysql_query("SELECT email FROM registration WHERE nickname = '$nickname'")) == 0) {
echo "That username is not in the database!";
}
else {
$activate_query = "SELECT is_activated FROM registration WHERE nickname = '$nickname'";
$is_already_activated = mysql_fetch_object(mysql_query($activate_query)) or die(mysql_error());
if($is_already_activated->is_activated == '1') {
echo "This user is already activated!";
}
else {
$code = mysql_real_escape_string($_GET['code']);
$code_query = "SELECT activation_code FROM registration WHERE nickname = '$nickname' LIMIT 1";
$check_code = mysql_fetch_object(mysql_query($code_query)) or die(mysql_error());
if($code == $check_code->activation_code) {
$update = "UPDATE registration SET is_activated='1', regdate=NOW(), last_login=NOW() WHERE nickname = '$nickname'";
mysql_query($update) or die(mysql_error());
echo "User $nickname has been activated! Thanks!";
echo "<br />Please <a href=\"login.php\">Click here to Login</a> and enter the site.";
}
else {
echo "The activation code was wrong! Please try again!";
}
}
}
}
else {
echo "No ID or user given to activate!";
}
break;
}
?>
</body>
</html>
