PHPでメール認証ログイン登録機能を実装するための詳細な手順の分析

<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>

<?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();
?>

<?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();
?>

<?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();
?>