当前位置：首页 > PHP

PHP中下单功能实现

2026-04-03 12:09:00PHP

下单功能实现步骤

在PHP中实现下单功能通常涉及数据库操作、表单验证、支付接口集成等环节。以下是关键实现步骤：

数据库设计

创建订单表（orders）和订单详情表（order_items）是基础：

CREATE TABLE orders (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    order_number VARCHAR(50) UNIQUE,
    total_amount DECIMAL(10,2),
    status ENUM('pending','paid','shipped','completed','cancelled') DEFAULT 'pending',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE order_items (
    id INT AUTO_INCREMENT PRIMARY KEY,
    order_id INT,
    product_id INT,
    quantity INT,
    price DECIMAL(10,2),
    FOREIGN KEY (order_id) REFERENCES orders(id)
);

表单处理与验证

接收并验证前端提交的订单数据：

// 验证商品信息
$cartItems = $_POST['cart_items'];
if(empty($cartItems)) {
    die("购物车为空");
}

// 计算总价
$totalAmount = 0;
foreach($cartItems as $item) {
    $totalAmount += $item['price'] * $item['quantity'];
}

// 生成唯一订单号
$orderNumber = 'ORD' . date('YmdHis') . mt_rand(1000,9999);

数据库事务处理

使用事务确保数据一致性：

try {
    $pdo->beginTransaction();

    // 插入订单主表
    $stmt = $pdo->prepare("INSERT INTO orders (user_id, order_number, total_amount) VALUES (?, ?, ?)");
    $stmt->execute([$userId, $orderNumber, $totalAmount]);
    $orderId = $pdo->lastInsertId();

    // 插入订单明细
    $itemStmt = $pdo->prepare("INSERT INTO order_items (order_id, product_id, quantity, price) VALUES (?, ?, ?, ?)");
    foreach($cartItems as $item) {
        $itemStmt->execute([$orderId, $item['product_id'], $item['quantity'], $item['price']]);
    }

    $pdo->commit();
} catch(Exception $e) {
    $pdo->rollBack();
    die("下单失败: " . $e->getMessage());
}

支付接口集成

调用支付网关（以支付宝为例）：

require_once('alipay.config.php');
require_once('lib/alipay_submit.class.php');

$alipaySubmit = new AlipaySubmit($alipay_config);
$paymentUrl = $alipaySubmit->buildRequestForm([
    'out_trade_no' => $orderNumber,
    'subject'      => '商品订单',
    'total_fee'    => $totalAmount,
    'body'         => '订单描述'
], "get", "确认支付");

订单状态回调处理

支付成功后处理回调：

$verifyResult = $alipayNotify->verifyNotify();
if($verifyResult) {
    $orderNumber = $_POST['out_trade_no'];
    $tradeStatus = $_POST['trade_status'];

    if($tradeStatus == 'TRADE_SUCCESS') {
        $pdo->prepare("UPDATE orders SET status='paid' WHERE order_number=?")
           ->execute([$orderNumber]);
    }
}