How to write a simple online reservation system through PHP

How to write a simple online reservation system through PHP

With the popularity of the Internet and users' pursuit of convenience, online reservation systems are becoming more and more popular. Whether it is a restaurant, hospital, beauty salon or other service industry, a simple online reservation system can improve efficiency and provide users with a better service experience. This article will introduce how to use PHP to write a simple online reservation system and provide specific code examples.

1. Create database and tables

First, we need to create a database to store reservation information. Create a database named "appointment" in MySQL and create a data table named "appointments" containing the following fields:

id INT(11) PRIMARY KEY AUTO_INCREMENT
name VARCHAR(50)
email VARCHAR(50)
phone VARCHAR(20)
date DATE
time TIME

2. Create appointment form

Next, we need to create a reservation form for users to fill out. In the HTML file, add the following code:

<form method="post" action="process.php">
  <input type="text" name="name" placeholder="姓名" required>
  <input type="email" name="email" placeholder="邮箱" required>
  <input type="tel" name="phone" placeholder="电话" required>
  <input type="date" name="date" required>
  <input type="time" name="time" required>
  <button type="submit">提交预约</button>
</form>

3. Processing appointment requests

Create a PHP file named "process.php" to handle appointment requests. In this file we need to receive the form data and insert it into the database. Add the following code:

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

$conn = new mysqli($servername, $username, $password, $dbname);

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

// 处理预约请求
$name = $_POST['name'];
$email = $_POST['email'];
$phone = $_POST['phone'];
$date = $_POST['date'];
$time = $_POST['time'];

$sql = "INSERT INTO appointments (name, email, phone, date, time)
        VALUES ('$name', '$email', '$phone', '$date', '$time')";

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

$conn->close();
?>

4. Display appointment list

In order to facilitate the management of appointment information, we can create a page to display the appointment list. In a new PHP file, add the following code:

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

$conn = new mysqli($servername, $username, $password, $dbname);

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

// 获取预约列表
$sql = "SELECT * FROM appointments";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
  while ($row = $result->fetch_assoc()) {
    echo "姓名: " . $row['name'] . "<br>";
    echo "邮箱: " . $row['email'] . "<br>";
    echo "电话: " . $row['phone'] . "<br>";
    echo "日期: " . $row['date'] . "<br>";
    echo "时间: " . $row['time'] . "<br>";
    echo "<br>";
  }
} else {
  echo "暂无预约信息";
}

$conn->close();
?>

By accessing the above page, you will be able to see a list of appointments, including the name, email, phone number, date and time of each appointment.

The above is the implementation method of a simple online reservation system. Writing an online reservation system using PHP is not only simple and easy to understand, but also very flexible. You can modify and expand it according to actual needs. Hope this article helps you!

The above is the detailed content of How to write a simple online reservation system through PHP. For more information, please follow other related articles on the PHP Chinese website!