1#@!#!123s

: / home3 / encodto1 / shreeganapatitrading.com /
Filename : products.php
back
<?php 
$category = $_GET['category'];
$cat = "";
$page_title = "";

// Sorting logic
$sort_order = isset($_GET['sort']) ? $_GET['sort'] : 'ASC'; // Default sorting is ascending

?>
<!DOCTYPE html>
<html>
<?php include 'style.php'; 

// Fetch category name
$view_cat = mysqli_query($conn,  "SELECT * FROM product_category WHERE category_id = '$category'") or mysqli_error($conn);
if ($view_cat-> num_rows > 0) {
    while($cat = mysqli_fetch_assoc($view_cat)) {
        $page_title = $cat['category_name'];
    }
}

?>

<body>
<div class="page-wrapper">
<?php include 'header.php'; ?>

<section class="page-title" style="background-image: url(images/background/9.jpg)">
    <div class="auto-container">
		<ul class="bread-crumb clearfix">
			<li><a href="./">Home</a></li>
			<li><a href="">Pages</a></li>
			<li><?php echo $page_title; ?></li>
		</ul>
		<h2><?php echo $page_title; ?></h2>
    </div>
</section>

<div class="project-detail-section">
	<div class="auto-container">
		<div class="sec-title centered">
			<div class="title">Best Quality Products</div>
			<h2>We deal with best Products</h2>
		</div>

		<!-- Sorting Dropdown -->
		<div class="row mb-3">
			<div class="col-md-4">
				<form method="GET" action="">
					<input type="hidden" name="category" value="<?php echo $category; ?>" />
					<label for="sort" class="form-label">Sort Products:</label>
					<select name="sort" id="sort" class="form-select" onchange="this.form.submit()">
						<option value="ASC" <?php if ($sort_order == 'ASC') echo 'selected'; ?>>A to Z</option>
						<option value="DESC" <?php if ($sort_order == 'DESC') echo 'selected'; ?>>Z to A</option>
					</select>
				</form>
			</div>
		</div>

		<div class="row">
			<div class="col-lg-12 col-md-6 col-sm-12 col-xs-12">
				<div class="product_box">
					<div class="row clearfix">
<?php
// Modify query to handle sorting based on user selection
$view_product = mysqli_query($conn, "SELECT * FROM products WHERE product_category = '$category' ORDER BY product_name $sort_order");
$product = "";
if ($view_product-> num_rows > 0) {
    while($product = mysqli_fetch_assoc($view_product)) { 
        $price = $product['product_price'];
        $off = $product['product_offer'];
        $off_price = $price-($price * $off/100);
?>
						<div class="col-lg-3 col-md-4 col-sm-12">
							<div class="product_item">
								<div class="product_img">
									<img src="admin/product-images/<?php echo $product['product_img']; ?>" alt="<?php echo $product['product_name']; ?>" />
								</div>
								<div class="product_info">
									<h4><?php echo $product['product_name']; ?></h4>
									<h6><i class="fa fa-tags" aria-hidden="true"></i> Category: <span><?php echo $page_title; ?></span></h6>
									<?php if ($price > 0) { ?>
										<ul class="list-inline">
											<li class="list-inline-item"><i class="fa fa-inr"></i> <?php echo $off_price; ?></li>
											<li class="list-inline-item"><i class="fa fa-inr"></i> <s><?php echo $product['product_price']; ?></s></li>
											<li class="list-inline-item"><span class="off_span"><?php echo $product['product_offer']; ?>% Off</span></li>
										</ul>
									<?php } ?>
									<a href="product-details.php?id=<?php echo $product['product_id']; ?>">view details <i class="fa fa-angle-double-right"></i></a>
								</div>
							</div>
						</div>
<?php } } ?>

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

<?php include 'footer.php'; ?>
</body>
</html>