Second-hand recycling website developed using PHP supports scheduled automatic removal

Title: Development of second-hand recycling website with PHP scheduled automatic removal function

Introduction:
With the prosperity and development of the second-hand trading market, the demand for second-hand recycling websites is also increasing. In order to improve user experience and management efficiency, the scheduled automatic removal function has become an important function of second-hand recycling websites. This article will introduce how to use PHP to develop a second-hand recycling website, and add code examples for the scheduled automatic removal function.

1. Set up a PHP development environment
Before starting development, you first need to set up a PHP development environment. You can choose to use integrated development environments such as XAMPP, WAMP or LAMP. After setting up the environment, make sure that the code can run locally and that the connection to the database is normal.

2. Create a database
Create a data table for storing product information in the MySQL database. You can use the following SQL statement to create a data table named "products":

CREATE TABLE products (
    id INT(11) NOT NULL AUTO_INCREMENT,
    name VARCHAR(255) NOT NULL,
    price DECIMAL(10,2) NOT NULL,
    status ENUM('active', 'inactive') NOT NULL DEFAULT 'active',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (id)
);

3. Develop second-hand recycling website functions

1. Display product list interface

   <?php
   // index.php
   
   // 连接数据库
   $db = new mysqli('localhost', 'root', '', 'dbname');
   
   // 查询所有商品
   $sql = "SELECT * FROM products";
   $result = $db->query($sql);
   
   // 显示商品列表
   if ($result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        echo "商品名称: " . $row['name'] . " - 价格: " . $row['price'] . " - 状态: " . $row['status'] . "<br>";
    }
   } else {
    echo "暂无商品";
   }
   
   $db->close();
   ?>

   Copy after login

2. Add product interface

   <?php
   // add_product.php
   
   if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    // 连接数据库
    $db = new mysqli('localhost', 'root', '', 'dbname');
   
    // 获取表单数据
    $name = $_POST['name'];
    $price = $_POST['price'];
   
    // 插入商品记录
    $sql = "INSERT INTO products (name, price) VALUES ('$name', '$price')";
    $result = $db->query($sql);
   
    if ($result) {
        echo "商品添加成功";
    } else {
        echo "商品添加失败";
    }
   
    $db->close();
   }
   ?>
   
   <form method="post" action="add_product.php">
    <input type="text" name="name" placeholder="商品名称" required><br>
    <input type="text" name="price" placeholder="商品价格" required><br>
    <input type="submit" value="添加商品">
   </form>

   Copy after login

3. Scheduled automatic removal function

   <?php
   // update_status.php
   
   // 连接数据库
   $db = new mysqli('localhost', 'root', '', 'dbname');
   
   // 查询需要下架的商品
   $inactiveStatus = 'inactive';
   $inactiveTimestamp = strtotime('-7 days'); // 7天
   $sql = "UPDATE products SET status = '$inactiveStatus' WHERE status = 'active' AND created_at < '$inactiveTimestamp'";
   $result = $db->query($sql);
   
   if ($result) {
    echo "商品自动下架成功";
   } else {
    echo "商品自动下架失败";
   }
   
   $db->close();
   ?>

   Copy after login

4. Set scheduled tasks
   In order to allow scheduled tasks to automatically perform the removal function, you can use the Linux cron task scheduler. Use the following command to set up a script to be executed once every morning:

5. 0 * php /path/to/update_status.php

Conclusion:
This article introduces the code example of developing a second-hand recycling website through PHP and adding the scheduled automatic removal function. Through the execution of scheduled tasks, user experience and management efficiency can be improved, making the second-hand recycling website more convenient and efficient.

The above is the detailed content of Second-hand recycling website developed using PHP supports scheduled automatic removal. For more information, please follow other related articles on the PHP Chinese website!