<div class="container">
<cfquery name = "getlist" datasource="jeb48_shoppingcart">
    SELECT ProductID, ProductName, ProductQty, ProductPrice, ProductDescription, ProductPhoto
    FROM Products;
</cfquery>
          <div class="row">
            <div class="col-md-2"><b>Product Photo</b></div>
            <div class="col-md-2"><b>Product ID</b></div>
            <div class="col-md-2"><b>Product Name</b></div>
            <div class="col-md-2"><b>Quantity in Inventory</b></div>
            <div class="col-md-2"><b>Product Description</b></div>
            <div class="col-md-2"><b>Unit Price</b></div>
          </div !--row>
          <cfoutput query ="getlist">
          <div class="row  equallist">
            <div class="col-md-2">#getlist.ProductPhoto#</div>
            <div class="col-md-2">#getlist.ProductID#</div>
            <div class="col-md-2">#getlist.ProductName#</div>
            <div class="col-md-2"><div style="text-align:center">#getlist.ProductQty#</div></div>
            <div class="col-md-2"><div style="text-align:left">#getlist.ProductDescription#</div></div>
            <div class="col-md-2"><div style="text-align:left">#DollarFormat(getlist.ProductPrice)#
            <cfif #getlist.ProductQty# gt 0>
            <br><a href = "shoppingcart.cfm?productid=#getlist.productid#&qty=1&action=add">Add to Cart</a>
            <cfelse>
            <br>Out of Stock!
            </cfif>
          </div></div>
          </div !--row>
          </cfoutput>
        </div !--container>

<div class="container">
        <h3><center>Your Shopping Cart</center></h3>
        <cfparam name="url.productid" default="">
        <cfparam name="url.qty" default="">
        <cfquery name = "getCartItem" datasource="jeb48_shoppingcart">
           SELECT ProductID, ProductName, ProductQty, ProductPrice, ProductDescription, ProductPhoto
           FROM Products
           WHERE ProductID = #url.productid#;
        </cfquery>
          <div class="row">
            <div class="col-md-2"><b>Quantity In Cart</b></div>
            <div class="col-md-2"><b>Product ID</b></div>
            <div class="col-md-2"><b>Product Name</b></div>
            <div class="col-md-2"><b>Quantity in Inventory</b></div>
            <div class="col-md-2"><b>Product Description</b></div>
            <div class="col-md-2"><b>Unit Price</b></div>
          </div !--row>
        <cfoutput>
           <div class="row  equallist">
           <div class="col-md-2">#url.qty#</div>
           <div class="col-md-2">#getCartItem.ProductID#</div>
           <div class="col-md-2">#getCartItem.ProductName#</div>
           <div class="col-md-2"><div style="text-align:center">#getCartItem.ProductQty#</div></div>
           <div class="col-md-2"><div style="text-align:left">#getCartItem.ProductDescription#</div></div>
           <div class="col-md-2"><div style="text-align:left">#DollarFormat(getCartItem.ProductPrice)#</div></div>
           </div !--row>
        </cfoutput>
        <div class="row">
           <cfset Itemtotal = #getCartItem.ProductPrice# * #url.qty#>
           <cfset OrderTotal = Itemtotal>
           <cfset Tax = OrderTotal * 0.07>
           <cfset TotalOrderAmount = OrderTotal + Tax>
           <cfoutput>
              <center>
              Item Total: #DollarFormat(Itemtotal)#<br>
              Order Total: #DollarFormat(OrderTotal)#<br>
              Tax (7%): #DollarFormat(Tax)#<br>
              Total Order Amount: #DollarFormat(TotalOrderAmount)#<br>
              </center>
           </cfoutput>