PHP 기술은 재정적 자유와 고소득 생활을 달성하는 데 도움이 됩니다.

<?php
// 从数据库中获取商品信息
$products = [
    ['id' => 1, 'name' => '商品1', 'price' => 100],
    ['id' => 2, 'name' => '商品2', 'price' => 200],
    ['id' => 3, 'name' => '商品3', 'price' => 300],
];

// 初始化购物车
$cart = [];

// 处理购物车操作
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    // 添加商品到购物车
    if ($_POST['action'] === 'add') {
        $productId = $_POST['productId'];
        $quantity = $_POST['quantity'];
        $product = null;

        foreach ($products as $p) {
            if ($p['id'] === $productId) {
                $product = $p;
                break;
            }
        }

        if ($product !== null) {
            $cartItem = [
                'product' => $product,
                'quantity' => $quantity,
            ];
            $cart[] = $cartItem;
        }
    }
    // 从购物车中移除商品
    elseif ($_POST['action'] === 'remove') {
        $index = $_POST['index'];
        if (isset($cart[$index])) {
            unset($cart[$index]);
        }
        $cart = array_values($cart);
    }
}

// 显示购物车内容
foreach ($cart as $index => $item) {
    echo '商品名称：' . $item['product']['name'] . '，数量：' . $item['quantity'] . '，价格：' . $item['product']['price'] . '<br>';
}
?>
<form method="POST">
    <input type="hidden" name="action" value="add">
    <select name="productId">
        <?php foreach ($products as $p): ?>
            <option value="<?php echo $p['id']; ?>"><?php echo $p['name']; ?></option>
        <?php endforeach; ?>
    </select>
    <input type="number" name="quantity" value="1">
    <button type="submit">加入购物车</button>
</form>

<?php
// 连接数据库
$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "test";

$conn = new mysqli($servername, $username, $password, $dbname);

// 执行查询语句
$sql = "SELECT * FROM users";
$result = $conn->query($sql);

// 输出查询结果
if ($result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        echo "ID: " . $row["id"] . "，姓名: " . $row["name"] . "，年龄: " . $row["age"] . "<br>";
    }
} else {
    echo "0 结果";
}

// 关闭数据库连接
$conn->close();
?>