Merhaba Arkadaşlar
Mysql veritabanımda 2 tabloyu inner join ile birleştirerek 4 ayrı kategoriden veriler çekip listeletiyorum ama veritabanımda veri yok ise hata veriyor, 1 tane veri varsa diğer 3 div tablolarında hatalar vererek gidiyor, veritabanımda ayrı kategorilere ait 4 tane veri var ise hata vermiyor, bu hatanın verme sebebi veritabanımda veri olmamasından, rowCount ile yapmaya çalıştım yapamadım, kod bloğum aşağıdaki gibi bu konuda yardımcı olabilirmisiniz,
teşekkürler
<div class="row gutter--15">
<?php
$sor=$db->prepare("SELECT * from blog inner join blogkategori on blog.kategori=blogkategori.id ORDER BY rand() limit 4");
$sor->execute();
$cek=$sor->fetchAll(PDO::FETCH_ASSOC);
?>
<div class="col-md-6">
<div class="post--item post--layout-1 post--title-larger">
<div class="post--img">
<a title="<?php echo $cek[0]['kadi'];?>" href="blog-details/<?php echo $cek[0]['seo'];?>" class="thumb"><img src="/uploads/bloglar/<?php echo $cek[0]['kapak'];?>" alt="<?php echo $cek[0]['adi'];?>"></a>
<a title="<?php echo $cek[0]['kadi'];?>" href="#" class="cat"><?php echo $cek[0]['kadi'];?></a>
<div class="post--info">
<ul class="nav meta">
<li><a href="#"><?php echo $cek[0]['tarih'];?></a></li>
</ul>
<div class="title">
<h2 class="h4">
<a href="blog-details/<?php echo $cek[0]['seo'];?>" class="btn-link"><?php echo $cek[0]['adi'];?></a>
</h2>
</div>
</div>
</div>
</div>
</div>
<div class="col-md-6">
<div class="row gutter--15">
<div class="col-xs-6 col-xss-12">
<div class="post--item post--layout-1 post--title-large">
<div class="post--img">
<a title="<?php echo $cek[1]['adi'];?>" href="blog-details/<?php echo $cek[1]['seo'];?>" class="thumb"><img src="/uploads/bloglar/<?php echo $cek[1]['kapak'];?>" alt="<?php echo $cek[1]['adi'];?>"></a>
<a title="<?php echo $cek[1]['kadi'];?>" href="#" class="cat"><?php echo $cek[1]['kadi'];?></a>
<div class="post--info">
<ul class="nav meta">
<li>
<a href="#"><?php echo $cek[1]['tarih'];?></a>
</li>
</ul>
<div class="title">
<h2 class="h4">
<a title="<?php echo $cek[1]['adi'];?>" href="blog-details/<?php echo $cek[1]['seo'];?>" class="btn-link"><?php echo $cek[1]['adi'];?></a>
</h2>
</div>
</div>
</div>
</div>
</div>
<div class="col-xs-6 hidden-xss">
<div class="post--item post--layout-1 post--title-large">
<div class="post--img">
<a title="<?php echo $cek[2]['adi'];?>" href="blog-details/<?php echo $cek[2]['seo'];?>" class="thumb"><img src="/uploads/bloglar/<?php echo $cek[2]['kapak'];?>" alt="<?php echo $cek[2]['adi'];?>"></a>
<a title="<?php echo $cek[2]['kadi'];?>" href="#" class="cat"><?php echo $cek[2]['kadi'];?></a>
<div class="post--info">
<ul class="nav meta">
<li><a href="#"><?php echo $cek[2]['tarih'];?></a></li>
</ul>
<div class="title">
<h2 class="h4">
<a title="<?php echo $cek[2]['adi'];?>" href="blog-details/<?php echo $cek[2]['seo'];?>" class="btn-link"><?php echo $cek[2]['adi'];?></a>
</h2>
</div>
</div>
</div>
</div>
</div>
<div class="col-sm-12 hidden-sm hidden-xs">
<div class="post--item post--layout-1 post--title-larger">
<div class="post--img">
<a title="<?php echo $cek[3]['adi'];?>" href="blog-details/<?php echo $cek[3]['seo'];?>" class="thumb"><img src="/uploads/bloglar/<?php echo $cek[3]['kapak'];?>" alt=""></a>
<a title="<?php echo $cek[3]['kadi'];?>" href="#" class="cat"><?php echo $cek[3]['kadi'];?></a>
<div class="post--info">
<ul class="nav meta">
<li><a href="#"><?php echo $cek[3]['tarih'];?></a></li>
</ul>
<div class="title">
<h2 class="h4">
<a title="<?php echo $cek[3]['adi'];?>" href="blog-details/<?php echo $cek[3]['seo'];?>" class="btn-link"><?php echo $cek[3]['adi'];?></a>
</h2>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
Selamlar.
İsset ile veri kontrolü yapmanız gerekir.
<?php
$sor = $db->prepare("SELECT * FROM blog INNER JOIN blogkategori ON blog.kategori = blogkategori.id ORDER BY RAND() LIMIT 4");
$sor->execute();
$cek = $sor->fetchAll(PDO::FETCH_ASSOC);
$rowCount = $sor->rowCount();
?>
<div class="row gutter--15">
<?php if ($rowCount > 0): ?>
<?php if (isset($cek[0])): ?>
<div class="col-md-6">
<div class="post--item post--layout-1 post--title-larger">
<div class="post--img">
<a title="<?php echo $cek[0]['kadi']; ?>" href="blog-details/<?php echo $cek[0]['seo']; ?>" class="thumb"><img src="/uploads/bloglar/<?php echo $cek[0]['kapak']; ?>" alt="<?php echo $cek[0]['adi']; ?>"></a>
<a title="<?php echo $cek[0]['kadi']; ?>" href="#" class="cat"><?php echo $cek[0]['kadi']; ?></a>
<div class="post--info">
<ul class="nav meta">
<li><a href="#"><?php echo $cek[0]['tarih']; ?></a></li>
</ul>
<div class="title">
<h2 class="h4">
<a href="blog-details/<?php echo $cek[0]['seo']; ?>" class="btn-link"><?php echo $cek[0]['adi']; ?></a>
</h2>
</div>
</div>
</div>
</div>
</div>
<?php endif; ?>
<div class="col-md-6">
<div class="row gutter--15">
<?php if (isset($cek[1])): ?>
<div class="col-xs-6 col-xss-12">
<div class="post--item post--layout-1 post--title-large">
<div class="post--img">
<a title="<?php echo $cek[1]['adi']; ?>" href="blog-details/<?php echo $cek[1]['seo']; ?>" class="thumb"><img src="/uploads/bloglar/<?php echo $cek[1]['kapak']; ?>" alt="<?php echo $cek[1]['adi']; ?>"></a>
<a title="<?php echo $cek[1]['kadi']; ?>" href="#" class="cat"><?php echo $cek[1]['kadi']; ?></a>
<div class="post--info">
<ul class="nav meta">
<li><a href="#"><?php echo $cek[1]['tarih']; ?></a></li>
</ul>
<div class="title">
<h2 class="h4">
<a title="<?php echo $cek[1]['adi']; ?>" href="blog-details/<?php echo $cek[1]['seo']; ?>" class="btn-link"><?php echo $cek[1]['adi']; ?></a>
</h2>
</div>
</div>
</div>
</div>
</div>
<?php endif; ?>
<?php if (isset($cek[2])): ?>
<div class="col-xs-6 hidden-xss">
<div class="post--item post--layout-1 post--title-large">
<div class="post--img">
<a title="<?php echo $cek[2]['adi']; ?>" href="blog-details/<?php echo $cek[2]['seo']; ?>" class="thumb"><img src="/uploads/bloglar/<?php echo $cek[2]['kapak']; ?>" alt="<?php echo $cek[2]['adi']; ?>"></a>
<a title="<?php echo $cek[2]['kadi']; ?>" href="#" class="cat"><?php echo $cek[2]['kadi']; ?></a>
<div class="post--info">
<ul class="nav meta">
<li><a href="#"><?php echo $cek[2]['tarih']; ?></a></li>
</ul>
<div class="title">
<h2 class="h4">
<a title="<?php echo $cek[2]['adi']; ?>" href="blog-details/<?php echo $cek[2]['seo']; ?>" class="btn-link"><?php echo $cek[2]['adi']; ?></a>
</h2>
</div>
</div>
</div>
</div>
</div>
<?php endif; ?>
<?php if (isset($cek[3])): ?>
<div class="col-sm-12 hidden-sm hidden-xs">
<div class="post--item post--layout-1 post--title-larger">
<div class="post--img">
<a title="<?php echo $cek[3]['adi']; ?>" href="blog-details/<?php echo $cek[3]['seo']; ?>" class="thumb"><img src="/uploads/bloglar/<?php echo $cek[3]['kapak']; ?>" alt=""></a>
<a title="<?php echo $cek[3]['kadi']; ?>" href="#" class="cat"><?php echo $cek[3]['kadi']; ?></a>
<div class="post--info">
<ul class="nav meta">
<li><a href="#"><?php echo $cek[3]['tarih']; ?></a></li>
</ul>
<div class="title">
<h2 class="h4">
<a title="<?php echo $cek[3]['adi']; ?>" href="blog-details/<?php echo $cek[3]['seo']; ?>" class="btn-link"><?php echo $cek[3]['adi']; ?></a>
</h2>
</div>
</div>
</div>
</div>
</div>
<?php endif; ?>
</div>
</div>
<?php else: ?>
<p>Gösterilecek blog yazısı bulunmamaktadır.</p>
<?php endif; ?>
</div>Bu kod isset ile veri kontrolü yapıp gerekli miktarda html satırını oluşturur.
Sevgiler.