<?php !defined("index") ? die("hacking ?") : null;?>    
<?php

$sayfa = intval(@$_GET["sayfa"]);

if(!$sayfa){
    
     $sayfa =1;
    
}

$v = $db->prepare("select * from konular inner join kategoriler on

kategoriler.kategori_id = konular.konu_kategori inner join uyeler on uyeler.uye_adi= konular.konu_ekleyen where konu_durum=?");
$v->execute(array(1));
$v->fetchALL(PDO::FETCH_ASSOC);
$toplam = $v->rowCount();
$limit = 3;
$goster = $sayfa*$limit-$limit;
$sayfa_sayisi = ceil($toplam/$limit);
$forlimit = 3;


$konu = $db->prepare("select * from konular inner join kategoriler on

kategoriler.kategori_id = konular.konu_kategori inner join uyeler on uyeler.uye_adi= konular.konu_ekleyen where konu_durum=? order by konu_id desc limit $goster,$limit");
$konu->execute(array(1));
$x = $konu->fetchALL(PDO::FETCH_ASSOC);

echo '
<div class="product-showcase">
<!-- HEADLINE -->
<div class="headline primary">
<h4>Son Eklenen İlanlar</h4>
</div>
';

foreach($x as $m){
    // yorumlar
    $yorum = $db->prepare("select * from yorumlar where yorum_konu_id=? and yorum_onay=?");
    $yorum->execute(array($m["konu_id"],1));
    $yorum->fetchALL(PDO::FETCH_ASSOC);
    $x = $yorum->rowCount();
    ?>
<!-- /HEADLINE -->
<div class="product-showcase tabbed visible">
<!-- PRODUCT LIST -->
<div class="product-list grid column4-wrap">
<!-- PRODUCT ITEM -->
<div class="product-item column">
<!-- PRODUCT PREVIEW ACTIONS -->
<div class="product-preview-actions">
<!-- PRODUCT PREVIEW IMAGE -->
<figure class="product-preview-image">
<a href="?do=devam&id=<?php echo $m["konu_id"];?>">    
<img width="258" height="150" src="<?php echo $m["konu_resim"];?>" alt="awddwawd">
</a>
</figure>
<!-- /PRODUCT PREVIEW IMAGE -->
<!-- PREVIEW ACTIONS -->
<!-- /PREVIEW ACTIONS -->
</div>
<!-- /PRODUCT PREVIEW ACTIONS -->
<!-- PRODUCT INFO -->
<div class="product-info">
<a href="?do=devam&id=<?php echo $m["konu_id"];?>">
<p class="text-header"><?php echo $m["konu_baslik"];?></p>
</a>
<p class="product-description"><?php echo mb_substr($m["konu_aciklama"],0,150);?></p>
<a href="?do=kategori&id=<?php echo $m["kategori_id"];?>">
<p class="category primary"><?php echo $m["kategori_adi"];?></p>
</a>
<small><p class="category primary"><?php echo $m["konu_tarih"];?></p></small>
</div>
<!-- /PRODUCT INFO -->
<hr class="line-separator">
<!-- USER RATING -->
<div class="user-rating">
<a href="satici-firat-senturk-197.html">
<figure class="user-avatar small">
<img width="26" height="26" src="dimg/profile-default-image.png" alt="user-avatar">
</figure>
</a>
<a href="?do=profil&uye=<?php echo $m["uye_adi"];?>">
<p class="text-header tiny"><?php echo $m["uye_adi"];?></p>
</a>
<p class="price">10.00<span>₺
</span>
</p>
</div>
<!-- /USER RATING -->
</div>
</div>
<!-- /PRODUCT LIST -->
</div>
    <?php
}
echo '<div class="pager primary">';

for($i = $sayfa - $forlimit; $i<$sayfa + $forlimit +1; $i++ ){
    
     if($i>0 && $i<=$sayfa_sayisi){
        
         if($i == $sayfa){
            
             echo '<span aria-current="page" class="page-numbers current">'.$i.'</span>';
            
         }else {
            
             echo '<a class="page-numbers" href="?sayfa='.$i.'">'.$i.'</a>';
            
         }
        
     }
    
    
}

if($sayfa != $sayfa_sayisi){
    
    
     echo '<a class="page-numbers" href="?sayfa='.$sayfa_sayisi.'">»</a>';
    
}
?>
<div style="clear:both;"></div>
</div>
</div>