php登录实现
PHP 登录实现
数据库准备
创建一个用户表用于存储登录信息。以下是一个基本的 MySQL 表结构示例:
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
);
密码加密
使用 PHP 的 password_hash 函数对密码进行加密存储:
$password = password_hash($_POST['password'], PASSWORD_DEFAULT);
登录表单
创建一个 HTML 表单用于用户输入用户名和密码:
<form action="login.php" method="post">
<input type="text" name="username" placeholder="Username" required>
<input type="password" name="password" placeholder="Password" required>
<button type="submit">Login</button>
</form>
登录验证
在 login.php 文件中验证用户输入:
session_start();
$db = new PDO('mysql:host=localhost;dbname=your_database', 'username', 'password');
$username = $_POST['username'];
$password = $_POST['password'];
$stmt = $db->prepare("SELECT * FROM users WHERE username = :username");
$stmt->bindParam(':username', $username);
$stmt->execute();
$user = $stmt->fetch();
if ($user && password_verify($password, $user['password'])) {
$_SESSION['user_id'] = $user['id'];
header('Location: dashboard.php');
} else {
echo "Invalid username or password";
}
会话管理
登录成功后,使用 $_SESSION 存储用户信息:
session_start();
if (!isset($_SESSION['user_id'])) {
header('Location: login.php');
exit();
}
安全措施
- 使用 HTTPS 加密传输数据
- 防止 SQL 注入,使用预处理语句
- 设置 CSRF 令牌防止跨站请求伪造
- 限制登录尝试次数防止暴力破解
完整示例
以下是一个完整的登录处理示例:

<?php
session_start();
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
$db = new PDO('mysql:host=localhost;dbname=your_database', 'username', 'password');
$username = trim($_POST['username']);
$password = $_POST['password'];
$stmt = $db->prepare("SELECT id, username, password FROM users WHERE username = :username");
$stmt->bindParam(':username', $username);
$stmt->execute();
$user = $stmt->fetch(PDO::FETCH_ASSOC);
if ($user && password_verify($password, $user['password'])) {
$_SESSION['user_id'] = $user['id'];
$_SESSION['username'] = $user['username'];
header('Location: dashboard.php');
exit();
} else {
$error = "Invalid login credentials";
}
}
?>
<!DOCTYPE html>
<html>
<head>
<title>Login</title>
</head>
<body>
<?php if (isset($error)): ?>
<p><?php echo $error; ?></p>
<?php endif; ?>
<form method="post">
<input type="text" name="username" placeholder="Username" required>
<input type="password" name="password" placeholder="Password" required>
<button type="submit">Login</button>
</form>
</body>
</html>






