Hello,

I am trying to update or delete item from cart but it;s not oking

    session_start();
    include("includes/layout/header.php");
    include_once("includes/connection.php");
    function get_product_name($pid){

        global $connection;
        $result=mysqli_query($connection, "select product_name from products where prod_id=$pid");
        $row=mysqli_fetch_array($result);
        return $row['product_name'];
    }

    function get_price($pid){
    global $connection;
        $result=mysqli_query($connection, "select product_price from products where prod_id=$pid");
        $row=mysqli_fetch_array($result);
        return $row['product_price'];
    }
    function get_order_total(){
        $max=count($_SESSION['cart']);
        $sum=0;
        for($i=0;$i<$max;$i++){
            $pid=$_SESSION['cart'][$i]['productid'];
            $q=$_SESSION['cart'][$i]['qty'];
            $price=get_price($pid);
            $sum+=$price*$q;
        }
        return $sum;
    }
?>
<script language="javascript">
    function del(pid){
        if(confirm('Do you really mean to delete this item')){
            document.form1.pid.value=pid;
            document.form1.command.value='delete';
            document.form1.submit();
        }
    }
    function clear_cart(){
        if(confirm('This will empty your shopping cart, continue?')){
            document.form1.command.value='clear';
            document.form1.submit();
        }
    }
    function update_cart(){
        document.form1.command.value='update';
        document.form1.submit();
    }


</script>    

Code for cart

<form name="form1" method="post">
            <div id="cart">
            <div class="cart-items">
                                                <table class="styled-table">
                                                    <thead>
                                                        <tr>
                                                            <th class="col_product text-left">Product</th>
                                                            <th class="col_remove text-right">&nbsp;</th>
                                                            <th class="col_qty text-right">Qty</th>
                                                            <th class="col_single text-right">Single</th>                                                         
                                                            <th class="col_total text-right">Total</th>
                                                        </tr>
                                                    </thead>
                                                    <?php
if(is_array($_SESSION['cart'])){
$max=count($_SESSION['cart']);
                for($i=0;$i<$max;$i++){
                    $pid=$_SESSION['cart'][$i]['productid'];
                    $q=$_SESSION['cart'][$i]['qty'];
                    $pname=get_product_name($pid);
                    if($q==0) continue;
            ?>
                                                    <tbody>                                  

                                                        <tr>
                                                            <td class="col_product text-left">
                                                                <div class="image visible-desktop">
                                                                    <span class="single-price"><?=get_product_name($pid)?></span>
                                                                </div>
                                                            </td>

                                                            <td class="col_remove text-right">
                                                                <a href="javascript:del(<?=$pid?>)">Remove</a>
                                                                    <i class="icon-trash icon-large"></i>
                                                                </a>
                                                            </td>

                                                            <td class="col_qty text-right">
                                                                <input type="text" name="product<?=$pid?>" value="<?=$q?>" maxlength="3" size="2" >
                                                            </td>

                                                            <td class="col_single text-right">
                                                                <span class="single-price">$<?=get_price($pid)?></span>
                                                            </td>
<?php

}
?>
                                                            <td class="col_total text-right">
                                                                <span class="total-price">$<?=get_order_total()?></span>
                                                            </td>
                                                        </tr>
                                                    </tbody>
                                                </table>
                                            </div>
            </div>

            <div class="box-footer">
                            <div class="pull-left">
                                <input type="button" class="btn btn-small" value="Continue Shopping" onclick="window.location='index.php'" />        
                            </div>

                            <div class="pull-right">
                                   <input type="button" value="Update Cart" onclick="update_cart()" class="btn btn-small mm20">

                                    <input type="button" value="Place Order" class="btn btn-primary btn-small mm20" onclick="window.location='billing.php'">

                                    </form>
                            </div>
                        </div>

Can anyone help me out with this concirn if available

Can anyone help me out with this concirn

What exactly is not working? Are you getting an error? What are you trying to achieve?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.