<?php session_start();
include("db_config.php"); ?>
<!DOCTYPE html>
<html lang="en">
<meta http-equiv="content-type" content="text/html;charset=UTF-8" />
<head>
	<meta charset="utf-8">
	<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
	<link rel="canonical" href="https://www.orangegroceries.com/groceries" />
	<meta name="description" content=" ">
	<meta name="author" content="">
	<title>Orange Groceries</title>
	<?php include("css.php");?>
</head>
<body>
	<?php include("header.php");?>
<?php $page_name = str_replace(".php", "", basename($_SERVER['PHP_SELF']));
    $Current_URL = basename(dirname(__FILE__));
    $findid = (mysqli_query($conn, "SELECT * FROM category"));
    while ($res2=mysqli_fetch_array($findid)) {
        if(strtolower(str_replace(" ", "-", $res2["cat_name"])) == $page_name){
            $id = $res2["id"];
        }
    }	
?>	
<?php 
$id=$id;
$sql_scats="select sub_category.*,category.cat_name,category.id as cid,category.cat_banner from sub_category join category on sub_category.category_id=category.id where sub_category.category_id='$id'";
    $result_scats = mysqli_query($conn, $sql_scats);
$res_scats= mysqli_fetch_array($result_scats);
?>
	<section class="page-info section-padding border-bottom topthumb">
		<div class="container-fluid">
			<div class="row">
<div class="col-md-12">
				<a href="https://orangegroceries.com/index.php"> <span class="mdi mdi-home"></span> &nbsp; Home</a> <span class="mdi mdi-chevron-right"></span> <a href="#"><?php echo $res_scats['cat_name']; ?></a>
			</div>
</div>
		</div>
	</section>

	<section class="shop-list section-padding">
		<div class="container-fluid">
			<div class="row dscats">
				<div class="col-md-3" style="padding-right:0;">
					<div class="shop-filters ">
						<div class="card">
							<div class="card-header">
								<h5 class="mb-0">
									<button class="btn btn-link collapsed">
										<?php echo $res_scats['cat_name']; ?> <span class="mdi mdi-chevron-down float-right"></span> </button>
								</h5>
							</div>
							<div class="card-body card-shop-filters">
								<ul id="f1" class="checkboxes_list">
                       <?php $c_id=$res_scats['cid'];
                       $sql_cat="select category.* from category where category.id !='$c_id'";
                        $result_cat = mysqli_query($conn, $sql_cat);
                        while($res_cat = mysqli_fetch_array($result_cat)){ 
                            $cidd=$res_cat['id']; 
                          $cat_name=$res_cat['cat_name'];   
                         $category = strtolower(str_replace(" ", "-", $cat_name)); ?>
						<li class="custom-control">
							<label> <a href="https://orangegroceries.com/<?= "$category/$category.php"; ?>"><?php echo $res_cat['cat_name']; ?></a></label>
							</li><?php } ?>
									
								</ul>
							</div>
						</div>
					</div>
				</div>

				<div class="col-md-9">
					<div class="shop-head mb-1">
						<div class="mb-2">
							<img src="https://orangegroceries.com/admin/product/category/<?php echo $res_scats['cat_banner']; ?> " class="img-responsive">
						</div>
					<!-- 	<div class="btn-group float-right">
							<select name="speed" id="input-limit" class="option-drop" onchange="change_sort(this.value);">
								<option value="popularity">Popularity</option>
								<option value="price_l2h">Price Low To High</option>
								<option value="price_h2l">Price High To Low</option>
								<option value="latest">Fresh Arrivals</option>
							</select>
						</div> -->
						<h4 class="mb-1"><?php echo $res_scats['cat_name']; ?></h4>
					</div>
					<div class="row no-gutters">
						 <?php 
                   // $id=$_POST["id"];
                    $sql_scat="select sub_category.*,category.cat_name from sub_category join category on sub_category.category_id=category.id where sub_category.category_id='$id'";
                        $result_scat = mysqli_query($conn, $sql_scat);
                      while($res_scat= mysqli_fetch_array($result_scat)){
                         $cat_name=$res_scat['cat_name']; 
                         $category = strtolower(str_replace(" ", "-", $cat_name));
                         $scat_name=$res_scat['sub_category_name']; 
                         $sub_category = strtolower(str_replace(" ", "-", $scat_name));
                    ?>
						<div class="col-md-3 col-6 product">
							<div class="category-item">
                             <a href="https://orangegroceries.com/<?= "$category/$sub_category/$sub_category.php"; ?>">
								<img class="img-fluid" src="https://orangegroceries.com/admin/product/subcat/<?php echo $res_scat['sub_categoryimg']; ?>" style="height:200px;" alt="<?php echo $res_scat['sub_category_name']; ?>">
									<h6><?php echo $res_scat['sub_category_name']; ?> </h6>
									</a>
							</div>
						</div>
                        <?php } ?>
					</div>
				</div>
			</div>
		</div>
	</section>
	<?php include("footer.php");?>
	<?php include("js.php");?>

	<script>
		jQuery(function() {
			jQuery('#in1').fastLiveFilter('#f1');
		});

	</script>
</body>

</html>
