用php+mysql实现一个购物车功能

CREATE TABLE `cart` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `product_name` varchar(255) NOT NULL,
  `product_price` decimal(10,2) NOT NULL,
  `product_quantity` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

<?php

$servername = "localhost";
$username = "username";
$passWord = "password";
$dbname = "myDB";

// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);

// 检查连接是否成功
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// 获取要添加到购物车的商品信息
$product_name = $_POST['product_name'];
$product_price = $_POST['product_price'];
$product_quantity = $_POST['product_quantity'];
$user_id = $_POST['user_id'];

// 将商品添加到购物车
$sql = "INSERT INTO cart (product_name, product_price, product_quantity, user_id) 
VALUES ('$product_name', '$product_price', '$product_quantity', '$user_id')";

if ($conn->query($sql) === TRUE) {
    echo "商品已成功添加到购物车。";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();

?>

<?php

$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";

// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);

// 检查连接是否成功
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// 获取购物车信息
$sql = "SELECT * FROM cart WHERE user_id = '123'"; // 请将user_id替换为当前登录用户的ID

$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // 输出每一行数据
    while($row = $result->fetch_assoc()) {
        echo "商品名称:" . $row["product_name"]. "，价格：" . $row["product_price"]. "，数量：" . $row["product_quantity"]. "<br>";
    }
} else {
    echo "购物车为空。";
}

$conn->close();

?>

<?php

$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";

// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);

// 检查连接是否成功
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// 获取要修改的商品信息
$product_name = $_POST['product_name'];
$product_price = $_POST['product_price'];
$product_quantity = $_POST['product_quantity'];
$user_id = $_POST['user_id'];

// 更新购物车中商品信息
$sql = "UPDATE cart SET product_price = '$product_price', product_quantity = '$product_quantity' WHERE user_id = '$user_id' AND product_name = '$product_name'";

if ($conn->query($sql) === TRUE) {
    echo "购物车信息已成功更新。";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();

?>