Kaynak Bu Hocam Nasıl Yapabilirim ?
<?php
$kategorirakam=1;
$kategorisor=$db->prepare("SELECT * FROM kategori ORDER BY id");
$kategorisor->execute([
':id' => $_GET['id']
]);
while ($kategori=$kategorisor->fetch(PDO::FETCH_ASSOC)) { $kategorirakam++; ?>
<section class="gallery-section">
<div class="pattern-layer" style="background-image:url(<?php echo $kategori['resmi'] ?>)"></div>
<div class="auto-container">
<div class="sec-title centered">
<h2><?php echo $kategori['kat_adi'] ?></h2>
</div>
</div>
<div class="outer-container">
<div class="gallery-carousel owl-carousel owl-theme">
<?php
$ürünrakam=1;
$ürünsor=$db->prepare("SELECT * FROM ürünler WHERE kat_id = $id ");
$ürünsor->execute();
while ($ürün=$ürünsor->fetch(PDO::FETCH_ASSOC)) { $ürünrakam++; ?>
<div class="gallery-item">
<div class="inner-box">
<figure class="image-box">
<img src="assets\images\gallery\1.jpg" alt="">
<div class="overlay-box">
<div class="overlay-inner">
<div class="content">
<a href="projects-detail.html" class="link"><?php echo $ürün['ürün_adi'] ?></a>
<a href="assets\images\gallery\1.jpg" data-fancybox="gallery-2" data-caption="" class="link"><span class="icon fas fa-expand-arrows-alt"></span></a>
</div>
</div>
</div>
</figure>
</div>
</div>
<?php } ?>
</div>
</div>
</section>
<?php } ?> <?php
$kategorirakam=1;
$kategorisor=$db->prepare("SELECT * FROM kategori ORDER BY id");
$kategorisor->execute([
':id' => $_GET['id']
]);
?>Bu kısımda hata var ilk bakışta, sorgunuz yanlış doğru şekli aşağıdaki gibi olmalı
<?php
$kategorirakam=1;
$catid=filter_input(INPUT_GET,"id",FILTER_SANITIZE_NUMBER_INT);
$kategorisor=$db->prepare("SELECT * FROM kategori WHERE id=? ORDER BY id");
$kategorisor->execute(array($catid));
?>