/* PHP ile dataların çekildiği alan */
<script type="text/javascript" src="https://code.jquery.com/jquery-3.3.1.min.js" ></script>
  <div class="container" style="margin-top:25px;margin-bottom:10px;">
  <div class="row">
		<div class="col-1">
			SIRALAMA
		</div>
  <div class="col-4">
<select class="form-control" name="deger" id="secenek">
<?php
$query = $db->query("select * from choose", PDO::FETCH_ASSOC);
if($query->rowCount()){
	foreach($query as $n){
		extract($n);
		echo '<option value='.$slug.'>'.$isim.'</option>';
	}
}
?>
	</select>
	 </div>
<div class="col-7"></div>
	</div>
</div>

/* JQUERY Kodları , Seçime Göre data getirme ve yazdırma */
	
	<script>
	$(function(){
	  $(":input#secenek").change(function(){
	   var q = $(this).val();  var veri = "table=product&deger="+q;
	    $.ajax({
	      url:'getdata.php',
	      type:'GET',
	      data:veri,
	      success:function(result){
	        $("#ItemsPlaceHolder").html(result);
	      }
	    });
	  });
	});
	</script>

/* İÇERİKLERİN GÖSTERİLDİĞİ YER */


  <div class="container" style="margin-top:15px;margin-bottom:10px;">
  <div class="row">
	<div class="col-12">
		<div id="ItemsPlaceHolder" class="row">


			<?php
			$cek = $db->query("select * from product limit 8 ",PDO::FETCH_ASSOC);
			if($cek->rowCount()){
				foreach($cek as $row){
					extract($row);
					?>
			    <div class="col-md-3" >
			    <div class="card mb-4 box-shadow">
			            <img class="card-img-top"  src="<?=Admin.$resim?>" alt="Card image cap">
			            <div class="card-body">
			              <p class="card-text"><a href="<?=adres?>Brands.php?brand=<?=$marka?>&sef=<?=seflink($marka)?>"><?=$marka?></a><br><?=$baslik?> <br> <?=$fiyat?>₺ <small style="float:right" class="text-muted">⚝⚝⚝⚝⚝</small></p>
			              <div class="d-flex justify-content-between align-items-center">
			                <div class="btn-group">
			      <?php if($_SESSION){ ?>
			        <a href="?ekle=<?=$id?>" id="sepeteekle" class="btn btn-sm btn-outline-secondary"> Sepete Ekle</a>
			                  <button number="<?=$id?>" id="begen" type="button" class="btn btn-sm btn-outline-secondary">Beğen</button>
			      <?php }else{ ?>
			        <button id="sepeteekle" data-toggle="modal" class="btn btn-sm btn-outline-secondary" data-target="#girismodal">Sepete Ekle</button>
			                  <button  id="sepeteekle" data-toggle="modal" class="btn btn-sm btn-outline-secondary" data-target="#girismodal">Beğen</button>
			      <?php } ?>

			      <a href="<?=adres?>ProductDetail.php?baslik=<?=seflink($baslik)?>&pid=<?=$id?>&marka=<?=$marka?>&katid=<?=$kategori_id?>"  class="btn btn-sm btn-outline-secondary">Detay</a>
			                </div>

			              </div>
			            </div>
			          </div>
			      </div>
			    <?php
				}
			}
			?>



			</div>

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