PHP Dosya Yöneticisi

<?php
ob_start();
include "main-head.php";
include "main-header.php";

$kategori = $_GET['kategori'];

$yazikontrolu = $db->prepare("SELECT * FROM kategori WHERE slug=:slug");
$yazikontrolu->execute(array(
    'slug' => $kategori
));

if ($yazikontrolu->rowCount() == 0) {
    header("Location: ../404");
    exit;
}

$kategorigetir = $yazikontrolu->fetch(PDO::FETCH_ASSOC);

$yazilar = $db->prepare("SELECT * FROM blog WHERE kategori=:kategori AND tur = 'blog'");
$yazilar->execute(array(
    'kategori' => $kategorigetir['id']
));
$yazilar = $yazilar->fetchAll(PDO::FETCH_ASSOC);
?>

</div>

<?php

foreach ($yazilar as $item) {

<a href="/<?php echo $item['seolink'] ?>" class="link_image featured-thumbnail" title="<?php echo $item['baslik'] ?>">

<img width="780" height="450" src="<?php echo $item['resim'] ?>" class="attachment-disto_large_feature_image size-disto_large_feature_image wp-post-image" alt="">

</a> <span class="meta-category-small"><a class="post-category-color-text" style="background:#0015ff" href="/kategori/<?php echo $kategorigetir['slug'] ?>"><?php echo $kategorigetir['name'] ?></a></span>

</div>

<?php echo $item['baslik'] ?></a></h3>

</div>

<?php

}

</div>

</div>

<?php
                                $kategorigetir = $db->query("SELECT * FROM kategori  ORDER by name ")->fetchAll(PDO::FETCH_ASSOC);
                                foreach ($kategorigetir as $kategori) {
                                    $sql = "SELECT * FROM blog WHERE kategori = '$kategori[id]' ORDER BY id DESC LIMIT 1";
                                    $stmt = $db->prepare($sql);
                                    $stmt->execute();
                                    $yazi = $stmt->fetch(PDO::FETCH_ASSOC);
                                    $yazisay = $db->query("SELECT * FROM blog WHERE kategori = '$kategori[id]'")->rowCount();
                                    $kategoriyazisay = $db->query("SELECT * FROM blog WHERE kategori = '$kategori[id]'")->rowCount();
                                    if($yazisay > 0 ){

?>
                                        <div class="category_image_bg_image" style="background-image: url('<?= $yazi["resim"] ?>');">
                                            <a class="category_image_link" id="category_color_2" href="/kategori/<?= $kategori['slug'] ?>"><span class="jl_cm_overlay"><span class="jl_cm_name"><?= $kategori['name'] ?></span><span class="jl_cm_count"><?= $yazisay ?></span></span></a>
                                            <div class="category_image_bg_overlay" style="background: #ed1c1c;"></div>
                                        </div>
                                    <?php } } ?>
                            </div>

</div>

<h2>Son Yazılar</h2>

</div>

<div>

<?php

$sonyazilar = $db->query("SELECT * FROM blog WHERE tur != 'sayfa' ORDER by olusturmazamani ASC limit 3")->fetchAll(PDO::FETCH_ASSOC);

foreach ($sonyazilar as $yazilar) {

$kategorisorgux = $db->query("SELECT * FROM kategori WHERE id = '$yazilar[kategori]'")->fetch(PDO::FETCH_ASSOC);

<li>

<a href="/<?= $yazilar['seolink'] ?>"

class="jl_small_format feature-image-link image_post featured-thumbnail"

title="Sitting right here waiting for you come to me">

<img width="120" height="120"

src="<?= $yazilar['resim'] ?>"

class="attachment-disto_small_feature size-disto_small_feature wp-post-image"

alt="">

</a>

<span class="meta-category-small"><a class="post-category-color-text"

style="background:#d800f9"

href="#"><?= $kategorisorgux['name'] ?></a></span>

<h3 class="feature-post-title"><a

href="/<?= $yazilar['seolink'] ?>">

<?= $yazilar['baslik'] ?></a></h3>

<span class="post-meta meta-main-img auto_image_with_date">                             <span

class="post-date"><i

class="fa fa-clock-o"></i><?= $yazilar['olusturmazamani'] ?></span></span>

</div>

</li>

<?php } ?>

</ul>

</div>

</div>

<?php

$gonderiler = $db->query("SELECT * FROM blog WHERE tur != 'sayfa' ORDER by olusturmazamani DESC limit 3")->fetchAll(PDO::FETCH_ASSOC);

foreach ($gonderiler as $gonderi) {

$kategorisorgu = $db->query("SELECT * FROM kategori WHERE id = '$gonderi[kategori]'")->fetch(PDO::FETCH_ASSOC);

<span class="image_grid_header_absolute"

style="background-image: url('<?= $gonderi['resim'] ?>')"></span>

<a href="/<?= $gonderi['seolink'] ?>" class="link_grid_header_absolute"

title="Makeup it really important things to do"></a> <span

class="meta-category-small"><a

class="post-category-color-text" style="background:#6b34ba"

href="#"><?= $kategorisorgu['name'] ?></a></span>

<?= $gonderi['baslik'] ?></a></h3>

<span class="jl_post_meta"><span class="jl_author_img_w"><a

href="#" title="admin"

rel="author"><?= $kullanicisorgu['first_name'] ?></a></span><span

class="post-date"><i

class="fa fa-clock-o"></i><?= $gonderi['olusturmazamani'] ?></span></span>

</div>

<?php } ?>

</div>

</div>

<?php include 'main-footer.php'; ?>

İptal

📁 PHP Dosya Yöneticisi

📝 kategori.php

📝 kategori.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)