PNG  IHDR pHYs   OiCCPPhotoshop ICC profilexڝSgTS=BKKoR RB&*! J!QEEȠQ, !{kּ> H3Q5 B.@ $pd!s#~<<+"x M0B\t8K@zB@F&S`cbP-`'{[! eDh;VEX0fK9-0IWfH  0Q){`##xFW<+*x<$9E[-qWW.(I+6aa@.y24x6_-"bbϫp@t~,/;m%h^ uf@Wp~<5j>{-]cK'Xto(hw?G%fIq^D$.Tʳ?D*A, `6B$BB dr`)B(Ͱ*`/@4Qhp.U=pa( Aa!ڈbX#!H$ ɈQ"K5H1RT UH=r9\F;2G1Q= C7F dt1r=6Ыhڏ>C03l0.B8, c˱" VcϱwE 6wB aAHXLXNH $4 7 Q'"K&b21XH,#/{C7$C2'ITFnR#,4H#dk9, +ȅ3![ b@qS(RjJ4e2AURݨT5ZBRQ4u9̓IKhhitݕNWGw Ljg(gwLӋT071oUX**| J&*/Tު UUT^S}FU3S ԖUPSSg;goT?~YYLOCQ_ cx,!k u5&|v*=9C3J3WRf?qtN (~))4L1e\kXHQG6EYAJ'\'GgSSݧ M=:.kDwn^Loy}/TmG X $ <5qo</QC]@Caaᄑ.ȽJtq]zۯ6iܟ4)Y3sCQ? 0k߬~OCOg#/c/Wװwa>>r><72Y_7ȷOo_C#dz%gA[z|!?:eAAA!h쐭!ΑiP~aa~ 'W?pX15wCsDDDޛg1O9-J5*>.j<74?.fYXXIlK9.*6nl {/]py.,:@LN8A*%w% yg"/6шC\*NH*Mz쑼5y$3,幄'L Lݛ:v m2=:1qB!Mggfvˬen/kY- BTZ(*geWf͉9+̳ې7ᒶKW-X潬j9(xoʿܔĹdff-[n ڴ VE/(ۻCɾUUMfeI?m]Nmq#׹=TR+Gw- 6 U#pDy  :v{vg/jBFS[b[O>zG499?rCd&ˮ/~јѡ򗓿m|x31^VwwO| (hSЧc3- cHRMz%u0`:o_F@8N ' p @8N@8}' p '#@8N@8N pQ9p!i~}|6-ӪG` VP.@*j>[ K^<֐Z]@8N'KQ<Q(`s" 'hgpKB`R@Dqj '  'P$a ( `D$Na L?u80e J,K˷NI'0eݷ(NI'؀ 2ipIIKp`:O'`ʤxB8Ѥx Ѥx $ $P6 :vRNb 'p,>NB 'P]-->P T+*^h& p '‰a ‰ (ĵt#u33;Nt̵'ޯ; [3W ~]0KH1q@8]O2]3*̧7# *p>us p _6]/}-4|t'|Smx= DoʾM×M_8!)6lq':l7!|4} '\ne t!=hnLn (~Dn\+‰_4k)0e@OhZ`F `.m1} 'vp{F`ON7Srx 'D˸nV`><;yMx!IS钦OM)Ե٥x 'DSD6bS8!" ODz#R >S8!7ّxEh0m$MIPHi$IvS8IN$I p$O8I,sk&I)$IN$Hi$I^Ah.p$MIN$IR8I·N "IF9Ah0m$MIN$IR8IN$I 3jIU;kO$ɳN$+ q.x* tEXtComment

Viewing File: /home/u423589436/domains/kingshomeandcomfort.com/public_html/shopping-cart.php

<?php
session_start();
?>
<!DOCTYPE html>
<html class="no-js" lang="en">

<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <title>Cart - King's Home & Comfort</title>
   <?php include("header-links.php"); ?>
</head>
<body class="biolife-body">

 <?php include("header.php"); ?>

 <!-- Add this to the <head> of your HTML document -->
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.3/css/all.min.css" integrity="sha512-bV5Bn8vks9y6QyjOGj5Bpx8F5IIqPJ8C2rG5MIJ7U2gAXLB8S/veBs5F5agf7owN6tJB3e3+Fo2gZS5mX4h0fAA==" crossorigin="anonymous" referrerpolicy="no-referrer" />

    <!--Hero Section-->
    <div class="hero-section hero-background">
        <h1 class="page-title">Shopping Cart</h1>
    </div>

    <!--Navigation section-->
    <div class="container">
        <nav class="biolife-nav">
            <ul>
                <li class="nav-item"><a href="index.php" class="permal-link">Home</a></li>
                <li class="nav-item"><span class="current-page">ShoppingCart</span></li>
            </ul>
        </nav>
    </div>

    <?php
// Check if the login_status parameter is set and equals "failed"
if (isset($_GET['status']) && $_GET['status'] === 'successful') {
    // Display a failure message
echo "<script>alert('Cart item was cleared')</script>";
}
?>
 


    <div class="page-contain shopping-cart">

        <!-- Main content -->
        <div id="main-content" class="main-content">
            <div class="container">

             
                <!--Cart Table-->
                <div class="shopping-cart-container">
                    <div class="row">
                        <div class="col-lg-9 col-md-12 col-sm-12 col-xs-12">
                            <h3 class="box-title">Your cart items</h3>
                            <form class="shopping-cart-form" action="#" method="post">
                                <table class="shop_table cart-form">
                                    <thead>
                                    <tr>
                                        <th class="product-name">Product Name</th>
                                        <th class="product-price">Price</th>
                                        <!--
                                        <th class="product-quantity">Quantity</th>
                                        
                                        <th class="product-subtotal">Total</th>
-->
                                    </tr>
                                    </thead>
                                    <tbody>

                                    <?php
include("connection.php");

$sql = "SELECT * FROM cart_tb WHERE user_id='$_SESSION[user_id]'";
$query = mysqli_query($conn, $sql);

if (!$query) {
    die("Error in cart query: " . mysqli_error($conn));
}

foreach ($query as $row) {
    $product_id = $row['product_id'];

    // Sanitize $product_id here if needed

    $sql2 = "SELECT * FROM products WHERE id='$product_id'";
    $query2 = mysqli_query($conn, $sql2);

    if (!$query2) {
        die("Error in products query: " . mysqli_error($conn));
    }

    while ($row2 = mysqli_fetch_array($query2)) {
        // Your HTML code to display product details goes here
        ?>
        <tr class="cart_item">
            <td class="product-thumbnail" data-title="Product Name">
                <?php
                echo "
                <a class='prd-thumb' href='single-product.php?id=$row2[id]'>
                ";
                ?>
                    <figure><img width="113" height="113" src="admin/<?php echo $row2['photo_path']; ?>" alt="shipping cart"></figure>
                </a>

                <?php
                echo "
                <a class='prd-name' href='single-product.php?id=$row2[id]'>
                     $row2[product_name]
                </a>
                ";

                ?>

                <div class="action">
                    <?php
                    echo "
                    <a href='remove-cart.php?id=$row[id]' class='remove'><i class='fas fa-trash' aria-hidden='true'></i></a>
                    "; ?>
                    </div>
            </td>
            <td class="product-price" data-title="Price">
                <div class="price price-contain">
                    <ins><span class="price-amount"><span class="currencySymbol">&#8358;</span><?php echo number_format($row2["sales_price"]); ?></span></ins>
                    <del><span class="price-amount"><span class="currencySymbol">&#8358;</span><?php echo number_format($row2["original_price"]); ?></span></del>
                </div>
            </td>

            <!--
            <td class="product-quantity" data-title="Quantity">
                <div class="quantity-box type1">
                    <div class="qty-input">
                        <input type="text" name="qty12554" value="1" data-max_value="20" data-min_value="1" data-step="1">
                        <a href="#" class="qty-btn btn-up"><i class="fa fa-caret-up" aria-hidden="true"></i></a>
                        <a href="#" class="qty-btn btn-down"><i class="fa fa-caret-down" aria-hidden="true"></i></a>
                    </div>
                </div>
            </td>
    -->
        </tr>
        <?php 
    }
}

// Close the database connection
mysqli_close($conn);
?>

                                   
                                    <tr class="cart_item wrap-buttons">
                                        <td class="wrap-btn-control" colspan="4">
                                            <a href="shop.php" class="btn back-to-shop">Back to Shop</a>
                                            <button class="btn btn-clear" name="clear_cart_btn" type="submit">clear all</button>
                                        </td>
                                    </tr>
                                    </tbody>
                                </table>
                            </form>
                        </div>
                        <div class="col-lg-3 col-md-12 col-sm-12 col-xs-12">
                            <div class="shpcart-subtotal-block">
                                <div class="subtotal-line">
                                    <b class="stt-name">Subtotal <span class="sub">
                                        
                                        <?php
include("connection.php");


$user_id = $_SESSION['user_id']; // Assuming 'user_id' is the correct key in your $_SESSION array

$sql = "SELECT COUNT(*) as no_of_items, SUM(p.sales_price) as total_sales
        FROM cart_tb c
        JOIN products p ON c.product_id = p.id
        WHERE c.user_id = '$user_id'";



$query = mysqli_query($conn, $sql);
$row = mysqli_fetch_array($query);

$no_of_items = $row['no_of_items'];
$total_sales = $row['total_sales'];

echo $no_of_items . " item(s)</span></b> ";
echo '<span class="stt-price">&#8358;' . number_format($total_sales) . '</span>';
?>
                                    
                                    
                                </div>
                               
                                <?php
                                 if(isset($_SESSION["username"])){

                                    include("connection.php");
                                    $sql="SELECT * FROM users WHERE username='$_SESSION[username]'";
                                    $query=mysqli_query($conn, $sql);
                                    $row=mysqli_fetch_array($query);
                                

                                
                                    
                                    $user_id = $_SESSION['user_id']; // Assuming 'user_id' is the correct key in your $_SESSION array

                                    $sql3 = "SELECT GROUP_CONCAT(product_name ORDER BY cart_tb.id SEPARATOR ', ') AS product_names
                                             FROM products
                                             INNER JOIN cart_tb ON products.id = cart_tb.product_id
                                             WHERE cart_tb.user_id = '$user_id'";
                                    
                                    
                                    $result3 = $conn->query($sql3);
                                    
                                    if ($result3->num_rows > 0) {
                                        // Fetch the result row
                                        $row3 = $result3->fetch_assoc();
                                        // Split the concatenated product names into an array
                                        $productNames = explode(', ', $row3['product_names']);
                                    
                                        $product_name=implode(', ', $productNames);
                                    
                                    } else {
                                        $productNames = []; // Initialize as an empty array if no products found
                                    }
                                    
                                    // Close the database connection
                                    $conn->close();

                                ?>
                              
                                
                            <form action="checkout.php" method="POST">
    <input type="hidden" name="username" value="<?php echo $_SESSION['username']; ?>">
    <input type="hidden" name="full_name" value="<?php echo $row['full_name']; ?>">
    <input type="hidden" name="email" value="<?php echo $row['email']; ?>">
    <input type="hidden" name="shipping_address" value="<?php echo $row['shipping_address']; ?>">

    <!-- Quantity Selector -->
    <div class="form-group">
        <label for="quantity">Quantity</label>
        <div class="input-group mb-3">
            <div class="input-group-prepend">
                <button type="button" class="btn btn-outline-secondary" onclick="changeQty(-1)">-</button>
            </div>
            <input type="number" class="form-control text-center" id="quantity" name="quantity" value="1" min="1" readonly>
            <div class="input-group-append">
                <button type="button" class="btn btn-outline-secondary" onclick="changeQty(1)">+</button>
            </div>
        </div>
    </div>

    <!-- Displayed Total -->
    <div class="form-group">
        <label>Total Amount</label>
        <input type="text" class="form-control" id="displayAmount" value="₦<?php echo number_format($total_sales); ?>" readonly>
    </div>

    <!-- Hidden Inputs -->
    <input type="hidden" id="baseAmount" value="<?php echo $total_sales; ?>">
    <input type="hidden" id="amount" name="amount" value="<?php echo $total_sales; ?>">
    <input type="hidden" name="product_name" value="<?php echo $product_name; ?>">

    <!-- Submit Button -->
    <button type="submit" name="checkout_btn" id="buy-now-link" style="background-color: red; border-radius: 20px; width: 100%" class="btn btn-danger btn-lg btn-rounded">
        <i class="fa fa-shopping-cart"></i> Buy Now <i class="fa fa-arrow-right"></i>
    </button>
</form>

<script>
  function changeQty(change) {
    const qtyInput = document.getElementById('quantity');
    const baseAmount = parseFloat(document.getElementById('baseAmount').value);
    let qty = parseInt(qtyInput.value) + change;

    if (qty < 1) qty = 1;

    qtyInput.value = qty;

    const newAmount = baseAmount * qty;

    document.getElementById('amount').value = newAmount;
    document.getElementById('displayAmount').value = "₦" + newAmount.toLocaleString();
  }
</script>


                                <?php }else{?>
                                    <div class="btn-checkout">


<a href="#" class="btn checkout" data-toggle="modal" data-target="#guestCheckoutModal">Guest Checkout</a>

                                </div>
                                    <?php } ?>
                                
                            </div>
                        </div>
                    </div>
                </div>

                <!-- related products -->
                <div class="product-related-box single-layout">
                    <div class="biolife-title-box lg-margin-bottom-26px-im">
                        <span class="fas fa-shopping-cart"></span>
                        <h3 class="main-title">Latest Products</h3>
                    </div>
                  
                    <style>
    .product-title a{
        font-weight: bolder;
    }
</style>



    <div class="block-item recently-products-cat md-margin-bottom-39">
    <ul class="products-list biolife-carousel nav-center-02 nav-none-on-mobile" data-slick='{"rows":1,"arrows":true,"dots":false,"infinite":false,"speed":400,"slidesMargin":0,"slidesToShow":5, "responsive":[{"breakpoint":1200, "settings":{ "slidesToShow": 3}},{"breakpoint":992, "settings":{ "slidesToShow": 3, "slidesMargin":30}},{"breakpoint":768, "settings":{ "slidesToShow": 2, "slidesMargin":10}}]}'>

        <?php
        include("connection.php");

        $sql = "SELECT * FROM products ORDER BY id DESC LIMIT 8";
        $query = mysqli_query($conn, $sql);

        while ($row = mysqli_fetch_array($query)):
            // Your loop code here
            $id = $row["id"];
            $product_name = $row["product_name"];
            $product_category = $row["product_category"];
            $sales_price = $row["sales_price"];
            $original_price = $row["original_price"];
            $description = $row["description"];
            $photo_path = $row["photo_path"];
            $created_at = $row["created_at"];

            // Truncate long product and description names
            $trimmed_product_name = strlen($product_name) > 15 ? substr($product_name, 0, 15) . "..." : $product_name;
            $trimmed_description = strlen($description) > 15 ? substr($description, 0, 35) . "..." : $description;
        
          
        ?>

        <li class="product-item">
            <div class="contain-product layout-02">
                <div class="product-thumb">
                <?php echo "
            <a href='single-product.php?id=$row[id]' class='link-to-product'>
                <img src='admin/$photo_path' alt='$product_name' width='270' style='max-height: 270px; min-height: 270px; object-fit: cover' class='product-thumnail'>
            </a>
            ";
            ?>
                </div>
                <div class="info">
                <h4 class="product-title">
                <?php echo "<a href='single-product.php?id=$row[id]' class='pr-name'>$trimmed_product_name</a>"; ?>
                </h4>
                </div>

                <div class="price text-center" style="font-weight: bolder;">
                <ins style="text-decoration: none;"><span class="price-amount"><span class="currencySymbol">&#8358;</span><?php echo number_format($sales_price); ?></span></ins>
                <del><span style="color: red;" class="price-amount"><span class="currencySymbol">&#8358;</span><?php echo number_format($original_price); ?></span></del>
                <div class="buttons">
                   <?php echo "
                   <a href='checkout.php?id=$row[id]' class='btn btn-danger' style='background-color: red; border: none;'>Learn more/Buy</a>
                    ";
                    ?>
                   </div>
            
                </div>

            </div>
        </li>

        <?php endwhile; ?>

    </ul>
</div>

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

     <!-- Modal -->
<div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
  <div class="modal-dialog" role="document">
    <div class="modal-content">
      <div class="modal-header">
        <h5 class="modal-title" id="myModalLabel">
        <?php
        include("connection.php");
        $sql="SELECT * FROM reviews WHERE product_id='$_GET[id]'";
        $query=mysqli_query($conn,$sql);
       
            $no_of_rows=mysqli_num_rows($query);
            if($no_of_rows>0){
        
        ?>
        
        Here is what people have to say about <i style="font-weight: bolder; color: green"><?php echo $row2["product_name"]; ?></i></span>
        
        <?php 
                
            }else{
                echo '
                <div class="alert-warning p-3">No reviews yet! Be the first to give your thoughts</div>
                ';
            }
        
        
        
        ?>
                </h5>
        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
          <span aria-hidden="true">&times;</span>
        </button>
      </div>
      <div class="modal-body">
     <?php
$select_all_reviews = "SELECT * FROM reviews WHERE product_id = '$_GET[id]' ORDER BY RAND()";
$query_selection=mysqli_query($conn,$select_all_reviews);
        while($row=mysqli_fetch_array($query_selection)):
        ?>

      <span class="mt-0"><b><?php echo $row["your_name"]; ?></b></span>
       <p style="font-family: roboto;"><?php echo $row["your_comment"]; ?></p>
       
       <hr>

       <?php endwhile; ?>
    
    </div>
      <div class="modal-footer">
        <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
      </div>
    </div>
  </div>
</div>

            </div>
        </div>
    </div>
<!-- Guest Checkout Modal -->
<div class="modal fade" id="guestCheckoutModal" tabindex="-1" role="dialog" aria-labelledby="guestCheckoutModalLabel" aria-hidden="true">
  <div class="modal-dialog" role="document">
    <div class="modal-content">

      <!-- Modal Header -->
      <div class="modal-header">
        <h5 class="modal-title" id="guestCheckoutModalLabel">Guest Checkout</h5>
        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
          <span aria-hidden="true">&times;</span>
        </button>
      </div>

      <!-- Modal Body -->
      <div class="modal-body">

        <!-- Form Start -->
        <form action="guest-checkout.php" method="POST">

          <div class="form-group">
            <label for="fullName">Full Name*</label>
            <input type="text" class="form-control" id="fullName" name="full_name" required>
          </div>

          <div class="form-group">
            <label for="phone">Email*</label>
            <input type="email" class="form-control" id="phone" name="email" required>
          </div>

          <div class="form-group">
            <label for="shippingAddress">Shipping Address*</label>
            <textarea class="form-control" id="shippingAddress" placeholder="E.g. 2, Johnson Street, Off Sapele Rd. Benin City." name="shipping_address" required></textarea>
          </div>

          <?php
          include("connection.php");

          session_start(); // Ensure session is started
          $user_id = $_SESSION['user_id'];

          $sql = "SELECT COUNT(*) as no_of_items, SUM(p.sales_price) as total_sales
                  FROM cart_tb c
                  JOIN products p ON c.product_id = p.id
                  WHERE c.user_id = '$user_id'";

          $query = mysqli_query($conn, $sql);
          $row = mysqli_fetch_array($query);

          $total_sales = $row['total_sales'] ?? 0;

          $sql2 = "SELECT GROUP_CONCAT(product_name ORDER BY cart_tb.id SEPARATOR ', ') AS product_names
                   FROM products
                   INNER JOIN cart_tb ON products.id = cart_tb.product_id
                   WHERE cart_tb.user_id = '$user_id'";

          $result2 = $conn->query($sql2);
          $product_name = "";
          if ($result2->num_rows > 0) {
              $row2 = $result2->fetch_assoc();
              $productNames = explode(', ', $row2['product_names']);
              $product_name = implode(', ', $productNames);
          }

          $conn->close();
          ?>

          <!-- Quantity Selector -->
          <div class="form-group">
            <label for="quantity">Quantity</label>
            <div class="input-group">
              <div class="input-group-prepend">
                <button class="btn btn-outline-secondary" type="button" onclick="changeQty(-1)">-</button>
              </div>
              <input type="number" class="form-control text-center" id="quantity" name="quantity" value="1" min="1" readonly>
              <div class="input-group-append">
                <button class="btn btn-outline-secondary" type="button" onclick="changeQty(1)">+</button>
              </div>
            </div>
          </div>

          <!-- Displayed Total -->
          <div class="form-group">
            <label>Total Amount</label>
            <input type="text" class="form-control" id="displayAmount" value="₦<?php echo number_format($total_sales); ?>" readonly>
          </div>

          <!-- Hidden Fields to Submit -->
          <input type="hidden" id="baseAmount" value="<?php echo $total_sales; ?>">
          <input type="hidden" id="amount" name="amount" value="<?php echo $total_sales; ?>">
          <input type="hidden" name="product_name" value="<?php echo $product_name; ?>">

          <button type="submit" name="guest_checkout" class="btn btn-danger">Continue</button>

        </form>
        <!-- Form End -->

      </div>

      <!-- Modal Footer -->
      <div class="modal-footer">
        <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
      </div>

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

<!-- Quantity Update Script -->
<script>
  function changeQty(change) {
    const qtyInput = document.getElementById('quantity');
    const baseAmount = parseFloat(document.getElementById('baseAmount').value);
    let qty = parseInt(qtyInput.value) + change;

    if (qty < 1) qty = 1;

    qtyInput.value = qty;

    const newAmount = baseAmount * qty;

    document.getElementById('amount').value = newAmount;
    document.getElementById('displayAmount').value = "₦" + newAmount.toLocaleString();
  }
</script>



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

  <?php include("footer-links.php"); ?>

</body>

</html>


<?php

if(isset($_POST["clear_cart_btn"])){
include("connection.php");

$user_id = $_SESSION['user_id']; // Assuming 'user_id' is the correct key in your $_SESSION array


$sql="DELETE FROM cart_tb WHERE user_id='$user_id'";

$query_run=mysqli_query($conn, $sql);

if($query_run){    

echo "<script>window.location='shop.php?status=successful'</script>";
}
else{
    echo "<script>alert('Something went wrong')</script>";
}

}

?>
Back to Directory=ceiIENDB`