1#@!#!123s

: / home2 / technoi4 / www / demo /
Filename : categary.php
back
<?php include_once('header.php'); ?>
<style>
    .post-image:hover .img-fluid {
      opacity: 0.2;
    }
</style>
<div id="banner-area" class="banner-area" style="background-image:url(images/mission.jpg)">
    <div class="banner-text">
        <div class="container">
            <div class="row">
                <div class="col-lg-12">
                    <div class="banner-heading">
                        <h1 class="banner-title">Product Range</h1>
                        <nav aria-label="breadcrumb">
                            <ol class="breadcrumb justify-content-center">
                                <li class="breadcrumb-item"><a href="#">Home</a></li>
                                <li class="breadcrumb-item"><a href="#">Product Range</a></li>
                                <li class="breadcrumb-item active" aria-current="page">Product Range</li>
                            </ol>
                        </nav>
                    </div>
                </div> 
            </div>
        </div>
    </div>
</div>
<section id="main-container" class="main-container">
    <div class="container">
        <div class="row">
            <div class="col-md-3">
                <div class="sidebar sidebar-left">
                    <div class="widget">
                        <h3 class="widget-title">Categories</h3>
                        <ul class="arrow nav nav-tabs">
                            <?php
								include("config.php");
								$query=mysqli_query($conn,"select * from categary");
								foreach ($query as $row) {	
							?>
							<li><a href="#" class="link" data-artid="<?php echo $row['id']; ?>"><?php echo $row['categary_title']; ?></a></li>
							<?php } ?>
                        </ul>
                    </div>
					<div class="widget">
                        <h3 class="widget-title">Brand</h3>
						<div id="result"></div>
                        <ul class="arrow nav nav-tabs default-category">
                            <?php
								include("config.php");
								$query=mysqli_query($conn,"select * from brand");
								foreach ($query as $row) {	
							?>
							<li><a href="#" class="link brand" data-artid="<?php echo $row['id']; ?>"><?php echo $row['brand_name']; ?></a></li>
							<?php } ?>
                        </ul>
                    </div>
                </div>
            </div>
            		
			
			<div class="col-md-9">
				<div class="row">
					<div class="col-md-4">
					</div>
				</div>
                <div class="row">
                    <?php
						include("config.php");
						$query=mysqli_query($conn,"SELECT product.*, brand.id as bid, brand.brand_name, categary.id as cid, categary.categary_title FROM `product` LEFT JOIN categary ON product.cid=categary.id LEFT JOIN brand ON product.bid=brand.id");
						while($row=mysqli_fetch_array($query)){
							$pid = $row['pid'];
							$cid = $row['cid'];
							$bid = $row['bid'];
							$product_name = $row['product_name'];
							$image = $row['image'];
					?>
					<div class="col-md-4">
                        <div class="post">
                            <div class="post-media post-image">
								<?php 
									if($image == ''){
								?>
									<img loading="lazy" class="img-fluid" style="height: 15rem; width: 21rem; border-radius: 12px 12px 2px 2px;" src="admin/img/product/profile.png">
								<?php	}else{?>
									<img loading="lazy" class="img-fluid" style="height: 15rem; width: 21rem; border-radius: 12px 12px 2px 2px;" src="admin/img/product/<?php echo $image; ?>">
								<?php	
									}
								?>
                            </div>
                            <div class="post-body">
                                <div class="entry-header">
                                    <h2 class="entry-title">
                                        <a href="product_detail.php?pid=<?php echo $pid; ?>" style="font-size: 18px;"><?php echo $product_name; ?></a>
                                    </h2>
                                </div>
                                <div class="post-footer">
                                    <a href="product_detail.php?pid=<?php echo $pid; ?>" class="btn btn-primary">View Details</a>
                                </div>
                            </div>
                        </div>
                    </div>	
					<?php } ?>
				</div>
            </div>
        </div>
    </div>
</section>
<script type="text/javascript">
	$(function(){
		$('.link').click(function(){
		   
			var elem = $(this);
			$.ajax({
				type: "GET",
				url: "cat.php",
				data: "id="+ elem.attr('data-artid'),
				//dataType:"json",
				success: function(data) {
				    $('.col-md-9 .row:first-child').html(data);
					$('.col-md-9 > .row:not(:first-child)').hide();
					
				}
			});
			return false;
		});
	});
	$(function(){
		$('.brand').click(function(){
		   
			var elem = $(this);
			$.ajax({
				type: "GET",
				url: "cat1.php",
				data: "id="+ elem.attr('data-artid'),
				//dataType:"json",
				success: function(data) {
				    $('.col-md-9 .row:first-child').html(data);
					$('.col-md-9 > .row:not(:first-child)').hide();
					
				}
			});
			return false;
		});
	});
	$(function(){
		$('.link').click(function(){
		   
			var elem = $(this);
			$.ajax({
				type: "GET",
				url: "de.php",
				data: "id="+ elem.attr('data-artid'),
				//dataType:"json",
				success: function(data) {
				    $('#result').html(data);
				    $('.default-category').hide();
					$('.col-md-9 > .row:not(:first-child)').hide();
					
				// 	For Hide the rest of the Brand name
					let attrId = elem.attr('data-artid');
					if(elem.hasClass("brand")){
					    let brandElem = elem.parents(".widget").find("#result").find("a.brand");
					    brandElem.each(function () {
							if ($(this).attr("data-artid") == attrId) {
								return;
							} else {
								$(this).hide();
							}
						});
					   
					}
				}
			});
			
			return false;
		});
	});
	
</script>
<?php include_once('footer.php'); ?>