cart.php

<?php
session_start();
include_once("header.php");
include('hms/include/config.php');
?>

<?php if (isset($_SESSION["showAlert"])): ?>
<div class="alert alert-success alert-dismissible mt-2">
    <button type='button' class='close' data-dismiss='alert'>&times;</button>
    <strong><?= htmlspecialchars($_SESSION["message"]) ?></strong>
</div>
<?php unset($_SESSION["showAlert"], $_SESSION["message"]); endif; ?>

<div class="container">
    <div class="row">
        <div class="col-12">
            <div class="table-responsive">
                <table class="table table-bordered table-striped text-center">
                    <thead class="thead-dark">
                        <tr>
                            <th>Product</th>
                            <th>MRP</th>
                            <th>Purchase Price</th>
                            <th>Discount</th>
                            <th>Quantity</th>
                            <th>Total Price</th>
                            <th>
                                <a href="action.php?clear=all" onClick="return confirm('Are you sure to clear cart?');" class="btn btn-sm btn-danger">Empty Cart</a>
                            </th>
                        </tr>
                    </thead>
                    <tbody>
                        <?php
                        $grand_total = 0;
                        $cart_items = mysqli_query($con, "SELECT * FROM cart");

                        if (mysqli_num_rows($cart_items) > 0):
                            while ($row = mysqli_fetch_assoc($cart_items)) {
                                $mrp = $row['proprice'];
                                $discounted = $row['prodiscount'];
                                $qty = $row['quantity'];
                                $discount = $mrp - $discounted;
                                $total_price = $discounted * $qty;
                                $grand_total += $total_price;
                        ?>
                        <tr data-id="<?= $row['cart_id'] ?>">
                            <td>
                                <img src="hms/images/<?= htmlspecialchars($row['proimg']) ?>" width="80" height="80" alt="Image"><br>
                                <?= htmlspecialchars($row['proname']) ?>
                            </td>
                            <td>Rs. <?= number_format($mrp, 2) ?></td>
                            <td>Rs. <?= number_format($discounted, 2) ?></td>
                            <td>Rs. <?= number_format($discount, 2) ?></td>
                            <td>
                                <input type="number" class="form-control itemQty text-center" value="<?= $qty ?>" min="1" style="width:80px;">
                                <input type="hidden" class="pid" value="<?= $row['cart_id'] ?>">
                                <input type="hidden" class="pprice" value="<?= $discounted ?>">
                            </td>
                            <td class="itemTotal">Rs. <?= number_format($total_price, 2) ?></td>
                            <td>
                                <a href="action.php?remove=<?= $row['cart_id'] ?>" onClick="return confirm('Remove this item?');" class="btn btn-sm btn-danger"><i class="fa fa-trash"></i></a>
                            </td>
                        </tr>
                        <?php } ?>
                        <tr>
                            <td colspan="4"></td>
                            <td><strong>Subtotal</strong></td>
                            <td colspan="2"><strong id="subtotal">Rs. <?= number_format($grand_total, 2) ?></strong></td>
                        </tr>
                        <tr>
                            <td colspan="4"></td>
                            <td><strong>Total</strong></td>
                            <td colspan="2"><strong id="total">Rs. <?= number_format($grand_total, 2) ?></strong></td>
                        </tr>
                        <?php else: ?>
                        <tr>
                            <td colspan="7">
                                <h4 class="text-center text-muted">Your cart is empty!</h4>
                            </td>
                        </tr>
                        <?php endif; ?>
                    </tbody>
                </table>
            </div>
        </div>

        <div class="col mb-2">
            <div class="row">
                <div class="col-sm-12 col-md-6">
                    <a href="index.php" class="btn btn-block btn-light"><i class="fa fa-shopping-cart"></i> Continue Shopping</a>
                </div>
                <div class="col-sm-12 col-md-6 text-right">
                    <a href="checkout.php" class="btn btn-md btn-block btn-success text-uppercase <?= ($grand_total > 0) ? '' : 'disabled'; ?>" style="background-color:pink;color:black;font-weight:bold;">Checkout</a>
                </div>
            </div>
        </div>
    </div>
</div>

<!-- Update Quantity Script -->
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script>
$(document).ready(function () {
    // change is an Event
    $('.itemQty').on('change', function () {
        const $row = $(this).closest('tr');
        const pid = $row.find('.pid').val();
        const pprice = parseFloat($row.find('.pprice').val());
        let qty = parseInt($(this).val());

        if (qty <= 0 || isNaN(qty)) {
            qty = 1;
            $(this).val(1);
        }

        $.ajax({
            url: 'action.php',
            method: 'POST',
            data: { pqty: qty, pid: pid, pprice: pprice },
            success: function () {
                const itemTotal = (pprice * qty).toFixed(2);
                $row.find('.itemTotal').text('Rs. ' + itemTotal);

                // Recalculate grand total
                let newTotal = 0;
                $('.itemTotal').each(function () {
                    const amount = parseFloat($(this).text().replace('Rs. ', ''));
                    if (!isNaN(amount)) newTotal += amount;
                });

                $('#subtotal, #total').text('Rs. ' + newTotal.toFixed(2));
            }
        });
    });
});
</script>

<?php include_once("footer.php"); ?>

<!-- cart.php file -->