当前位置：首页 > PHP

php实现拍卖

2026-02-15 01:21:57PHP

PHP实现拍卖系统的基本思路

拍卖系统需要处理商品展示、竞价、时间限制和用户交互等功能。以下是一个基础实现框架：

php实现拍卖

数据库设计

创建必要的数据库表存储拍卖信息：

php实现拍卖

CREATE TABLE auctions (
    id INT AUTO_INCREMENT PRIMARY KEY,
    item_name VARCHAR(255),
    description TEXT,
    start_price DECIMAL(10,2),
    current_price DECIMAL(10,2),
    start_time DATETIME,
    end_time DATETIME,
    status ENUM('pending','active','ended')
);

CREATE TABLE bids (
    id INT AUTO_INCREMENT PRIMARY KEY,
    auction_id INT,
    user_id INT,
    amount DECIMAL(10,2),
    bid_time DATETIME,
    FOREIGN KEY (auction_id) REFERENCES auctions(id)
);

拍卖页面展示

// 获取拍卖列表
$query = "SELECT * FROM auctions WHERE status = 'active'";
$result = mysqli_query($connection, $query);

while ($auction = mysqli_fetch_assoc($result)) {
    echo "<div class='auction-item'>";
    echo "<h3>".htmlspecialchars($auction['item_name'])."</h3>";
    echo "<p>当前价格: ".$auction['current_price']."</p>";
    echo "<p>剩余时间: ".time_remaining($auction['end_time'])."</p>";
    echo "<form method='post' action='bid.php'>";
    echo "<input type='hidden' name='auction_id' value='".$auction['id']."'>";
    echo "<input type='number' name='bid_amount' step='0.01' min='".($auction['current_price']+1)."'>";
    echo "<button type='submit'>出价</button>";
    echo "</form>";
    echo "</div>";
}

竞价处理

// bid.php
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $auction_id = intval($_POST['auction_id']);
    $bid_amount = floatval($_POST['bid_amount']);
    $user_id = $_SESSION['user_id'];

    // 验证拍卖是否有效
    $auction = get_auction($auction_id);
    if ($auction['status'] !== 'active' || time() > strtotime($auction['end_time'])) {
        die("拍卖已结束");
    }

    if ($bid_amount <= $auction['current_price']) {
        die("出价必须高于当前价格");
    }

    // 记录竞价
    $query = "INSERT INTO bids (auction_id, user_id, amount, bid_time) 
              VALUES (?, ?, ?, NOW())";
    $stmt = mysqli_prepare($connection, $query);
    mysqli_stmt_bind_param($stmt, "iid", $auction_id, $user_id, $bid_amount);
    mysqli_stmt_execute($stmt);

    // 更新当前价格
    $update = "UPDATE auctions SET current_price = ? WHERE id = ?";
    $stmt = mysqli_prepare($connection, $update);
    mysqli_stmt_bind_param($stmt, "di", $bid_amount, $auction_id);
    mysqli_stmt_execute($stmt);

    header("Location: auctions.php");
}

定时任务处理

设置cron job定期检查结束的拍卖：

// check_auctions.php
$query = "SELECT id FROM auctions WHERE status = 'active' AND end_time <= NOW()";
$result = mysqli_query($connection, $query);

while ($row = mysqli_fetch_assoc($result)) {
    $update = "UPDATE auctions SET status = 'ended' WHERE id = ?";
    $stmt = mysqli_prepare($connection, $update);
    mysqli_stmt_bind_param($stmt, "i", $row['id']);
    mysqli_stmt_execute($stmt);

    // 可添加通知获胜者的逻辑
}

实时更新技术

使用AJAX实现价格实时更新：

// 前端JavaScript
function updatePrices() {
    $.ajax({
        url: 'get_current_price.php',
        success: function(data) {
            // 更新页面上的价格显示
            $('#current-price-'+data.auction_id).text(data.price);
        }
    });

    setTimeout(updatePrices, 5000); // 每5秒更新一次
}

// get_current_price.php
$auction_id = intval($_GET['auction_id']);
$query = "SELECT current_price FROM auctions WHERE id = ?";
$stmt = mysqli_prepare($connection, $query);
mysqli_stmt_bind_param($stmt, "i", $auction_id);
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);
$data = mysqli_fetch_assoc($result);

header('Content-Type: application/json');
echo json_encode([
    'auction_id' => $auction_id,
    'price' => $data['current_price']
]);