New User Registration With Email Verification Using PHP and Mysqli

02 November, 2015

New User Registration With Email Verification Using PHP and Mysqli

In this tutorial, we are going to see how to implement New user registration with email verification script. if you're using register form in a website, you need to use email verification because it will reduce spam register user and make sure you will get a correct registered user on your website.

Live Demo Download

Database

Create sample table called as 'users' and create columns that table.

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(100) NOT NULL,
  `name` varchar(250) NOT NULL,
  `password` varchar(250) NOT NULL,

  `status` enum('0','1') NOT NULL DEFAULT '0',
  `active_code` varchar(300) NOT NULL,
  PRIMARY KEY (`id`)
)

Database connection(config.php)

<?php  
   $user = 'root'; 
   $password = ''; 
   $database = 'mostlikers'; 
   $db = new mysqli('localhost',$user,$password,$database); 
 ?>

HTML

Create simple form element

<html>
<body>
  <form method="post">                          
  <label>Email *</label>
  <input type="text" name="email">
  <label>Password *</label>
  <input type="password" name="password">    
  <input type="submit" id="btn-login" value="Submit" name="form_submit">
  <div class="<?=(@$msg_sucess=="") ? 'error' : 'green' ; ?>">
  <?php echo @$msg; ?><?php echo @$msg_sucess; ?>
  </div> 
  </form> 
</body>
</html>

Index.php

Contain the form email value to check email id exist or not. if post email id not exists activate URL will generate to send via email.

<?php
include("config.php");
if(isset($_POST['form_submit']))
{  
  extract($_POST);
  if($email!="" && $password!="") :
    $email=mysqli_real_escape_string($db,$email);
    $pwd=md5(mysqli_real_escape_string($db,$password));
    $emailval = '/^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,4})$/';    
    if(preg_match($emailval, $email)) :
      $db_check=$db->query("SELECT * FROM `users` WHERE email='$email'");
      $count=mysqli_num_rows($db_check);
      if($count< 1) :         
         $active_code=md5($email.time());
         $link = 'http://demos.mostlikers.com/php-email-verification/
         verify.php?key='.$active_code;         
         $fetch=$db->query("INSERT INTO users(email,password,active_code)
          VALUES('$email','$pwd','$active_code')");
         $to="$email"; //change to ur mail address 
         $reply = 'karthicktech77@gmail.com';
         $strSubject="Mostlikers | Email Verification";
         $message = '<p>Hi there!, <br/> Please verify your email
           get activate your account.</p>' ;              
         $message .= '<p>Click here : <a href="'.$link.'">'.$link.'</p>' ;              
         $headers = 'MIME-Version: 1.0'."\r\n";
         $headers .= 'Content-type: text/html; charset=iso-8859-1'."\r\n";
         $headers .='Reply-To: '. $reply . "\r\n" ;
         $headers .= "Bcc: karthicktech77@gmail.com\r\n";
         $headers .= "From:Mostlikers info@mostlikers.com";         
         $mail_sent=mail($to, $strSubject, $message, $headers);  
         $msg_sucess="Registration has been successfully, Please verify your email.
         Check your inbox.The email may delay by few seconds, else check your spam or
         junk list.";
      else :
        $msg="This $email email address is already verified.";
      endif;  
    else :
      $msg="Please enter your valid email id";
    endif;      
  else : 
    $msg="Please fill all mandatory fields";
  endif;
unset($_POST);
}
?>

$link - Email verification url link.
mail() - Php mailer functions

Verify.php

Contains PHP code users status will update to table 0 - inactive to 1- active

<?php 
include("config.php");
if(@$_GET['key']!=""):
    $active_code=mysqli_real_escape_string($db,$_GET['key']);
    $fetch=$db->query("SELECT * FROM `users` WHERE `active_code` = '$active_code'");
    $count=mysqli_num_rows($fetch);
    if($count==1) :
      $row=mysqli_fetch_array($fetch);
      $user_id = $row['id']; 
      if($row['status']=='0'):
        $db->query("UPDATE users SET status ='1' WHERE id='$user_id'");
        $msg="Your account is activated successfully.";
      else :
        $msg="Your account has been already activated.";
      endif;
    else :
      $msg="Wrong activation code. Check your email activate again";
    endif;
else :
    header("Location:404.php");
endif;
echo $msg;
?>

Have a Question? Share your query by writing a comment below.

"The bird is powered by its own life and by its motivation. "

- A. P. J. Abdul Kalam

Menu Link

02 November, 2015