php实现登录展示页面
PHP 登录展示页面实现
数据库连接与用户验证
创建 config.php 文件存储数据库连接信息:
<?php
$host = 'localhost';
$user = 'username';
$pass = 'password';
$db = 'database_name';
$conn = new mysqli($host, $user, $pass, $db);
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
?>
登录表单设计
创建 login.php 文件包含表单和基础样式:
<!DOCTYPE html>
<html>
<head>
<title>Login</title>
<style>
body { font-family: Arial; background: #f4f4f4; }
.container { width: 300px; margin: 0 auto; padding: 20px; background: #fff; box-shadow: 0 0 10px rgba(0,0,0,0.1); }
input[type="text"], input[type="password"] { width: 100%; padding: 10px; margin: 8px 0; }
input[type="submit"] { background: #333; color: #fff; border: none; padding: 10px; width: 100%; }
</style>
</head>
<body>
<div class="container">
<h2>Login</h2>
<form action="authenticate.php" method="post">
<input type="text" name="username" placeholder="Username" required>
<input type="password" name="password" placeholder="Password" required>
<input type="submit" value="Login">
</form>
</div>
</body>
</html>
用户认证处理
创建 authenticate.php 处理登录逻辑:
<?php
require 'config.php';
$username = $_POST['username'];
$password = $_POST['password'];
$stmt = $conn->prepare("SELECT * FROM users WHERE username = ?");
$stmt->bind_param("s", $username);
$stmt->execute();
$result = $stmt->get_result();
if ($result->num_rows > 0) {
$user = $result->fetch_assoc();
if (password_verify($password, $user['password'])) {
session_start();
$_SESSION['user_id'] = $user['id'];
$_SESSION['username'] = $user['username'];
header("Location: dashboard.php");
} else {
echo "Invalid password";
}
} else {
echo "User not found";
}
$stmt->close();
$conn->close();
?>
受保护页面示例
创建 dashboard.php 展示登录后内容:
<?php
session_start();
if (!isset($_SESSION['user_id'])) {
header("Location: login.php");
exit;
}
?>
<!DOCTYPE html>
<html>
<head>
<title>Dashboard</title>
</head>
<body>
<h1>Welcome, <?php echo htmlspecialchars($_SESSION['username']); ?></h1>
<p>This is your secure dashboard.</p>
<a href="logout.php">Logout</a>
</body>
</html>
注销功能实现
创建 logout.php 处理注销:
<?php
session_start();
session_unset();
session_destroy();
header("Location: login.php");
exit;
?>
安全增强建议
密码应使用 PHP 的 password_hash() 函数存储:
$hashed_password = password_hash($plain_password, PASSWORD_DEFAULT);
防止 SQL 注入必须使用预处理语句,所有用户输入需通过 htmlspecialchars() 过滤输出。敏感页面应强制 HTTPS 连接,可设置会话过期时间:
ini_set('session.cookie_lifetime', 86400);
数据库表结构参考
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
);






