prepare("select * from urunler where durum='1' and kategori like '%$diger%' GROUP BY urunkodu");
$bak->execute(array());
$toplam= $bak->rowCount();
$limit = 9;
$goster = $sayfa*$limit-$limit;
$sayfasayisi = ceil($toplam/$limit);
$forlimit = 2;
$pr = $DB->query("select * from urunler where durum='1' and kategori like '%$diger%' GROUP BY urunkodu ASC limit $goster,$limit")->fetchAll(PDO::FETCH_ASSOC);
$__URUN__ = false;
foreach ($pr as $dr) {
$__URUN__ = true;
?>
data-urunfiyat="" data-urunfiyat="" data-marka="" data-urunad="" class="product-item layout1 col-ts-12 col-xs-6 col-sm-6 col-md-4 col-lg-4 no-padding">
";
}
?>