PHP development practice: using PHP and MySQL to implement email verification function

PHP development practice: Use PHP and MySQL to implement email verification function

Email verification is one of the common functions in web applications, which can ensure that the email address entered by the user is valid and belongs to an actual user. . In this article, we will use the PHP programming language and MySQL database to implement a simple email verification function.

First, we need to create a form for user registration, which includes the email address and password entered by the user. We can create a simple registration form using HTML code:

<form action="register.php" method="POST">
  <label for="email">邮箱地址：</label>
  <input type="email" id="email" name="email" required>
  <br>
  <label for="password">密码：</label>
  <input type="password" id="password" name="password" required>
  <br>
  <input type="submit" value="注册">
</form>

After the user clicks the register button, the form will be submitted to a PHP script called register.php. In this script, we will perform the following operations:

1. Check whether the email address submitted by the user is valid;
2. Check whether the email address has been registered;
3. Insert The new user's data is stored in the database;
4. Generates a unique verification code and sends it to the user's mailbox.

The following is a code example for register.php:

<?php
// 连接到MySQL数据库
$mysqli = new mysqli("localhost", "username", "password", "database_name");
if ($mysqli->connect_error) {
    die("连接数据库失败: " . $mysqli->connect_error);
}

// 获取用户提交的表单数据
$email = $_POST['email'];
$password = $_POST['password'];

// 检查邮箱地址是否有效
if (!filter_var($email, FILTER_VALIDATE_EMAIL)) {
    die("无效的邮箱地址");
}

// 检查邮箱地址是否已被注册
$sql = "SELECT * FROM users WHERE email = '$email'";
$result = $mysqli->query($sql);
if ($result->num_rows > 0) {
    die("该邮箱地址已被注册");
}

// 生成验证码
$verificationCode = uniqid();

// 将新用户的数据插入数据库
$sql = "INSERT INTO users (email, password, verification_code) VALUES ('$email', '$password', '$verificationCode')";
if ($mysqli->query($sql) === TRUE) {
    echo "注册成功";
} else {
    echo "注册失败: " . $mysqli->error;
}

// 发送验证邮件（需要使用你自己的SMTP服务器配置）
$to = $email;
$subject = "账户激活";
$message = "请点击以下链接激活您的账户：" . "http://example.com/activate.php?code=".urlencode($verificationCode);
$headers = "From: noreply@example.com
" . "Reply-To: noreply@example.com
";
mail($to, $subject, $message, $headers);

$mysqli->close();
?>

In this example, we use PHP's built-in mail function to send a verification email. Please make sure that in the actual deployment environment, you have configured the SMTP server to send emails correctly.

Finally, we also need to create a PHP script named activate.php to activate the user's account. This script will check the verification code submitted by the user and update the activation status of the corresponding user in the database.

<?php
// 连接到MySQL数据库
$mysqli = new mysqli("localhost", "username", "password", "database_name");
if ($mysqli->connect_error) {
    die("连接数据库失败: " . $mysqli->connect_error);
}

// 获取用户提交的验证码
$verificationCode = $_GET['code'];

// 更新数据库中对应用户的激活状态
$sql = "UPDATE users SET is_activated = 1 WHERE verification_code = '$verificationCode'";
if ($mysqli->query($sql) === TRUE) {
    echo "账户激活成功";
} else {
    echo "账户激活失败: " . $mysqli->error;
}

$mysqli->close();
?>

Through the above code examples, we have implemented a simple registration system that uses PHP and MySQL to implement email verification functions. When a user registers, the system will automatically generate a verification code and send it to the user's email. After the user clicks on the verification code link, the system will activate the user's account.

Of course, the above code is just a simple example, you can modify and extend it according to your own needs. For example, you can add more form fields to collect user details, or store user passwords by using encryption algorithms, etc.

Summary:
This article introduces how to use the PHP programming language and MySQL database to implement the email verification function. By verifying the email address entered by the user and sending the generated verification code to the user, it can be ensured that the email address submitted by the user is valid. In the future, you can extend and customize this functionality as needed to meet your specific needs.

The above is the detailed content of PHP development practice: using PHP and MySQL to implement email verification function. For more information, please follow other related articles on the PHP Chinese website!