Home > Article > Backend Development > How to write a simple online booking system via PHP
How to write a simple online booking system via PHP
- 王林Original
- 2023-09-26 19:09:221121browse
How to write a simple online reservation system through PHP
The online reservation system is an indispensable part of modern business operations. Through a simple online booking system, users can easily browse and book hotels, flights, tickets, etc. This article will introduce how to use PHP to write a simple online reservation system and provide specific code examples.
Step 1: Create database
First, we need to create a database to store booking information. You can use a MySQL database and create a database named "booking_system". In this database, we create a table called "bookings" to store the user's booking details. The structure of the table is as follows:
CREATE TABLE bookings (
id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(50),
email VARCHAR(50),
date DATE,
time TIME
);
Step 2: Build a user interface
Next, we need to build a user interface to allow users to enter reservation information. We use HTML and CSS to create a simple form. Here is a sample code:
<!DOCTYPE html>
<html>
<head>
<title>在线预订系统</title>
<style>
form {
width: 300px;
margin: 0 auto;
padding: 20px;
}
input[type="text"], input[type="date"], input[type="time"] {
width: 100%;
padding: 10px;
margin-bottom: 10px;
}
input[type="submit"] {
width: 100%;
padding: 10px;
background-color: #4479BA;
color: white;
border: none;
}
</style>
</head>
<body>
<form action="booking_process.php" method="POST">
<label for="name">姓名：</label>
<input type="text" id="name" name="name" required>
<label for="email">邮箱：</label>
<input type="text" id="email" name="email" required>
<label for="date">日期：</label>
<input type="date" id="date" name="date" required>
<label for="time">时间：</label>
<input type="time" id="time" name="time" required>
<input type="submit" value="预订">
</form>
</body>
</html>Step 3: Process the booking information
Now, we need to create a PHP file that processes the booking information submitted by the user and stores it in the database . The following is a sample code:
<?php
// 获取用户提交的预订信息
$name = $_POST['name'];
$email = $_POST['email'];
$date = $_POST['date'];
$time = $_POST['time'];
// 连接到数据库
$connection = mysqli_connect('localhost', 'username', 'password', 'booking_system');
// 插入预订信息到数据库
$query = "INSERT INTO bookings (name, email, date, time) VALUES ('$name', '$email', '$date', '$time')";
mysqli_query($connection, $query);
// 关闭数据库连接
mysqli_close($connection);
// 跳转到预订成功页面
header('Location: booking_success.php');
?>In the above code, we first obtain the reservation information submitted by the user. We then establish a connection to the database via the MySQLi extension and insert the booking information into the "bookings" table. Finally, we close the database connection and redirect the user to the booking success page.
Step 4: Display the reservation success page
Finally, we need to create a reservation success page to display the reservation success message to the user. The following is a simple code example:
<!DOCTYPE html> <html> <head> <title>预订成功</title> </head> <body> <h1>预订成功！</h1> <p>感谢您的预订。我们将尽快与您取得联系。</p> </body> </html>
Summary
Through the above steps, we can use PHP to write a simple online reservation system. Users can enter reservation information on the reservation page and click the "Reservation" button to submit the information. The submitted information will be stored in the database and the user will be redirected to the booking success page.
Of course, the above code is just a simple example. A real online booking system also needs to consider more functions and security such as user authentication, payment function, information verification, etc. I hope this article can provide a basic concept for beginners and inspire further learning and expansion.
The above is the detailed content of How to write a simple online booking system via PHP. For more information, please follow other related articles on the PHP Chinese website!