当前位置：首页 > PHP

php购物车功能实现

2026-02-13 15:32:02PHP

PHP购物车功能实现

购物车是电商网站的核心功能之一，以下是实现PHP购物车功能的关键步骤和代码示例。

php购物车功能实现

数据库设计

创建一个简单的数据库表来存储购物车信息：

CREATE TABLE cart (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT,
    product_id INT,
    quantity INT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

添加商品到购物车

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

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

// 获取用户输入
$user_id = $_POST['user_id'];
$product_id = $_POST['product_id'];
$quantity = $_POST['quantity'];

// 检查商品是否已存在
$check_sql = "SELECT * FROM cart WHERE user_id = $user_id AND product_id = $product_id";
$result = $conn->query($check_sql);

if ($result->num_rows > 0) {
    // 更新数量
    $update_sql = "UPDATE cart SET quantity = quantity + $quantity WHERE user_id = $user_id AND product_id = $product_id";
    $conn->query($update_sql);
} else {
    // 插入新记录
    $insert_sql = "INSERT INTO cart (user_id, product_id, quantity) VALUES ($user_id, $product_id, $quantity)";
    $conn->query($insert_sql);
}

$conn->close();
?>

显示购物车内容

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

// 获取用户ID
$user_id = $_GET['user_id'];

// 查询购物车
$sql = "SELECT products.name, products.price, cart.quantity 
        FROM cart 
        JOIN products ON cart.product_id = products.id 
        WHERE cart.user_id = $user_id";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        echo "商品: " . $row["name"]. " - 价格: $" . $row["price"]. " - 数量: " . $row["quantity"]. "<br>";
    }
} else {
    echo "购物车为空";
}

$conn->close();
?>

更新购物车数量

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

// 获取用户输入
$user_id = $_POST['user_id'];
$product_id = $_POST['product_id'];
$new_quantity = $_POST['quantity'];

// 更新数量
$sql = "UPDATE cart SET quantity = $new_quantity WHERE user_id = $user_id AND product_id = $product_id";
$conn->query($sql);

$conn->close();
?>

从购物车移除商品

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

// 获取用户输入
$user_id = $_POST['user_id'];
$product_id = $_POST['product_id'];

// 删除记录
$sql = "DELETE FROM cart WHERE user_id = $user_id AND product_id = $product_id";
$conn->query($sql);

$conn->close();
?>

使用Session实现临时购物车

对于不需要数据库的临时购物车解决方案：

<?php
session_start();

// 添加商品
if (isset($_POST['add_to_cart'])) {
    $product_id = $_POST['product_id'];
    $quantity = $_POST['quantity'];

    if (!isset($_SESSION['cart'])) {
        $_SESSION['cart'] = array();
    }

    if (isset($_SESSION['cart'][$product_id])) {
        $_SESSION['cart'][$product_id] += $quantity;
    } else {
        $_SESSION['cart'][$product_id] = $quantity;
    }
}

// 显示购物车
if (isset($_SESSION['cart'])) {
    foreach ($_SESSION['cart'] as $product_id => $quantity) {
        echo "商品ID: $product_id, 数量: $quantity<br>";
    }
}
?>