Second-hand recycling website uses order tracking function developed in PHP

The second-hand recycling website uses the order tracking function developed by PHP

With the rapid development of the second-hand trading market, more and more people choose to recycle or reuse idle items. In order to meet users' needs for second-hand transactions, second-hand recycling websites are gradually emerging and constantly improving their functions and user experience. Among them, the order tracking function is very important for users. It allows users to understand the progress of their transaction status at any time and track the specific location of items.

This article will introduce how to use PHP to develop the order tracking function of a second-hand recycling website, and provide code examples for readers' reference.

1. Database design

First, we need to create a database table for storing order information. The following are the basic fields of the order table:

order_id: order ID, primary key
user_id: user ID, foreign key, associated to the user table
item_id: item ID, foreign key, associated to the item table
status: order status, including pending, confirmed, shipped, etc.
address: delivery address
create_time: creation time
update_time: update time

According to actual needs , which you can expand based on the above fields.

2. Implementation of the order tracking function

1. Create the order_track table

The order_track table is used to store order tracking records. Fields include:

order_track_id: tracking record ID, primary key
order_id: order ID, foreign key, associated to the order table
date_time: tracking record time
location: item location
description : Tracking record description

2. Add order tracking record

When the user places an order, we need to insert the initial tracking record of the order into the order_track table. The following is a sample code:

function addOrderTrack($orderId, $location, $description) {
    $dateTime = date('Y-m-d H:i:s');
    
    $query = "INSERT INTO order_track (order_id, date_time, location, description) VALUES ('$orderId', '$dateTime', '$location', '$description')";
    
    // 执行SQL语句，将订单追踪记录插入到order_track表中
    // 这里使用的是mysqli扩展，您也可以使用PDO或其他数据库操作扩展
    $result = mysqli_query($conn, $query);
    
    if ($result) {
        // 订单追踪记录插入成功，可以进行其他操作
    } else {
        // 订单追踪记录插入失败，可以进行错误处理
    }
}

3. Get order tracking record

Users can view the order tracking record through the order number. The following is a sample code:

function getOrderTrack($orderId) {
    $query = "SELECT * FROM order_track WHERE order_id = '$orderId'";
    
    // 执行SQL语句，获取订单的追踪记录
    // 这里使用的是mysqli扩展，您也可以使用PDO或其他数据库操作扩展
    $result = mysqli_query($conn, $query);
    
    if ($result) {
        $orderTracks = mysqli_fetch_all($result, MYSQLI_ASSOC);
        
        // 对获取的订单追踪记录进行处理，可以根据需要进行展示或其他操作
        
        return $orderTracks;
    } else {
        // 获取订单追踪记录失败，可以进行错误处理
    }
}

3. Front-end display of order tracking function

The front-end display of order tracking function mainly includes: order status display and tracking record display.

1. Order status display

We can display the current status of the order on the user's order details page. The following is a sample code:

// 根据订单ID获取订单信息
$order = getOrder($orderId);

if ($order['status'] == 1) {
    echo "待确认";
} elseif ($order['status'] == 2) {
    echo "已确认";
} elseif ($order['status'] == 3) {
    echo "已发货";
} else {
    echo "未知状态";
}

2. Tracking Record Display

Users can click the "View Tracking Record" button on the order details page to obtain the order's tracking record and display it. . The following is a sample code:

// 根据订单ID获取订单的追踪记录
$orderTracks = getOrderTrack($orderId);

foreach ($orderTracks as $orderTrack) {
    echo $orderTrack['date_time'] . " - " . $orderTrack['location'] . " - " . $orderTrack['description'] . "<br>";
}

The above is the specific implementation of the order tracking function of using PHP to develop a second-hand recycling website. Through reasonable database design and code writing, we can provide users with convenient order status tracking and item location tracking services, improve user experience, and promote the development of second-hand recycling websites.

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