Detailed step-by-step analysis of implementing email verification login registration function in PHP

Detailed step-by-step analysis of implementing email verification login registration function in PHP

In modern Internet applications, email verification has become one of the common registration and login methods. As a widely used programming language, PHP provides us with many tools and methods to conveniently implement email verification functions. This article will introduce you in detail the steps to implement the email verification login registration function in PHP, and attach the corresponding code examples.

1. Registration module

1. Create database table
   First, we need to create a user table in the database to store user registration information. The structure of the table can include fields: id (user ID, primary key), email (email address, used as user name), password (password, stored encrypted password), status (activation status, used to identify whether the mailbox has been activated), etc. .
2. Registration page
   After the user enters their email address and password on the registration page, we need to save this information to the database. In the registration page, we can use HTML forms to collect user registration information, as shown below:

<form action="register.php" method="post">
    <input type="email" name="email" placeholder="请输入邮箱地址" required>
    <input type="password" name="password" placeholder="请输入密码" required>
    <input type="submit" value="注册">
</form>

3. Registration processing
   In the PHP file for registration processing (register.php) , we can connect to the database through PHP's mysqli extension, insert the user's registration information into the user table, and send the activation link to the user's mailbox. The following is a simple sample code:

<?php
// 连接数据库
$conn = new mysqli("localhost", "username", "password", "database");

// 检查连接是否成功
if ($conn->connect_error) {
    die("数据库连接失败: " . $conn->connect_error);
}

// 获取用户输入的注册信息
$email = $_POST['email'];
$password = $_POST['password'];

// 将注册信息插入到用户表中
$sql = "INSERT INTO users (email, password, status) VALUES ('$email', '$password', '0')";
if ($conn->query($sql) === TRUE) {
    // 发送激活链接到用户邮箱
    $activation_link = "http://yourwebsite.com/activate.php?email=$email";
    // 发送激活链接的代码略，可以通过 PHP 的邮件发送库实现

    echo "注册成功，请检查您的邮箱并激活账号！";
} else {
    echo "注册失败：" . $conn->error;
}

// 关闭数据库连接
$conn->close();
?>

2. Activation module

1. Activation link page
   When the user receives the activation link, clicking the link will jump Go to the activation link page. We can use PHP's $_GET variable to obtain the email address in the link and activate the email address. The following is a simple sample code:

<?php
// 获取邮箱地址
$email = $_GET['email'];

// 连接数据库
$conn = new mysqli("localhost", "username", "password", "database");

// 检查连接是否成功
if ($conn->connect_error) {
    die("数据库连接失败: " . $conn->connect_error);
}

// 更新用户激活状态
$sql = "UPDATE users SET status = '1' WHERE email = '$email'";
if ($conn->query($sql) === TRUE) {
    echo "邮箱激活成功！";
} else {
    echo "邮箱激活失败：" . $conn->error;
}

// 关闭数据库连接
$conn->close();
?>

2. Login module
   In the login page, users need to enter their email address and password to log in. In the login handler's PHP file (login.php), we can verify that the email address and password entered by the user match, and check that the email address is already activated. The following is a simple sample code:

<?php
// 连接数据库
$conn = new mysqli("localhost", "username", "password", "database");

// 检查连接是否成功
if ($conn->connect_error) {
    die("数据库连接失败: " . $conn->connect_error);
}

// 获取用户输入的登录信息
$email = $_POST['email'];
$password = $_POST['password'];

// 验证用户输入的信息
$sql = "SELECT * FROM users WHERE email = '$email' AND password = '$password' AND status = '1'";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    echo "登录成功！";
} else {
    echo "登录失败，请确保邮箱已经激活并且密码正确！";
}

// 关闭数据库连接
$conn->close();
?>

Through the above steps, we can implement the email verification login registration function in PHP. When the user enters their email address and password on the registration page, the system will automatically send an activation link to the user's email address. After the user clicks the link to jump to the activation page, the system will verify the email address in the link and update the activation status in the user table. Users need to enter their email address and password when logging in, and can successfully log in only after passing verification.

The above is the detailed content of Detailed step-by-step analysis of implementing email verification login registration function in PHP. For more information, please follow other related articles on the PHP Chinese website!