How to use PHP to develop a simple online ticket booking function

How to use PHP to develop a simple online ticket booking function
In modern society, more and more people choose to book tickets online to save time and convenience. For individuals or small businesses, developing a simple online ticket booking function is a good choice. This article will teach you how to use PHP to develop a simple online ticket booking function and provide specific code examples.

Step 1: Create database and tables
First, we need to create a database to store ticket-related data. Open your MySQL management tool (such as phpMyAdmin) and create a database named "ticket_booking". Then create a table named "bookings" in the database with the following table structure:

CREATE TABLE bookings (
id int(11) NOT NULL AUTO_INCREMENT,
name varchar(50) NOT NULL,
email varchar(50) NOT NULL,
phone varchar(20 ) NOT NULL,
date date NOT NULL,
quantity int(11) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

The above table structure contains some key fields, such as id (the ID that uniquely identifies each booking record), name (name of the person who booked the ticket), email (booker’s email address), phone (booker’s phone number), date (booking date) and quantity (booking quantity).

Step 2: Create a web form
Next, we need to create a web form to allow users to fill in the ticket booking information and submit it. Create a file called "booking.php" and add the following HTML code in it:

<title>在线订票</title>

<h1>在线订票</h1>
<form method="post" action="process_booking.php">
    <label for="name">姓名：</label>
    <input type="text" id="name" name="name" required><br><br>
    
    <label for="email">邮箱：</label>
    <input type="email" id="email" name="email" required><br><br>
    
    <label for="phone">电话：</label>
    <input type="text" id="phone" name="phone" required><br><br>
    
    <label for="date">日期：</label>
    <input type="date" id="date" name="date" required><br><br>
    
    <label for="quantity">数量：</label>
    <input type="number" id="quantity" name="quantity" required><br><br>
    
    <input type="submit" value="提交">
</form>

The above code contains a simple form, Users need to fill in information such as name, email, phone number, date and quantity, and click the "Submit" button.

Step 3: Process the ticket booking request
After the user submits the form, we need to process the ticket booking request and store the data in the database. Create a new file named "process_booking.php" in the project directory and copy the following code into the file:

// Processing POST requests
if ($ _SERVER["REQUEST_METHOD"] == "POST") {

$name = $_POST["name"];
$email = $_POST["email"];
$phone = $_POST["phone"];
$date = $_POST["date"];
$quantity = $_POST["quantity"];

// 连接数据库
$conn = mysqli_connect("localhost", "username", "password", "ticket_booking");

// 检查连接是否成功
if (!$conn) {
    die("连接数据库失败：" . mysqli_connect_error());
}

// 插入订票记录到数据库
$sql = "INSERT INTO bookings (name, email, phone, date, quantity) VALUES ('$name', '$email', '$phone', '$date', '$quantity')";

if (mysqli_query($conn, $sql)) {
    echo "订票成功！";
} else {
    echo "订票失败：" . mysqli_error($conn);
}

// 关闭数据库连接
mysqli_close($conn);

}
?>

Please remember to replace "username" and "password" in the code with yours MySQL username and password.

The above code first obtains the name, email, phone number, date, quantity and other information filled in by the user in the form, and connects to the database. Then, insert this information into the "bookings" table. Finally, close the database connection and display the ticket booking success or failure information to the user.

So far, we have completed the development of a simple online ticket booking function. You can deploy this code on your website and start accepting ticket booking requests from users. Of course, this is just a simple example, and you can extend and optimize more functions according to actual needs.

The above is the detailed content of How to use PHP to develop a simple online ticket booking function. For more information, please follow other related articles on the PHP Chinese website!