03-Apr-2023
.
Admin
Hi friends,
This tutorial is focused on How to Register with Email Verification in PHP Example. if you have question about User Registration with Email Verification in PHP then I will give simple example with solution. let’s discuss about PHP Registration Script with Email Confirmation. it's simple example of example of Registration with Email Verification in PHP MySQL.
This article will give you a simple example of Login and Signup Form with Email Verification using PHP & MySQL. We will use the simple example of creating PHP and MySQL User Registration with Email Verification.
I will give you a simple example of How to Implement Email Verification for New Members.
So, let's see bellow solution:
connection.php
<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "aatman";
$conn = new mysqli($servername,$username,$password,$dbname);
if($conn->connect_error){
die ('connection faild:'.$conn->connect_error);
}
?>
create table
CREATE TABLE user (
fullName VARCHAR(50) NOT NULL,
username VARCHAR(255) NOT NULL,
email VARCHAR(255) NOT NULL,
password VARCHAR(50) NOT NULL,
verification_id VARCHAR(255) NOT NULL,
verification_status INT(3) NOT NULL,
);
index.php
<?php
session_start();
require ('connection.php');
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>How to Register with Email Verification in PHP Example</title>
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/css/bootstrap.min.css" rel="stylesheet">
<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.6.0/jquery.min.js"></script>
</head>
<body class="bg-dark">
<div class="container-fluid mt-3">
<div class="card" style="height:590px;">
<div class="card-header text-center">
<h1>How to Register with Email Verification in PHP Example - Nicesnippets.com</h1>
</div>
<div class="card-body">
<nav class="navbar navbar-expand-lg navbar-light bg-light">
<a class="navbar-brand " href="#">Aatmaninfo</a>
<div class="collapse navbar-collapse" id="navbarSupportedContent">
<ul class="navbar-nav me-auto mb-2 mb-lg-0">
<li class="nav-item">
<a class="nav-link" href="#">Home</a>
</li>
<li class="nav-item">
<a class="nav-link" href="#">about us</a>
</li>
<li class="nav-item">
<a class="nav-link" href="#">contect us</a>
</li>
</ul>
</div>
<form class="justify-content-end">
<?php
if (isset($_SESSION['logged_in']) && $_SESSION['logged_in']==TRUE) {
echo $_SESSION['email']." - <a href='logout.php' class='btn btn-danger'>LOGOUT</a>";
}else{
echo "<button type='button' class='btn btn-success m-1' data-bs-toggle ='modal' data-bs-target='#loginModal'>Login</button>
<button type='button' class='btn btn-danger m-1' data-bs-toggle='modal' data-bs-target='#RegisterModal'>Register</button>";
}
?>
</form>
</nav>
<?php
if (isset($_SESSION['logged_in']) && $_SESSION['logged_in']==TRUE) {
echo "<h1 class='text-center mt-5 pt-5'>Welcom to this website</h1>";
}
?>
</div>
</div>
<div class="modal fade" id="loginModal">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<h3 class="modal-title" id="loginModalLabel">Login</h3>
<button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
</div>
<form action="registration.php" method="post">
<div class="modal-body">
<div class="mb-3">
<label>Email : </label>
<input type="text" name="email_username" class="form-control" placeholder="Email">
</div>
<div class="mb-3">
<label>Password : </label>
<input type="password" name="password" class="form-control" placeholder="Password">
</div>
</div>
<div class="modal-footer">
<input type="submit" name="login" class="btn btn-primary">
<button type="button" class="btn btn-danger" data-bs-dismiss="modal">Close</button>
</div>
</form>
</div>
</div>
</div>
<div class="modal fade" id="RegisterModal">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<h3 class="modal-title" id="RegisterModalLabel">Register</h3>
<button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
</div>
<form action="registration.php" method="post">
<div class="modal-body">
<div class="mb-3">
<label>Full Name : </label>
<input type="text" name="fullName" class="form-control" placeholder="Full Name">
</div>
<div class="mb-3">
<label>User Name : </label>
<input type="text" name="username" class="form-control" placeholder="User Name">
</div>
<div class="mb-3">
<label>Email : </label>
<input type="email" name="email" class="form-control" placeholder="Email">
</div>
<div class="mb-3">
<label>Password : </label>
<input type="password" name="password" class="form-control" placeholder="Password">
</div>
</div>
<div class="modal-footer">
<input type="submit" name="register" class="btn btn-primary">
<button type="button" class="btn btn-danger" data-bs-dismiss="modal">Close</button>
</div>
</form>
</div>
</div>
</div>
</div>
</body>
</html>
download this file : PHPMailer
registration.php
<?php
require ('connection.php');
session_start();
use PHPMailer\PHPMailer\PHPMailer;
use PHPMailer\PHPMailer\SMTP;
use PHPMailer\PHPMailer\Exception;
function sendmail($email,$v_cod){
require ('PHPMailer-master/src/PHPMailer.php');
require ('PHPMailer-master/src/Exception.php');
require ('PHPMailer-master/src/SMTP.php');
$mail = new PHPMailer(true);
try {
$mail->SMTPDebug = SMTP::DEBUG_SERVER;
$mail->isSMTP();
$mail->Host = 'smtp.gmail.com';
$mail->SMTPAuth = true;
$mail->Username = 'your email @gmail.com';
$mail->Password = 'your password';
$mail->SMTPSecure = PHPMailer::ENCRYPTION_SMTPS;
$mail->Port = 465;
$mail->setFrom('your email @gmail.com', 'sender name');
$mail->addAddress($email);
$mail->isHTML(true);
$mail->Subject = 'email verification from aatmaninfo';
$mail->Body = "Thanks for registration.<br>click the link bellow to verify the email address
<a href='http://localhost:8000/post-email/verify.php?email=$email&v_cod=$v_cod'>verify</a>";
$mail->send();
return true;
} catch (Exception $e) {
return false;
}
}
if (isset($_POST['login'])) {
$email_username =$_POST['email_username'];
$password_login =$_POST['password'];
$sql="SELECT * FROM user WHERE email = '$email_username' AND password = '$password_login' AND verification_status = '1'";
$result = $conn->query($sql);
if ($row = $result->fetch_assoc()) {
$_SESSION['logged_in']=TRUE;
$_SESSION['email']=$row['email'];
header('location:index.php');
}else{
echo "
<script>
alert('please verify your email!!');
window.location.href='index.php'
</script>";
}
}
if (isset($_POST['register'])) {
$fullName =$_POST['fullName'];
$username =$_POST['username'];
$email =$_POST['email'];
$password =$_POST['password'];
$user_exist_query="SELECT * FROM user WHERE username= '$username' AND email = '$email' ";
$result = $conn->query($user_exist_query);
if ($result) {
if ($result->num_rows > 0) {
$row = $result->fetch_assoc();
if ($row['username'] === $username && $row['email'] === $email) {
echo "
<script>
alert('username alredy taken!');
window.location.href='index.php'
</script>";
}else{
echo "
<script>
alert('email alredy register');
window.location.href='index.php'
</script>";
}
}else{
$v_cod=bin2hex(random_bytes(16));
$query ="INSERT INTO `user`(`fullName`, `username`, `email`, `password`,`verification_id`, `verification_status`) VALUES ('$fullName','$username','$email','$password','$v_cod','0')";
if (($conn->query($query)===TRUE) && sendmail($email,$v_cod )===TRUE) {
echo "
<script>
alert('register successful.chack your mailbox in inbox or spam and verify your account.');
window.location.href='index.php'
</script>";
}else{
echo "
<script>
alert('query can not run');
window.location.href='index.php'
</script>";
}
}
}else{
echo "
<script>
alert('query can not run');
window.location.href='index.php'
</script>";
}
}
?>
verify.php
<?php
require ('connection.php');
if (isset($_GET['email']) && isset($_GET['v_cod'])) {
$email = $_GET['email'];
$v_cod = $_GET['v_cod'];
$sql="SELECT * FROM user WHERE email = '$email' AND verification_id = '$v_cod'";
$result = $conn->query($sql);
if ($result) {
if ($result->num_rows == 1) {
$row = $result->fetch_assoc();
$fetch_Email = $row['email'];
if ($row['verification_status'] == 0) {
$update = "UPDATE user SET verification_status='1' WHERE email = '$fetch_Email'";
if ($conn->query($update)===TRUE) {
echo "
<script>
alert('verification successful');
window.location.href='index.php'
</script>";
}else{
echo "
<script>
alert('query can not run');
window.location.href='index.php'
</script>";
}
}else{
echo "
<script>
alert('email alredy register');
window.location.href='index.php'
</script>";
}
}
}
}else{
echo "
<script>
alert('server down!!');
window.location.href='index.php'
</script>";
}
?>
logout.php
<?php
session_start();
session_unset();
session_destroy();
header("location:index.php");
?>
Output:
Registration Page
Login page
.png)
Home page
.png)
It will help you...
#PHP
