1#@!#!123s

: / home3 / encodto1 / aviscollection.com /
Filename : wishlist.php
back
<?php include'style.php'; 
if ($_SESSION['customer_id'] =='') {
  echo '<script> window.location.href = "login";</script>';
}
$custId = $_SESSION['customer_id'];
$wishQuery = "SELECT * FROM wishlist WHERE customer_id = $custId";
$runQuery = mysqli_query($conn, $wishQuery) or mysqli_error($conn);
?>
<body>
<?php include'header.php'; ?>
<main class="main single-page">
<div class="page-header breadcrumb-wrap">
    <div class="container">
        <div class="breadcrumb">
            <a href="index.html" rel="nofollow">Home</a>
            <span></span> Pages
            <span></span> Wishlist
        </div>
    </div>
</div>
    
<section class="mt-50 mb-50">
    <div class="container">
        <div class="row">
            <div class="col-12">
                <div class="table-responsive">
                    <table class="table shopping-summery text-center">
                        <thead>
                            <tr class="main-heading">
                                <th scope="col" colspan="2">Product</th>
                                <th scope="col">category</th>
                                <th scope="col">Quantity</th>
                                <th scope="col">Remove</th>
                            </tr>
                        </thead>
                        <tbody>
                        <?php
                        while ( $wish = mysqli_fetch_array($runQuery)) {
                        $wish_Id = $wish['wish_id'];
                        $wishId = encryptor('encrypt', $wish_Id);

                        $productId = $wish['product_id'];
                        $pId = encryptor('encrypt', $productId);
                        // $productQuery = mysqli_query($conn, "SELECT * FROM products WHERE product_id = '$productId'") or mysqli_error($conn);
                        $productQuery = "SELECT * FROM products p INNER JOIN product_category pc ON p.product_category = pc.category_id INNER JOIN product_sub_category psc ON p.product_sub_id = psc.sub_category_id WHERE product_id = '$productId'";
                        $pQry = mysqli_query($conn, $productQuery);
                        echo $pCount = mysqli_num_rows($pQry);
                        $res = mysqli_fetch_assoc($pQry);
                        // $productName = $res['product_name'];
                        // $productPurity = $res['product_purity'];
                        // $productMetal = $res['product_metal'];
                        // $productWeight = $res['product_weight'];
                        ?>
                            <tr>
                                <td class="image product-thumbnail"><img src="admin/product-images/<?php echo $res['product_img1']; ?>" alt="#"></td>
                                <td class="product-des product-name">
                                    <h5 class="product-name"><a href="product-details?product=<?php echo $res['product_id']; ?>&sub_category=<?php echo $res['product_sub_id']; ?>"><?php echo $res['product_name']; ?></a></h5>
                                    <p class="font-xs">Color: <?php echo $res['product_color']; ?></p>
                                </td>
                                <td><span class="text-black font-weight-bold"><?php echo $res['sub_category_name']; ?> ( <?php echo $res['category_name']; ?> )</span></td>
                                <td class="text-center" data-title="Stock">
                                    <span class="color3 font-weight-bold">In Stock</span>
                                </td>
                                <td class="action" data-title="Remove">
                                    <a class="text-danger" href="enquiry_submit?wish_id=<?php echo $wishId ?>&wish_action=delete-item"><i class="fa-solid fa-trash"></i></a>
                                    

                                </td>
                            </tr>
                        <?php } ?>
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
</section>

</main>
<?php include'footer.php'; ?>
<!-- <script>
      Fancybox.bind('[data-fancybox="gallery"]', {
        l10n : Fancybox.l10n.de
      });    
    </script> -->
</body>
</html>