As i add some items in the cart i cant change the status in the database from "ADDED TO CART " to "CONFIRMED"

```html
<!DOCTYPE html>
<!--
To change this license header, choose License Headers in Project Properties.
To change this template file, choose Tools | Templates
and open the template in the editor.
-->
<?php
require 'includes/common.php';

if (!isset($_SESSION['email']))
{
    header('location: index.php');
}
?>
<html>
    <head>
        <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" >
    <!--jQuery library--> 
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>
    <!--Latest compiled a>
        <meta charset="UTF-8">nd minified JavaScript--> 
    <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
    <link href="style.css" rel="stylesheet" type="text/css"/>
        <title>Lifestyle Store | Products</title>
        <meta charset="UTF-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
    </head>
    <body >
          <?php
        include 'includes/header.php';
        ?>
        <?php
        $user_id=$_SESSION['id'];
        //changed from above user_id to $_getc ['user_id']
        $items_query="SELECT items.id,items.name,items.price from items INNER JOIN user_items INNER JOIN users ON items.id=user_items.item_id AND user_items.user_id=users.id WHERE user_items.user_id= $user_id AND user_items.status='Added To Cart'";

        // chaged from select * from user_items inner join items on user_items.item_id=items.id where items.id=$user_id";

        $items_query_result= mysqli_query($con, $items_query) or die(mysqli_error($con));

        ?>

       <?php  if (mysqli_num_rows($items_query_result)==0){ ?> 
       <?php echo 'Add something in cart';  }  else  { ?>
        <div class="container">
             <div class="row decor_bg">
                <div class="col-md-6 col-md-offset-3">
                    <table class="table table-striped">
                        <thead>
                            <tr>

                                <th>Item Number</th>
                                <th>Item Name</th>
                                <th>Price</th>
                                <th>Total</th>

                            </tr>
                        </thead>

                        <tbody>
                            <?php 

                                $total=0;
                                    while ($row= mysqli_fetch_array($items_query_result)) {  
                                        $total+=$row['price'];

                                                                                             ?>

                            <tr>

                                    <td><?php echo $row['id']  ?> </td> <td >  <?php echo $row['name'];   ?> <a href="cart-remove.php?id=<?php echo $row['id']; ?>" class='remove_item_link ' style="color:#e53939">Remove </a> </td>   <td> Rs. <?php   echo $row['price']; } ?>  </td><td> Rs. <?php echo $total;?>  <a href="success.php?id=" class='btn btn-primary'>Confirm Order</a></td>
                            </tr>

                        </tbody>
                    </table>
                </div>
            </div>
        </div>
                             <?php }?>

             <?php 
        include 'includes/footer.php';
        ?>

    </body>
</html>
```

1. **this is the code for a shopping cart**
2. **user add some this in the cart**
3. \*\*then when the user goes to the cart the cart displays all the items with their ids, name and the price \*\*
4. **and finally the total price**
5. \*\*i have defined a while loop to sum up the price and to display the id name etc \*\*
6. **now i want to send the item id to the success.php to change the status in the database from "Added To Cart " to "Confirmed"**