1#@!#!123s

: / home3 / encodto1 / slg.encodersunlimited.com /
Filename : products.php
back
<?php
include 'config.php'; // Database connection
session_start();

// Assuming user is logged in and we have their ID stored in session
$user_id = isset($_SESSION['user_id']) ? $_SESSION['user_id'] : 0;

// Fetch categories for filter
$categoryQuery = "SELECT * FROM product_category";
$categoryResult = mysqli_query($conn, $categoryQuery);

// Initialize filter conditions
$whereClauses = [];

if (!empty($_GET['category'])) {
    $category = mysqli_real_escape_string($conn, $_GET['category']);
    $whereClauses[] = "p.category_id = '$category'";
}

if (!empty($_GET['price'])) {
    switch ($_GET['price']) {
        case '0-500':
            $whereClauses[] = "p.price BETWEEN 0 AND 500";
            break;
        case '501-1000':
            $whereClauses[] = "p.price BETWEEN 501 AND 1000";
            break;
        case '1001-2000':
            $whereClauses[] = "p.price BETWEEN 1001 AND 2000";
            break;
        case '2001-4000':
            $whereClauses[] = "p.price BETWEEN 2001 AND 4000";
            break;
    }
}

if (!empty($_GET['age_category'])) {
    $age_category = mysqli_real_escape_string($conn, $_GET['age_category']);
    $whereClauses[] = "p.age_category = '$age_category'";
}

// Construct query
$query = "SELECT p.*, c.category_name, 
          (SELECT COUNT(*) FROM product_wishlist w WHERE w.user_id = '$user_id' AND w.product_id = p.id) AS is_wishlisted 
          FROM slgtoys_products p 
          JOIN product_category c ON p.category_id = c.category_id";

if (!empty($whereClauses)) {
    $query .= " WHERE " . implode(" AND ", $whereClauses);
}

$result = mysqli_query($conn, $query);
?>

<!DOCTYPE html>
<html lang="en">

<head>
    <title>Products</title>
    <html class="no-js" lang="zxx">

    <!-- Bootstrap CSS -->
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.3/dist/css/bootstrap.min.css" rel="stylesheet">

    <!-- Bootstrap JS Bundle (includes Popper) -->
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.3/dist/js/bootstrap.bundle.min.js"></script>


</head>

<body>

    <?php

    include 'header.php';


    ?>

    <div class="breadcumb-wrapper" data-bg-src="assets/img/bg/breadcrumb-bg.png">
        <div class="container">
            <div class="breadcumb-content">
                <h1 class="breadcumb-title" data-cue="slideInUp">Shop Grid</h1>
                <ul class="breadcumb-menu">
                    <li data-cue="slideInUp" data-delay="100"><a href="index.php">Home</a></li>
                    <li data-cue="slideInUp" data-delay="100">Shop Grid</li>
                </ul>
            </div>
        </div>
    </div>


    <section class="mt-50 space-extra-bottom" id="blog-sec">
        <div class="container">
            <div class="row justify-content-center flex-row-reverse">
                <div class="col-xl-3 col-lg-4 sidebar-wrap">
                    <aside class="sidebar-area">
                        <div class="widget widget_categories2" data-cue="slideInUp">
                            <h3 class="widget_title">
                                <h2>Shop By Categories</h2>
                            </h3>
                            <form action="" method="get">
                                <select name="category">
                                    <option value="">All Categories</option>
                                    <?php while ($cat = mysqli_fetch_assoc($categoryResult)) { ?>
                                        <option value="<?php echo $cat['category_id']; ?>" <?php echo (isset($_GET['category']) && $_GET['category'] == $cat['category_id']) ? 'selected' : ''; ?>>
                                            <?php echo $cat['category_name']; ?>
                                        </option>
                                    <?php } ?>
                                </select>

                                <label>Price Range:</label>
                                <select name="price">
                                    <option value="">All Prices</option>
                                    <option value="0-500">RS. 10 - RS. 500</option>
                                    <option value="501-1000">RS. 501 - RS. 1000</option>
                                    <option value="1001-2000">RS. 1001 - RS. 2000</option>
                                    <option value="2001-4000">RS. 2000 and above</option>
                                </select>

                                <button type="submit" class="btn btn-primary">Apply Filters</button>
                            </form>

                        </div>
                    </aside>
                </div>
            </div>
        </div>
    </section>











    <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>

    <script>
        var isLoggedIn = <?php echo ($user_id > 0) ? 'true' : 'false'; ?>;

        $(document).ready(function() {
            $(".wishlist-btn").click(function() {
                if (!isLoggedIn) {
                    alert("You must login first!");
                    return;
                }

                var button = $(this);
                var productId = button.data("product-id");

                $.ajax({
                    url: "wishlist_handler.php",
                    method: "POST",
                    data: {
                        product_id: productId
                    },
                    success: function(response) {
                        if (response == "added") {
                            button.html("❤️");
                        } else {
                            button.html("🤍");
                        }
                    }
                });
            });

            $(".add-to-cart").click(function() {
                if (!isLoggedIn) {
                    alert("You must login first!");
                    return;
                }

                var button = $(this);
                var productId = button.data("product-id");

                $.ajax({
                    url: "cart_handler.php",
                    method: "POST",
                    data: {
                        product_id: productId,
                        action: "add"
                    },
                    success: function(response) {
                        alert("Product added to cart!");
                    }
                });
            });
        });
    </script>

</body>

</html>