<?php
// Function checks
function emailChecker($email){
	global $check_result; // Make our result able to be used anywhere from the script
	$check = "SELECT id FROM subscribers WHERE email = '$email'"; // Try to check the data against the database
	$check_result = mysql_query($check) or die(mysql_error()); // Query or kill the script and print error
	if(!mysql_num_rows($check_result))	return false; // If no results are found, return false
	else	return true; // Otherwise, return true
}
function verificationChecker($email, $code){
	global $check_result; // Make our result able to be used anywhere from the script
	$check = "SELECT id FROM subscribers WHERE email = '$email' AND verification_code = '$code'"; // Try to check the data against the database
	$check_result = mysql_query($check) or die(mysql_error()); // Query or kill the script and print error
	if(!mysql_num_rows($check_result))	return false; // If no results are found, return false
	else	return true; // Otherwise, return true
}

if(!$_POST){ // If no post data is present
	if(!$_GET['email'] && !$_GET['code']){ // If no email and code are awaiting validation, give the form
?>
Subscribe to our newsletter today!

<form method="POST" action="<?php echo $PHP_SELF; ?>">
	Email: <input type="text" name="email" size="40" />
	<input type="submit" value="Subscribe!" />
</form>
<?php
	}
	else{ // Otherwise, validate the email and code given by the link
		$email = trim($_GET['email']); // Get the email
		$code = trim($_GET['code']); // Get the code
		if(!emailChecker($email)){ // Check if email is even awaiting validation
			echo 'Error! Email Not Subscribed!This email has not been signed up for verification.'; // Echo the problem
		}
		elseif(!verificationChecker($email, $code)){ // Then check if the code matches
			echo 'Error! Invalid Verification Code!Incorrect verification code.'; // Echo the problem
		}
		else{ // Otherwise, go ahead and verify the email
			require('connect.php'); // Connect to the database
			$id = mysql_result($check_result, 0, 'id'); // Get the id from our result in our checker functions
			$verify_email = "UPDATE subscribers SET verified='TRUE' WHERE id = '$id'"; // Set the verified field to true
			$result = mysql_query($verify_email) or die(mysql_error()); // Query or kill the script and print error
			mysql_close(); // Close the database connection
			echo 'Email Validated!Your email has been verified by email You are now verified as a member!'; // Echo successful verification!
		}
	}
}
else{ // Otherwise, if there IS post data
	require('connect.php'); // Connect to the database
	function randomCode(){ // Random code function I found from a random zite =P
		$alphabet = "abcdefghijklmnopqrstuvwxyzZ0123456789";
		srand((double)microtime()*100000);
		$i = 0; // Set $i for the loop
		while($i <= 7){
			$num = rand() % 27;
			$a_Rand = substr($alphabet, $num, 1);
			$security = $security.$a_Rand;
			$i++;
		}
		return $security;
	}
	$email = trim($_POST['email']); // Get the email address
	$subject = 'Email Verification'; // Give a subject so the person knows what this email is about
	$message = 'Thank you for your subscription request! To subscribe, simply click the link provided below.'; // Give some instructions as to what this is
	$verification_code = randomCode().randomCode(); // Generate the random code twice, and string it together
	$insert_unverified = "INSERT INTO subscribers VALUES(NULL, '$email', '$verification_code', 'FALSE')"; // Insert email and code into database
	mysql_query($insert_unverified) or die(mysql_error()); // Query or kill the script
	$message .= "\nhttp://yoursite.com/subscribe.php?email=".$sendto.'&code='.$verification_code; // Give the link for the person to verify their account
	mysql_close(); // Close the database connection
	
	mail($sendto, $subject, $message); // Send the email!
	
	echo 'A confirmation email has been sent to your email. Simply click the link in the email to verify your account.'
}

<?php
// Function checks
function emailChecker($email){
	global $check_result; // Make our result able to be used anywhere from the script
	$check = "SELECT id FROM subscribers WHERE email = '$email'"; // Try to check the data against the database
	$check_result = mysql_query($check) or die(mysql_error()); // Query or kill the script and print error
	if(!mysql_num_rows($check_result))	return false; // If no results are found, return false
	else	return true; // Otherwise, return true
}
function verificationChecker($email, $code){
	global $check_result; // Make our result able to be used anywhere from the script
	$check = "SELECT id FROM subscribers WHERE email = '$email' AND verification_code = '$code'"; // Try to check the data against the database
	$check_result = mysql_query($check) or die(mysql_error()); // Query or kill the script and print error
	if(!mysql_num_rows($check_result))	return false; // If no results are found, return false
	else	return true; // Otherwise, return true
}

if(!$_POST){ // If no post data is present

if(!$_GET['email'] && !$_GET['code']){ // If no email and code are awaiting validation, give the form

?>
Subscribe to our newsletter today!

<form method="POST" action="<?php echo $PHP_SELF; ?>">
Email: <input type="text" name="email" size="40" />
<input type="submit" value="Subscribe!" />
</form>

<?php
	}
	else{ // Otherwise, validate the email and code given by the link

$email = trim($_GET['email']); // Get the email
$code = trim($_GET['code']); // Get the code

if(!emailChecker($email)){ // Check if email is even awaiting validation
echo 'Error! Email Not Subscribed!This email has not been signed up for verification.'; // Echo the problem
}

elseif(!verificationChecker($email, $code)){ // Then check if the code matches
echo 'Error! Invalid Verification Code!Incorrect verification code.'; // Echo the problem
}

else{ // Otherwise, go ahead and verify the email
require('connect.php'); // Connect to the database
$id = mysql_result($check_result, 0, 'id'); // Get the id from our result in our checker functions
$verify_email = "UPDATE subscribers SET verified='TRUE' WHERE id = '$id'"; // Set the verified field to true
$result = mysql_query($verify_email) or die(mysql_error()); // Query or kill the script and print error
mysql_close(); // Close the database connection
echo 'Email Validated!Your email has been verified by email You are now verified as a member!'; // Echo successful verification!
}
}
}

require('connect.php'); // Connect to the database
function randomCode(){
$alphabet = "abcdefghijklmnopqrstuvwxyzZ0123456789";
srand((double)microtime()*100000);
$i = 0;
while($i <= 7) {
$num = rand() % 27;
$a_Rand = substr($alphabet, $num, 1);
$security = $security.$a_Rand;
$i++;
}
return $security;
}

$email = trim($_POST['email']); // Get the email address
$subject = 'Email Verification'; // Give a subject so the person knows what this email is about
$message = 'Thank you for your subscription request! To subscribe, simply click the link provided below.'; // Give some instructions as to what this is

$verification_code = randomCode().randomCode(); // Generate the random code twice, and string it together

$insert_unverified = "INSERT INTO subscribers VALUES(NULL, '$email', '$verification_code', 'FALSE')"; // Insert email and code into database
mysql_query($insert_unverified) or die(mysql_error()); // Query or kill the script

$message .= "\nhttp://yoursite.com/subscribe.php?email=".$sendto.'&code='.$verification_code; // Give the link for the person to verify their account
mysql_close(); // Close the database connection

mail($sendto, $subject, $message); // Send the email!
echo 'A confirmation email has been sent to your email. Simply click the link in the email to verify your account.'
}
?>