<?php 
require_once("header.php");

$fetch_at = mysqli_fetch_array(mysqli_query($connection,"SELECT * FROM `og_category` WHERE `category_id` = '".$_GET['category_id']."'"));
?>

			<!-- page template area start -->
			<section id="about" style="background:#eee;">
				<div class="container mt-0 pb-10 pt-10">
			        <div class="section-content">
					    <h1 class="title mt-5 mb-20" style="text-align:center;"><?php echo stripslashes($fetch_at['category_name']);?></h1>
						<div class="row multi-row-clearfix">
						    <div class="col-md-12">
							<?php
							$sql_product = "SELECT * FROM `og_products` WHERE `category_id` = '".$fetch_at['category_id']."' AND `product_status` = 'Active'";
							$exe_product = mysqli_query($connection,$sql_product);
							while($arr_product = mysqli_fetch_array($exe_product))
							{
								?>
							    <div class="col-md-3 pl-5 pr-5" data-nav="false">
							        <a href="product-details.php?product_id=<?php echo $arr_product['product_id'];?>">
								    <div class="item">
									    <div class="mb-20">							<div class="thumb">
											<img class="img-fullwidth" alt="" src="uploads/product/<?php echo stripslashes($arr_product['product_photo']);?>" style="border-top-right-radius: 7px; border-top-left-radius: 7px;">
    										</div>
    										<div class="p-5 pt-10 pb-10" style="text-align:center; border-top: 3px solid #d75500; box-shadow: -3px 5px 7px 0px #ddd; background-color:#fff; border-bottom-right-radius: 7px; border-bottom-left-radius: 7px;">
											<h4 class="mt-0 mb-5" style="color:#333;"><?php echo stripslashes($arr_product['product_name_english']);?></h4>
                                            <!--<p style="margin-bottom:5px; font-size:17px;"><b><span style="text-align:left;">&#8377;<?php echo $arr_product['price'];?></span>&nbsp;&nbsp;<span style="text-align:right; color:#F52C00">&#8377;<del><?php echo $arr_product['mrp'];?></del></span></b></p>-->
                                            <p style="margin-bottom:5px; font-size:17px; text-align:center; color:#d75500;"><b>&pound;<?php echo $arr_product['price'];?></b></p>
                                            </div>	
    									</div>
    								</div></a>
    							</div>
    							<?php
							}
							?>
							</div>
						</div>
					</div>
				</div>
			</section>
			<!-- page template area end -->
  
<?php require_once("footer.php");?>