PHP scheduled task implementation: steps to cancel orders every 10 minutes

Title: PHP scheduled task implementation: Cancel order every 10 minutes Operation steps

In e-commerce platforms or online trading websites, order processing is an important link . Sometimes users may not pay for a long time after placing an order, or the order needs to be canceled for other reasons. In order to automatically cancel orders, we can use PHP scheduled tasks to check the order and cancel it every 10 minutes.

The following are specific operation steps and code examples:

Step 1: Set up a scheduled task

First, we need to set up a scheduled task on the server so that the system can Execute the PHP script we wrote once every minute. You can use cron to achieve this function, open the terminal and enter the following command:

crontab -e

Then add a line similar to the following:

*/10 * * * * php /path/to/cancel_orders.php

This line of code means that the name cancel_orders is executed every 10 minutes .php PHP script.

Step 2: Write a PHP script

Next, we need to write the PHP script cancel_orders.php to implement the function of canceling orders. The following is a simple example:

<?php
// 连接数据库
$conn = new mysqli("localhost", "username", "password", "database");

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

// 获取需要取消的订单
$query = "SELECT * FROM orders WHERE status = 'pending' AND date < NOW() - INTERVAL 10 MINUTE";
$result = $conn->query($query);

if ($result->num_rows > 0) {
    // 取消订单
    while ($row = $result->fetch_assoc()) {
        $order_id = $row['id'];
        // 执行取消订单的操作，例如更新订单状态为cancelled
        $update_query = "UPDATE orders SET status = 'cancelled' WHERE id = $order_id";
        $conn->query($update_query);
        echo "订单 $order_id 已取消
";
    }
} else {
    echo "没有需要取消的订单
";
}

$conn->close();
?>

In this code, we first connect to the database, then query the orders with a status of 'pending' and a creation time earlier than 10 minutes before the current time, and then add the status of these orders Updated to 'cancelled'. Finally print out the canceled order information.

Step 3: Test run

After the above steps are completed, you can manually execute the PHP script once to test whether it is working properly. Enter the following command in the terminal:

php /path/to/cancel_orders.php

If all goes well, the system will cancel the appropriate order.

Through the above steps, we have successfully implemented the operation of canceling orders every 10 minutes using PHP scheduled tasks. This automated operation can greatly improve the efficiency of order processing and reduce the burden of manual operations.

The above is the detailed content of PHP scheduled task implementation: steps to cancel orders every 10 minutes. For more information, please follow other related articles on the PHP Chinese website!