当前位置：首页 > PHP

PHP实现增加结算

2026-02-16 05:02:15PHP

PHP实现购物车结算功能

在PHP中实现购物车结算功能需要结合数据库操作、表单处理和计算逻辑。以下是一个基本的实现方法：

数据库表结构设计 创建cart表存储购物车商品，字段包括id、user_id、product_id、quantity等。创建orders表存储结算订单，字段包括order_id、user_id、total_amount、status等。

PHP实现增加结算

添加商品到购物车

// 添加商品到购物车
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['add_to_cart'])) {
    $productId = $_POST['product_id'];
    $quantity = $_POST['quantity'] ?? 1;

    // 检查是否已存在购物车记录
    $stmt = $pdo->prepare("SELECT * FROM cart WHERE user_id = ? AND product_id = ?");
    $stmt->execute([$userId, $productId]);

    if ($stmt->rowCount() > 0) {
        // 更新数量
        $pdo->prepare("UPDATE cart SET quantity = quantity + ? WHERE user_id = ? AND product_id = ?")
            ->execute([$quantity, $userId, $productId]);
    } else {
        // 新增记录
        $pdo->prepare("INSERT INTO cart (user_id, product_id, quantity) VALUES (?, ?, ?)")
            ->execute([$userId, $productId, $quantity]);
    }
}

结算处理逻辑

PHP实现增加结算

// 结算处理
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['checkout'])) {
    // 获取购物车商品
    $stmt = $pdo->prepare("SELECT c.*, p.price FROM cart c JOIN products p ON c.product_id = p.id WHERE c.user_id = ?");
    $stmt->execute([$userId]);
    $cartItems = $stmt->fetchAll();

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

    // 创建订单
    $pdo->beginTransaction();
    try {
        $orderId = uniqid('ORD');
        $pdo->prepare("INSERT INTO orders (order_id, user_id, total_amount, status) VALUES (?, ?, ?, 'pending')")
            ->execute([$orderId, $userId, $totalAmount]);

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

        // 清空购物车
        $pdo->prepare("DELETE FROM cart WHERE user_id = ?")->execute([$userId]);

        $pdo->commit();
        echo "订单创建成功，订单号：$orderId";
    } catch (Exception $e) {
        $pdo->rollBack();
        echo "结算失败：" . $e->getMessage();
    }
}

支付接口集成

支付宝支付集成示例

// 支付宝支付请求
function createAlipayOrder($orderId, $amount, $subject) {
    require_once 'alipay/config.php';
    require_once 'alipay/pagepay/service/AlipayTradeService.php';
    require_once 'alipay/pagepay/buildermodel/AlipayTradePagePayContentBuilder.php';

    $payRequestBuilder = new AlipayTradePagePayContentBuilder();
    $payRequestBuilder->setBody($subject);
    $payRequestBuilder->setSubject($subject);
    $payRequestBuilder->setOutTradeNo($orderId);
    $payRequestBuilder->setTotalAmount($amount);

    $aop = new AlipayTradeService($config);
    return $aop->pagePay($payRequestBuilder, $config['return_url'], $config['notify_url']);
}

订单状态管理

订单状态更新

// 更新订单状态
function updateOrderStatus($orderId, $status) {
    global $pdo;
    $stmt = $pdo->prepare("UPDATE orders SET status = ? WHERE order_id = ?");
    return $stmt->execute([$status, $orderId]);
}