简单php登录注册（php实现简单登录和注册功能）

作者：妖孽少年发布日期:2025-09-24 浏览:732

以下是一个简单的PHP登录和注册功能的实现示例：

创建数据库表首先，创建一个名为users的数据库表，表结构如下：

CREATE TABLE `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(50) NOT NULL,
`password` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
);

注册页面（register.php）


<?php
// 数据库连接配置
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "your_database_name";

// 处理注册请求 if ($_SERVER["REQUEST_METHOD"] == "POST") { $username = $_POST["username"]; $password = $_POST["password"];

// 创建数据库连接
$conn = new mysqli($servername, $username, $password, $dbname);

// 检查连接是否成功
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 使用预处理语句插入用户信息到数据库
$stmt = $conn->prepare("INSERT INTO users (username, password) VALUES (?, ?)");
$stmt->bind_param("ss", $username, $password);

if ($stmt->execute()) {
    echo "注册成功";
} else {
    echo "注册失败";
}

$stmt->close();
$conn->close();

} ?>

<!DOCTYPE html>

注册

```

登录页面（login.php）


<?php
// 数据库连接配置
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "your_database_name";

// 处理登录请求 if ($_SERVER["REQUEST_METHOD"] == "POST") { $username = $_POST["username"]; $password = $_POST["password"];

// 创建数据库连接
$conn = new mysqli($servername, $username, $password, $dbname);

// 检查连接是否成功
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 使用预处理语句查询用户信息
$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 == $user["password"]) {
        echo "登录成功";
    } else {
        echo "密码错误";
    }
} else {
    echo "用户名不存在";
}

$stmt->close();
$conn->close();

} ?>

<!DOCTYPE html>