PHPモール開発スキル：ユーザー登録・ログインプロセスの設計

CREATE TABLE users (
  user_id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  username VARCHAR(255) NOT NULL,
  password VARCHAR(255) NOT NULL,
  email VARCHAR(255) NOT NULL,
  phone VARCHAR(20) NOT NULL,
  register_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

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

  // 数据验证
  // 略...

  // 检查用户名和邮箱是否已经存在
  // 略...

  // 插入用户数据到数据库中
  $query = "INSERT INTO users (username, password, email, phone) VALUES ('$username', '$password', '$email', '$phone')";
  $result = mysqli_query($conn, $query);
  if ($result) {
    // 注册成功
    echo "注册成功！";
  } else {
    // 注册失败
    echo "注册失败！";
  }
}
?>

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

  // 后端验证用户名和密码是否匹配
  $query = "SELECT user_id FROM users WHERE username='$username' AND password='$password'";
  $result = mysqli_query($conn, $query);
  if (mysqli_num_rows($result) == 1) {
    // 登录成功
    session_start();
    $_SESSION["user_id"] = mysqli_fetch_assoc($result)["user_id"];
    echo "登录成功！";
  } else {
    // 登录失败
    echo "用户名或密码错误！";
  }
}
?>