以下是一个完整的示例,整合了用户登录、注册和备忘录功能,希望能够帮助到大家:
php
<!DOCTYPE html>
<html>
<head>
<title>用户管理和备忘录</title>
</head>
<body>
<h2>用户管理和备忘录</h2>
<?php
// 数据库连接配置
$servername = "localhost";
$username = "数据库用户名";
$password = "数据库密码";
$dbname = "数据库名";
// 连接数据库
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
die("连接数据库失败: " . $conn->connect_error);
}
// 处理用户注册
if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST["register"])) {
$username = $_POST["username"];
$password = $_POST["password"];
// 插入用户信息
$sql = "INSERT INTO users (username, password) VALUES ('$username', '$password')";
if ($conn->query($sql) === TRUE) {
echo "用户注册成功!";
} else {
echo "注册用户时出错: " . $conn->error;
}
}
// 处理用户登录
if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST["login"])) {
$username = $_POST["username"];
$password = $_POST["password"];
// 验证用户信息
$sql = "SELECT * FROM users WHERE username='$username' AND password='$password'";
$result = $conn->query($sql);
if ($result->num_rows == 1) {
echo "用户登录成功!";
// 设置登录状态,保存用户ID
session_start();
$_SESSION["userid"] = $result->fetch_assoc()["id"];
} else {
echo "用户名或密码错误!";
}
}
// 添加备忘录
if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST["add_memo"]) && isset($_SESSION["userid"])) {
$userid = $_SESSION["userid"];
$memo = $_POST["memo"];
// 插入备忘录
$sql = "INSERT INTO memos (userid, memo) VALUES ('$userid', '$memo')";
if ($conn->query($sql) === TRUE) {
echo "备忘录已添加成功!";
} else {
echo "添加备忘录时出错: " . $conn->error;
}
}
// 显示备忘录列表
if (isset($_SESSION["userid"])) {
$userid = $_SESSION["userid"];
// 查询备忘录
$sql = "SELECT * FROM memos WHERE userid='$userid' ORDER BY id DESC";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// 输出备忘录
while ($row = $result->fetch_assoc()) {
echo "<p>" . $row["memo"] . "</p>";
}
} else {
echo "暂无备忘录!";
}
// 退出登录
echo "<br><a href='logout.php'>退出登录</a>";
} else {
// 登录和注册表单
echo "
<h3>用户注册</h3>
<form method='post' action='" . $_SERVER["PHP_SELF"] . "'>
<input type='text' name='username' placeholder='用户名' required><br><br>
<input type='password' name='password' placeholder='密码' required><br><br>
<input type='submit' name='register' value='注册'>
</form>
<h3>用户登录</h3>
<form method='post' action='" . $_SERVER["PHP_SELF"] . "'>
<input type='text' name='username' placeholder='用户名' required><br><br>
<input type='password' name='password' placeholder='密码' required><br><br>
<input type='submit' name='login' value='登录'>
</form>";
}
// 关闭数据库连接
$conn->close();
?>
<h3>添加备忘录</h3>
<?php
if (isset($_SESSION["userid"])) {
echo "
<form method='post' action='" . $_SERVER["PHP_SELF"] . "'>
<textarea name='memo' rows='4