如何为购物车页面编写PHP多类别判断条件？

Hey there! Let's tackle your problem—you're trying to display items from both products and fruits tables in your cart, but you're stuck on how to tell which table each item belongs to, plus you want a more efficient solution overall. Let's break this down step by step.

First: The Core Issues in Your Current Code #

Your existing code has three key problems:

• You’re missing condition logic to identify item categories (since your cart only stores IDs, there’s no way to know if an item is a product or fruit).
• Directly interpolating $key into your SQL query creates a critical SQL injection risk.
• Running a separate query for every cart item is inefficient if you have multiple items.

The Best Solution: Fix Your Cart Data Structure #

The root fix is to store more context when adding items to the cart. Instead of only saving the item ID, also save the item type (e.g., 'product' or 'fruit'). This makes your cart logic clear and reliable.

Step 1: Update How You Add Items to Cart #

When a user adds a product or fruit to their cart, store both the ID and type in your cart session/array. For example:

// Adding a product to cart
$_SESSION['cart'][] = ['id' => 123, 'type' => 'product'];

// Adding a fruit to cart
$_SESSION['cart'][] = ['id' => 456, 'type' => 'fruit'];

Step 2: Rewrite Your Cart Page Logic #

Now you can easily check the type to know which table to query, plus use prepared statements to eliminate SQL injection risks:

<?php
$total = 0;
// Assume $cart is your cart array pulled from the session
foreach ($cart as $item) {
    $itemId = $item['id'];
    $itemType = $item['type'];
    $product = null;

    // Select the correct table based on item type
    if ($itemType === 'product') {
        $stmt = mysqli_prepare($connection, "SELECT * FROM products WHERE id = ?");
    } elseif ($itemType === 'fruit') {
        $stmt = mysqli_prepare($connection, "SELECT * FROM fruits WHERE id = ?");
    } else {
        continue; // Skip items with unknown types
    }

    // Bind the ID parameter and execute the query
    mysqli_stmt_bind_param($stmt, 'i', $itemId);
    mysqli_stmt_execute($stmt);
    $result = mysqli_stmt_get_result($stmt);
    $product = mysqli_fetch_assoc($result);

    // Process and display the item if found
    if ($product) {
        $total += $product['price']; // Adjust 'price' to your actual column name
        // Customize this HTML to match your cart layout
        echo "<div class='cart-item'>
                <h4>{$product['name']}</h4>
                <p>Price: $" . number_format($product['price'], 2) . "</p>
              </div>";
    }
}

// Display the total
echo "<div class='cart-total'>
        <strong>Total: $" . number_format($total, 2) . "</strong>
      </div>";
?>

Alternative: If You Can’t Modify the Cart Structure #

If you’re unable to add the type field to your cart, you can check both tables sequentially—but this is less efficient and risky (if an ID exists in both tables, you’ll pull the wrong item):

<?php
$total = 0;
foreach ($cart as $itemId => $value) {
    $product = null;

    // First check the products table
    $stmt = mysqli_prepare($connection, "SELECT * FROM products WHERE id = ?");
    mysqli_stmt_bind_param($stmt, 'i', $itemId);
    mysqli_stmt_execute($stmt);
    $result = mysqli_stmt_get_result($stmt);
    $product = mysqli_fetch_assoc($result);

    // If not found, check the fruits table
    if (!$product) {
        $stmt = mysqli_prepare($connection, "SELECT * FROM fruits WHERE id = ?");
        mysqli_stmt_bind_param($stmt, 'i', $itemId);
        mysqli_stmt_execute($stmt);
        $result = mysqli_stmt_get_result($stmt);
        $product = mysqli_fetch_assoc($result);
    }

    if ($product) {
        $total += $product['price'];
        echo "<div>{$product['name']} - {$product['price']}</div>";
    }
}
?>

⚠️ Warning: This approach runs two queries per item and can cause errors if duplicate IDs exist across tables. Use it only as a last resort.

Even Better: Normalize Your Database #

For long-term scalability, consider merging products and fruits into a single items table with a category column. This eliminates the need to handle separate tables entirely:

• Table items has columns: id, name, price, category (values: 'product' or 'fruit')
• Your cart only needs to store item IDs
• Query becomes a single, simple statement:

$stmt = mysqli_prepare($connection, "SELECT * FROM items WHERE id = ?");

This makes your code cleaner, easier to maintain, and ready to add more categories (like 'vegetables') later without rewriting cart logic.

内容的提问来源于stack exchange，提问作者zain ul abideen