Comment utiliser PHP pour développer des fonctions de réservation de voyages en ligne

CREATE DATABASE booking_system;

USE booking_system;

CREATE TABLE users (
  id INT PRIMARY KEY AUTO_INCREMENT,
  name VARCHAR(50) NOT NULL,
  email VARCHAR(50) NOT NULL,
  password VARCHAR(50) NOT NULL
);

CREATE TABLE bookings (
  id INT PRIMARY KEY AUTO_INCREMENT,
  user_id INT NOT NULL,
  destination VARCHAR(100) NOT NULL,
  arrival_date DATE NOT NULL,
  departure_date DATE NOT NULL,
  FOREIGN KEY (user_id) REFERENCES users(id)
);

<!-- 注册表单 -->
<form action="register.php" method="POST">
  <input type="text" name="name" placeholder="姓名" required>
  <input type="email" name="email" placeholder="邮箱" required>
  <input type="password" name="password" placeholder="密码" required>
  <button type="submit">注册</button>
</form>

<!-- 登录表单 -->
<form action="login.php" method="POST">
  <input type="email" name="email" placeholder="邮箱" required>
  <input type="password" name="password" placeholder="密码" required>
  <button type="submit">登录</button>
</form>

<?php
// 连接到数据库
$con = mysqli_connect("localhost", "root", "password", "booking_system");

// 获取表单数据
$name = $_POST['name'];
$email = $_POST['email'];
$password = $_POST['password'];

// 将用户信息插入到`users`表格中
$query = "INSERT INTO users (name, email, password) VALUES ('$name', '$email', '$password')";
mysqli_query($con, $query);

// 关闭数据库连接
mysqli_close($con);
?>

<?php
// 连接到数据库
$con = mysqli_connect("localhost", "root", "password", "booking_system");

// 获取表单数据
$email = $_POST['email'];
$password = $_POST['password'];

// 在`users`表格中查找匹配的记录
$query = "SELECT * FROM users WHERE email='$email' AND password='$password'";
$result = mysqli_query($con, $query);

if (mysqli_num_rows($result) == 1) {
  // 验证成功，用户登录
  echo "登录成功！";
} else {
  // 验证失败，提示用户错误信息
  echo "邮箱或密码不正确！";
}

// 关闭数据库连接
mysqli_close($con);
?>

<!-- 预订表单 -->
<form action="booking.php" method="POST">
  <input type="text" name="destination" placeholder="目的地" required>
  <input type="date" name="arrival_date" required>
  <input type="date" name="departure_date" required>
  <button type="submit">预订</button>
</form>

<?php
// 连接到数据库
$con = mysqli_connect("localhost", "root", "password", "booking_system");

// 获取表单数据
$destination = $_POST['destination'];
$arrival_date = $_POST['arrival_date'];
$departure_date = $_POST['departure_date'];

// 获取当前登录用户的ID
$user_id = $_SESSION['user_id'];

// 将预订信息插入到`bookings`表格中
$query = "INSERT INTO bookings (user_id, destination, arrival_date, departure_date) VALUES ($user_id, '$destination', '$arrival_date', '$departure_date')";
mysqli_query($con, $query);

// 关闭数据库连接
mysqli_close($con);
?>