<form action=”” method=”post”>
\n<label>Email<\/label>
\n<input type=”text” name=”email”font-family: inherit; font-style: inherit; border: 0px none; outline: 0px; padding: 0px; margin: 0px; color: blue;”>input” autocomplete=”off”\/>
\n<label>Password\u00a0<\/label>
\n<input type=”password” name=”password”font-family: inherit; font-style: inherit; border: 0px none; outline: 0px; padding: 0px; margin: 0px; color: blue;”>input” autocomplete=”off”\/><br\/>
\n<input type=”submit”font-family: inherit; font-style: inherit; border: 0px none; outline: 0px; padding: 0px; margin: 0px; color: blue;”>button” value=”Registration” \/>
\n<span class=’msg’>
<?php<\/b>\u00a0echo\u00a0$msg;\u00a0?><\/b><\/span>
\n<\/form><\/div>\ndb.php<\/b>
\nDatabase configuration file, modify username, password, database and base url values.<\/p>\n<?php<\/b>
\ndefine(‘DB_SERVER’, ‘localhost’);
\ndefine(‘DB_USERNAME’, ‘username’);
\ndefine(‘DB_PASSWORD’, ‘password’);
\ndefine(‘DB_DATABASE’, ‘database’);
\n$connection =@mysqli_connect(DB_SERVER,DB_USERNAME,DB_PASSWORD,DB_DATABASE);
\n$base_url=’http:\/\/www.youwebsite.com\/email_activation\/’;
\n?><\/b><\/div>\nindex.php<\/b>
\nContains PHP code, storing user registration values into\u00a0users\u00a0table. Here activation code generation using\u00a0MD5\u00a0encryption.<\/p>\n<?php<\/b>
\ninclude\u00a0‘db.php’;
\n$msg=”;
\nif(!empty($_POST[’email’])\u00a0&&\u00a0isset($_POST[’email’])\u00a0&&\u00a0!empty($_POST[‘password’])\u00a0&&\u00a0\u00a0isset($_POST[‘password’]) )
\n{
\n\/\/ username and password sent from form
\n$email=mysql_real_escape_string($_POST[’email’]);
\n$password=mysql_real_escape_string($_POST[‘password’]);
\n\/\/ regular expression for email check
\n$regex = ‘\/^[_a-z0-9-]+(\\.[_a-z0-9-]+)*@[a-z0-9-]+(\\.[a-z0-9-]+)*(\\.[a-z]{2,4})$\/’;if(preg_match($regex, $email))
\n{
\n$password=md5($password);\u00a0\/\/ encrypted password
\n$activation=md5($email.time());\u00a0\/\/ encrypted email+timestamp
\n$count=mysqli_query($connection,”SELECT uid FROM users WHERE email=’$email'”);
\n\/\/ email check
\nif(mysqli_num_rows($count) < 1)
\n{
\nmysqli_query($connection,”INSERT INTO users(email,password,activation) VALUES(‘$email’,’$password’,’$activation’)”);
\n\/\/ sending email
\ninclude\u00a0‘smtp\/Send_Mail.php’;
\n$to=$email;
\n$subject=”Email verification”;
\n$body=’Hi, <br\/> <br\/> We need to make sure you are human. Please verify your email and get started using your Website account. <br\/> <br\/> <a href=”‘.$base_url.’activation\/’.$activation.'”>’.$base_url.’activation\/’.$activation.'<\/a>’;<\/p>\nSend_Mail($to,$subject,$body);
\n$msg= “Registration successful, please activate email.”;
\n}
\nelse
\n{
\n$msg= ‘The email is already taken, please try new.’;
\n}<\/p>\n
}
\nelse
\n{
\n$msg = ‘The email you have entered is invalid, please try again.’;
\n}<\/p>\n
}
\n\/\/ HTML Part
\n?><\/b><\/p>\n<\/div>\n
Send_Mail.php<\/b>
\nSending email function, just modify SMTP host, username and password.<\/p>\n<?php<\/b>
\nfunction<\/b>\u00a0Send_Mail($to,$subject,$body)
\n{
\nrequire\u00a0‘class.phpmailer.php’;
\n$from \u00a0 \u00a0 \u00a0 = “from@yourwebsite.com”;
\n$mail \u00a0 \u00a0 \u00a0 = new PHPMailer();
\n$mail->IsSMTP(true); \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\/\/ use SMTP
\n$mail->IsHTML(true);
\n$mail->SMTPAuth \u00a0 = true; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\/\/ enable SMTP authentication
\n$mail->Host \u00a0 \u00a0 \u00a0 = “tls:\/\/smtp.yourwebsite.com”; \/\/ SMTP host
\n$mail->Port \u00a0 \u00a0 \u00a0 = \u00a0465; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\/\/ set the SMTP port
\n$mail->Username \u00a0 = “SMTP_Username”; \u00a0\/\/ SMTP \u00a0username
\n$mail->Password \u00a0 = “SMTP_Password”; \u00a0\/\/ SMTP password
\n$mail->SetFrom($from, ‘From Name’);
\n$mail->AddReplyTo($from,’From Name’);
\n$mail->Subject \u00a0 \u00a0= $subject;
\n$mail->MsgHTML($body);
\n$address = $to;
\n$mail->AddAddress($address, $to);
\n$mail->Send();
\n}
\n?><\/div>\nactivation.php<\/b>
\nContains PHP code, here based on activations code\u00a0user\u00a0status updating from\u00a00to\u00a01.<\/p>\n<?php<\/b>
\ninclude\u00a0‘db.php’;
\n$msg=”;
\nif(!empty($_GET[‘code’]) &&\u00a0isset($_GET[‘code’]))
\n{
\n$code=mysql_real_escape_string($_GET[‘code’]);
\n$c=mysqli_query($connection,”SELECT uid FROM users WHERE activation=’$code'”);if(mysqli_num_rows($c) > 0)
\n{
\n$count=mysqli_query($connection,”SELECT uid FROM users WHERE activation=’$code’ and status=’0<\/b>‘”);<\/p>\nif(mysqli_num_rows($count) == 1)
\n{
\nmysqli_query($connection,”UPDATE users SET status=’1’ WHERE activation=’$code'”);
\n$msg=”Your account is activated”;
\n}
\nelse
\n{
\n$msg =”Your account is already active, no need to activate again”;
\n}<\/p>\n
}
\nelse
\n{
\n$msg =”Wrong activation code.”;
\n}<\/p>\n
}
\n?>
\n\/\/HTML Part
\n<?php<\/b>\u00a0echo\u00a0$msg;\u00a0?><\/b><\/p>\n<\/div>\n
Email Verification
\n<\/b>
\n.htaccess<\/b>
\nURL redirection script it turns
\nhttp:\/\/website.com\/activation.php?code=ACTIVATION_CODE
\nto
\nhttp:\/\/website.com\/activation\/ACTIVATION_CODE<\/p>\nRewriteEngine\u00a0OnRewriteRule\u00a0^activation\/([a-zA-Z0-9_-]+)$\u00a0activation.php?code=$1
\nRewriteRule\u00a0^activation\/([a-zA-Z0-9_-]+)\/$\u00a0activation.php?code=$1<\/p>\n<\/div>\n
CSS code<\/b><\/p>\nbody
\n{
\nfont-family: “Helvetica”,Arial,sans-serif;
\nfont-weight: 500;
\ncolor:#333;
\n}
\nlabel
\n{
\nwidth:100px;
\ndisplay:block;
\nfont-weight:bold;
\ncolor:#666666;
\n}
\n#main
\n{
\nmargin:0 auto;
\nwidth:800px;
\n}
\n.input
\n{
\npadding:10px;
\nfont-size:14px;
\nborder:1px solid #999999;
\nwidth:200px;
\nmargin-bottom:10px;
\n}
\n.button\u00a0{
\npadding:10px;
\nbackground-color: #5fcf80 !important;
\nborder-color: #3ac162 !important;
\n}
\n.msg
\n{
\nfont-size:11px;
\ncolor:#666;
\npadding:10px;
\n}<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"
How to implement email verification system using PHP. This is very basic tutorial explained how to create database and proper activation code. Implemented with mysqli_() fuctions, because mysql_() functions are depreciated. Database Sample database\u00a0users\u00a0table contains four columns uid, email, password, activation and status. CREATE TABLE IF NOT EXISTS `users` ( `uid`\u00a0int(11) NOT NULL\u00a0AUTO_INCREMENT, `email`\u00a0varchar(300) NOT […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0},"categories":[30,7],"tags":[],"_links":{"self":[{"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/posts\/512"}],"collection":[{"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/comments?post=512"}],"version-history":[{"count":0,"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/posts\/512\/revisions"}],"wp:attachment":[{"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/media?parent=512"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/categories?post=512"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/a1webdesignteam.com\/blog\/wp-json\/wp\/v2\/tags?post=512"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}