Home >Backend Development >PHP Tutorial >Second-hand recycling website developed by PHP provides order status query function

Second-hand recycling website developed by PHP provides order status query function

WBOYOriginal: 2023-07-01 23:37:131198browse

The second-hand recycling website developed in PHP provides an order status query function

As people pay more attention to environmental protection and resource recycling, second-hand recycling has become a popular way. Therefore, it becomes very important to develop a second-hand recycling website to meet people's needs. In this article, we will introduce how to use PHP to develop a second-hand recycling website and add an order status query function.

Before you start, make sure you have set up a server environment running PHP and are familiar with basic PHP syntax and the use of MySQL database.

First, we need to create a database to store order information. Execute the following SQL statement in MySQL to create a data table named "orders":

CREATE TABLE `orders` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_number` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL,
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Next, we start writing PHP code. First, create a file named "index.php" and add the following code:

<?php
// 连接数据库
$servername = "localhost";
$username = "your_username";
$password = "your_password";
$dbname = "your_database";

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 处理订单状态查询请求
if (isset($_POST['order_number'])) {
    $order_number = $_POST['order_number'];

    // 查询订单状态
    $sql = "SELECT * FROM orders WHERE order_number = '$order_number'";
    $result = $conn->query($sql);

    if ($result->num_rows > 0) {
        $row = $result->fetch_assoc();
        $status = $row['status'];
        echo "订单状态: " . $status;
    } else {
        echo "订单不存在";
    }
}
?>

In the above code, we first connect to the database and process the order number parameter in the POST request. Next, we executed a SQL query to get the status of the order and returned its results to the user.

Next, we need to create a file named "index.html" and add the following code:

<!DOCTYPE html>
<html>
<head>
    <title>订单状态查询</title>
</head>
<body>
    <form action="index.php" method="POST">
        <input type="text" name="order_number" placeholder="请输入订单号">
        <input type="submit" value="查询">
    </form>
</body>
</html>

The above code creates a simple order number input field and query button. form.

Now, upload the above two files to your server and visit "index.html" in the browser. You should be able to see a page with an order number input field and a query button.

Try to enter an existing order number and click the query button. You should be able to see the order status on the page. If the order does not exist, "Order does not exist" will be displayed.

Through the above sample code, we successfully created a second-hand recycling website and implemented the order status query function. You can modify and extend the code according to actual needs to meet your needs.

Summary: PHP is a powerful programming language that can be used to develop various types of websites and applications. Through the sample code in this article, I hope it will help you understand how to use PHP to develop a second-hand recycling website and add an order status query function. I wish you success in developing with PHP!

The above is the detailed content of Second-hand recycling website developed by PHP provides order status query function. For more information, please follow other related articles on the PHP Chinese website!

Statement：

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Previous article：Second-hand recycling website uses transaction evaluation system developed by PHPNext article：Second-hand recycling website uses transaction evaluation system developed by PHP

See more

Second-hand recycling website developed by PHP provides order status query function

Related articles