In this article, you will learn How to Create Email Verification Script in PHP.
user_registration table
CREATE TABLE IF NOT EXISTS `user_registration` (
`id` int(11) NOT NULL,
`name` varchar(255) NOT NULL,
`email` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
`activationcode` varchar(255) NOT NULL,
`status` int(11) NOT NULL,
`postingdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;index.php
<html>
<head>
<title>Registration</title>
</head>
<body>
<form name="insert" action="insert.php" method="post">
<table width="100%" border="0">
<tr>
<th height="62" scope="row">Name </th>
<td width="71%"><input type="text" name="name" id="name" value="" class="form-control" required /></td>
</tr>
<tr>
<th height="62" scope="row">Email id </th>
<td width="71%"><input type="email" name="email" id="email" value="" class="form-control" required /></td>
</tr>
<tr>
<th height="62" scope="row">Password </th>
<td width="71%"><input type="password" name="password" id="password" value="" class="form-control" required /></td>
</tr>
<tr>
<th height="62" scope="row"></th>
<td width="71%"><input type="submit" name="submit" value="Submit" class="btn-group-sm" /> </td>
</tr>
</table>
</form>
</body>
</html>insert.php
<?php
include_once("config.php");
if(isset($_POST['submit']))
{
$name=$_POST['name'];
$email=$_POST['email'];
$password=md5($_POST['password']);
$status=0;
$activationcode=md5($email.time());
$query=mysqli_query($con,"insert into user_registration(name,email,password,activationcode,status) values('$name','$email','$password','$activationcode','$status')");
if($query)
{
$to=$email;
$msg= "Thanks for new Registration.";
$subject="Email verification (huboftutorials.com)";
$headers .= "MIME-Version: 1.0"."\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1'."\r\n";
$ms.="<html></body><div><div>Dear $name,</div></br></br>";
$ms.="<div style='padding-top:8px;'>Please click The following link For verifying and activation of your account</div>
<div style='padding-top:10px;'><a href='http://www.huboftutorials.com/verification.php?code=$activationcode'>Click Here</a></div>
</div>
</body>
</html>";
mail($to,$subject,$ms,$headers);
echo "<script>alert('Registration successful, please verify in the registered Email-Id');</script>";
echo "<script>window.location = 'login.php';</script>";;
}
else
{
echo "<script>alert('Data not inserted');</script>";
}
}
?>verification.php
<?php
include 'config.php';
if(!empty($_GET['code']) && isset($_GET['code']))
{
$code=$_GET['code'];
$sql=mysqli_query($con,"SELECT * FROM user_registration WHERE activationcode='$code'");
$num=mysqli_fetch_array($sql);
if($num>0)
{
$st=0;
$result =mysqli_query($con,"SELECT id FROM user_registration WHERE activationcode='$code' and status='$st'");
$result4=mysqli_fetch_array($result);
if($result4>0)
{
$st=1;
$result1=mysqli_query($con,"UPDATE user_registration SET status='$st' WHERE activationcode='$code'");
$msg="Your account is activated";
}
else
{
$msg ="Your account has already activated, no need to activate again";
}
}
else
{
$msg ="Wrong activation code.";
}
}
?>login.php
<html>
<head>
<title>Login</title>
</head>
<body>
<form name="insert" action="" method="post">
<font color="#FF0000"><?php echo $_SESSION['action1']; ?><?php echo $_SESSION['action1']="";?></font>
Email id
<input type="email" name="email" id="email" value="" class="form-control" required />
Password
<input type="password" name="password" id="password" value="" class="form-control" required />
<input type="submit" name="login" value="Submit" class="btn-group-sm" />
</form>
</body>
</html>