Products

Sort By

+ Price + + +

Filter By Brand

+ = 1) { + foreach($unique_brands as $brand_list){ + $checked_brand = []; + + if(empty($brand_list['brand'])) { + continue; + } + + if(isset($_GET['brands'])) { + $checked_brand = $_GET['brands']; + + if(in_array($brand_list['brand'], $checked_brand)) { + $valid_brands[] = $brand_list['brand']; + } + } + ?> +

+ > + +

+ + +

+ +

+ = 1) { + $all_products = mysqli_query($conn, "SELECT * FROM products WHERE category = \"$category\" AND brand IN ({$brand_parameter}) + ORDER BY (price - (price*discount/100.0)) ASC; + "); + } + else if($price_sort == 'low-to-high' && count($valid_brands) <= 0) { + $all_products = mysqli_query($conn, "SELECT * FROM products WHERE category = \"$category\" ORDER BY (price - (price*discount/100.0)) ASC;"); + } + else if($price_sort == 'high-to-low' && count($valid_brands) >= 1) { + $all_products = mysqli_query($conn, "SELECT * FROM products WHERE category = \"$category\" AND brand IN ({$brand_parameter}) + ORDER BY (price - (price*discount/100.0)) DESC; + "); + } + else if($price_sort == 'high-to-low' && count($valid_brands) <= 0) { + $all_products = mysqli_query($conn, "SELECT * FROM products WHERE category = \"$category\" ORDER BY (price - (price*discount/100.0)) DESC;"); + } + else if(count($valid_brands) >= 1) { + $all_products = mysqli_query($conn, "SELECT * FROM products WHERE category = \"$category\" AND brand IN ({$brand_parameter}) + ;"); + } + else { + $all_products = mysqli_query($conn, "SELECT * FROM products WHERE category = \"$category\";"); + } + } + else { + if($price_sort == 'low-to-high') { + $all_products = mysqli_query($conn, "SELECT * FROM products WHERE brand IN ({$brand_parameter}) + ORDER BY (price - (price*discount/100.0)) ASC; + "); + } + else if($price_sort == 'high-to-low') { + $all_products = mysqli_query($conn, "SELECT * FROM products WHERE brand IN ({$brand_parameter}) + ORDER BY (price - (price*discount/100.0)) DESC; + "); + } + else { + $all_products = mysqli_query($conn, "SELECT * FROM products WHERE brand IN ({$brand_parameter}) + ;"); + } + } + + if(mysqli_num_rows($all_products) >= 1) { + foreach($all_products as $product) { + ?> +

+ "> +

+ + + +

+ $ + +

+ +

+ No products

'; + } + } + else { + + if($category != 'All') { + if($price_sort == 'low-to-high') { + $all_products = mysqli_query($conn, "SELECT * FROM products WHERE category = \"$category\" ORDER BY (price - (price*discount/100.0)) ASC;"); + } + else if($price_sort == 'high-to-low') { + $all_products = mysqli_query($conn, "SELECT * FROM products WHERE category = \"$category\" ORDER BY (price - (price*discount/100.0)) DESC;"); + } + else { + $all_products = mysqli_query($conn, "SELECT * FROM products WHERE category = \"$category\";"); + } + } + else { + if($price_sort == 'low-to-high') { + $all_products = mysqli_query($conn, "SELECT * FROM products ORDER BY (price - (price*discount/100.0)) ASC;"); + } + else if($price_sort == 'high-to-low') { + $all_products = mysqli_query($conn, "SELECT * FROM products ORDER BY (price - (price*discount/100.0)) DESC;"); + } + else { + $all_products = mysqli_query($conn, "SELECT * FROM products;"); + } + } + + if(mysqli_num_rows($all_products) >= 1) { + foreach($all_products as $product) { + ?> +