如何使用PHP开发商城功能：搭建用户管理系统

CREATE DATABASE ecommerce;

USE ecommerce;

CREATE TABLE users (
  id INT(11) AUTO_INCREMENT PRIMARY KEY,
  username VARCHAR(50) NOT NULL,
  password VARCHAR(255) NOT NULL,
  email VARCHAR(100) NOT NULL,
  phone VARCHAR(20) NOT NULL,
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP
);

<?php
if ($_SERVER["REQUEST_METHOD"] == "POST") {
  $username = $_POST["username"];
  $password = $_POST["password"];
  $email = $_POST["email"];
  $phone = $_POST["phone"];

  // 输入验证...省略代码

  // 将用户信息插入数据库
  $conn = new mysqli("localhost", "username", "password", "ecommerce");
  $sql = "INSERT INTO users (username, password, email, phone) VALUES ('$username', '$password', '$email', '$phone')";

  if ($conn->query($sql) === TRUE) {
    echo "注册成功！";
  } else {
    echo "注册失败：" . $conn->error;
  }

  $conn->close();
}
?>

<?php
session_start();

if ($_SERVER["REQUEST_METHOD"] == "POST") {
  $username = $_POST["username"];
  $password = $_POST["password"];

  // 根据用户名从数据库获取密码
  $conn = new mysqli("localhost", "username", "password", "ecommerce");
  $sql = "SELECT * FROM users WHERE username='$username'";
  $result = $conn->query($sql);

  if ($result->num_rows == 1) {
    $row = $result->fetch_assoc();
    if (password_verify($password, $row["password"])) {
      $_SESSION["username"] = $username;
      header("Location: dashboard.php");
    } else {
      echo "密码错误！";
    }
  } else {
    echo "用户名不存在！";
  }

  $conn->close();
}
?>

<?php
if ($_SERVER["REQUEST_METHOD"] == "POST") {
  $email = $_POST["email"];

  // 根据邮箱从数据库获取用户名
  $conn = new mysqli("localhost", "username", "password", "ecommerce");
  $sql = "SELECT * FROM users WHERE email='$email'";
  $result = $conn->query($sql);

  if ($result->num_rows == 1) {
    $row = $result->fetch_assoc();
    // 发送密码重置邮件...省略代码
    echo "密码重置链接已发送至您的邮箱，请注意查收！";
  } else {
    echo "邮箱不存在！";
  }
  
  $conn->close();
}
?>

<?php
session_start();

// 验证用户是否已登录
if (!isset($_SESSION["username"])) {
  header("Location: login.php");
  exit;
}

$username = $_SESSION["username"];

// 根据用户名从数据库获取用户信息
$conn = new mysqli("localhost", "username", "password", "ecommerce");
$sql = "SELECT * FROM users WHERE username='$username'";
$result = $conn->query($sql);
$user = $result->fetch_assoc();

$conn->close();
?>

<!-- 显示个人信息 -->
<h1>个人信息</h1>
<p>用户名：<?php echo $user["username"]; ?></p>
<p>邮箱：<?php echo $user["email"]; ?></p>
<p>手机号：<?php echo $user["phone"]; ?></p>

<!-- 修改个人信息 -->
<h2>修改个人信息</h2>
<form method="post" action="update_profile.php">
  <label for="email">邮箱：</label>
  <input type="email" name="email" value="<?php echo $user["email"]; ?>" required>
  <br>

  <label for="phone">手机号：</label>
  <input type="text" name="phone" value="<?php echo $user["phone"]; ?>" required>
  <br>

  <button type="submit">保存</button>
</form>