当前位置：首页 > PHP

PHP实现会员管理

2026-04-03 07:44:09PHP

PHP会员管理系统实现

会员管理系统通常包含注册、登录、信息管理等功能，以下为PHP实现的核心模块和代码示例：

数据库设计

创建users表存储会员信息：

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50) NOT NULL UNIQUE,
    password VARCHAR(255) NOT NULL,
    email VARCHAR(100) NOT NULL UNIQUE,
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
    last_login DATETIME,
    status TINYINT DEFAULT 1
);

会员注册功能

处理表单提交并插入数据库：

PHP实现会员管理

<?php
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $username = trim($_POST['username']);
    $password = password_hash($_POST['password'], PASSWORD_DEFAULT);
    $email = filter_var($_POST['email'], FILTER_SANITIZE_EMAIL);

    $stmt = $pdo->prepare("INSERT INTO users (username, password, email) VALUES (?, ?, ?)");
    $stmt->execute([$username, $password, $email]);

    header("Location: login.php");
    exit;
}
?>

会员登录验证

验证用户凭证并创建会话：

session_start();
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $username = $_POST['username'];
    $password = $_POST['password'];

    $stmt = $pdo->prepare("SELECT * FROM users WHERE username = ?");
    $stmt->execute([$username]);
    $user = $stmt->fetch();

    if ($user && password_verify($password, $user['password'])) {
        $_SESSION['user_id'] = $user['id'];
        $_SESSION['username'] = $user['username'];

        // 更新最后登录时间
        $pdo->prepare("UPDATE users SET last_login = NOW() WHERE id = ?")
            ->execute([$user['id']]);

        header("Location: dashboard.php");
        exit;
    }
}

会话管理

保护需要登录的页面：

PHP实现会员管理

session_start();
if (!isset($_SESSION['user_id'])) {
    header("Location: login.php");
    exit;
}

密码重置功能

生成并发送重置令牌：

function generateToken() {
    return bin2hex(random_bytes(32));
}

$token = generateToken();
$expires = date('Y-m-d H:i:s', strtotime('+1 hour'));

$stmt = $pdo->prepare("UPDATE users SET reset_token = ?, reset_expires = ? WHERE email = ?");
$stmt->execute([$token, $expires, $_POST['email']]);

// 发送包含重置链接的邮件
$resetLink = "https://example.com/reset_password.php?token=$token";
mail($_POST['email'], "Password Reset", "Click here to reset: $resetLink");

会员资料更新

处理用户信息修改：

$stmt = $pdo->prepare("UPDATE users SET email = ?, username = ? WHERE id = ?");
$stmt->execute([
    filter_var($_POST['email'], FILTER_SANITIZE_EMAIL),
    trim($_POST['username']),
    $_SESSION['user_id']
]);