php怎么实现登录功能
数据库准备
创建用户表存储登录信息,通常包括用户名、密码(需加密)等字段。示例SQL:
CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(50) NOT NULL UNIQUE,
password VARCHAR(255) NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
密码加密处理
使用PHP的password_hash()函数进行密码哈希加密,存储时避免明文保存:
$hashedPassword = password_hash($rawPassword, PASSWORD_DEFAULT);
登录表单设计
HTML表单需包含用户名和密码字段,并设置POST方法提交:
<form action="login.php" method="post">
<input type="text" name="username" placeholder="用户名" required>
<input type="password" name="password" placeholder="密码" required>
<button type="submit">登录</button>
</form>
验证登录逻辑
在login.php中处理表单提交,验证用户凭证:
session_start();
$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'];
header("Location: dashboard.php");
} else {
echo "用户名或密码错误";
}
会话管理
登录成功后使用$_SESSION存储用户标识,后续页面通过检查会话控制访问:
session_start();
if (!isset($_SESSION['user_id'])) {
header("Location: login.php");
exit;
}
安全增强措施
- 使用预处理语句防止SQL注入
- 启用HTTPS传输加密
- 设置CSRF令牌防御跨站请求伪造
- 限制登录尝试次数防止暴力破解
完整示例代码
// 数据库连接
$pdo = new PDO('mysql:host=localhost;dbname=test', 'username', 'password');
// 登录处理
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
$username = trim($_POST['username']);
$password = $_POST['password'];
$stmt = $pdo->prepare("SELECT id, password FROM users WHERE username = ?");
$stmt->execute([$username]);
$user = $stmt->fetch();
if ($user && password_verify($password, $user['password'])) {
$_SESSION['user_id'] = $user['id'];
header("Location: /welcome.php");
exit;
}
$error = "登录失败";
}






