PHP Dosya Yöneticisi

<?php include "main-head.php"; ?>
<?php include "main-header.php";

$kategori = $_GET['etiket'];
$kategorigetir = $db->query("SELECT * FROM etiket WHERE slug='$kategori'")->fetch(PDO::FETCH_ASSOC);
$sayfa = $kategorigetir['etiket'];
$sayfa = $db->query("SELECT * FROM blog WHERE etiket LIKE '%$etiket%' AND tur != 'sayfa'")->fetchAll(PDO::FETCH_ASSOC);
?>
    <div class="main_title_wrapper category_title_section jl_cat_img_bg">
         <div class="category_image_bg_ov"></div>
        <div class="jl_cat_title_wrapper">
            <div class="container">
                <div class="row">
                    <div class="col-md-12 main_title_col">
                        <div class="jl_cat_mid_title">
                            <?php
                            if($etiketgetir['gizlih']){
                                echo '<h1 class="d-none"><i class="fa fa-lock"></i> '.$etiketgetir['gizlih'].'</h1>';
                            }
                            ?>
                            <h3 class="categories-title title"><?=$etiketgetir['etiket']?></h3>
                            <p><?=$etiketgetir['aciklama']?></p>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
<div class="jl_post_loop_wrapper">
    <div class="container" id="wrapper_masonry">
        <div class="row">
            <div class="col-md-8 grid-sidebar" id="content">
                <div class="jl_wrapper_cat">
                    <div id="content_masonry" class="pagination_infinite_style_cat">
                       <?php foreach ($sayfa as $item) :$kategori = $db->query("SELECT * FROM kategori WHERE id = '$item[kategori]'")->fetch(PDO::FETCH_ASSOC);
 ?>
    <div class="box jl_grid_layout1 blog_grid_post_style post-2970 post type-post status-publish format-gallery has-post-thumbnail hentry category-business tag-inspiration tag-morning tag-racing post_format-post-format-gallery" data-aos="fade-up">
        <div class="post_grid_content_wrapper">
            <div class="image-post-thumb">
                <a href="/<?= $item['seolink'] ?>" class="link_image featured-thumbnail" title="<?= $item['baslik'] ?>">
                    <img width="780" height="450" src="<?= $item['resim'] ?>" class="attachment-disto_large_feature_image size-disto_large_feature_image wp-post-image" alt="">
                    <div class="background_over_image"></div>
                </a>
                <span class="meta-category-small"><a class="post-category-color-text" style="background:#0015ff"href="/kategori/<?= $kategori['slug'] ?>"><?= $kategori['name'] ?></a></span>
            </div>
            <div class="post-entry-content">
                <div class="post-entry-content-wrapper">
                    <div class="large_post_content">
                        <h3 class="image-post-title"><a href="/<?= $item['seolink'] ?>"><?= $item['baslik'] ?></a></h3>
                        <span class="jl_post_meta"><span class="post-date"><i class="fa fa-clock-o"></i><?= $item['olusturmazamani'] ?></span></span>
                    </div>
                </div>
            </div>
        </div>
    </div>
<?php endforeach; ?>

</div>
                    <nav class="jellywp_pagination"></nav>
                     </div>
                </div>
            <div class="col-md-4" id="sidebar">
    <div id="disto_category_image_widget_register-5" class="widget jellywp_cat_image">
        <div class="wrapper_category_image">
            <div class="category_image_wrapper_main">
                <?php
                $etiketgetir = $db->query("SELECT * FROM kategori ORDER BY name ASC LIMIT 5")->fetchAll(PDO::FETCH_ASSOC);
                foreach ($etiketgetir 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();

// Boş olan kategorileri atla
                    if ($yazi && $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 } ?>
                <?php } ?>
            </div>
            <span class="jl_none_space"></span>
        </div>
    </div>
    <span class="jl_none_space"></span>
      <div id="disto_recent_post_widget-7" class="widget post_list_widget">
                        <div class="widget_jl_wrapper"><span class="jl_none_space"></span>
                            <div class="widget-title">
                                <h2>Son Yazılar</h2>
                            </div>
                            <div>
                                <ul class="feature-post-list recent-post-widget">
                                    <?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);
                                                                            $sql = "SELECT * FROM blog WHERE kategori = '$kategori[id]' ORDER BY id DESC LIMIT 1";

?>
                                        <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="">
                                                <div class="background_over_image"></div>
                                            </a>
                                            <div class="item-details">
                                        <span class="meta-category-small"><a class="post-category-color-text"
                                                                             style="background:#d800f9"
                                                                             href="/kategori/<?= $kategori["slug"] ?>"><?= $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>
            <span class="jl_none_space"></span>
        </div>
    </div>
    <span class="jl_none_space"></span>
    <div class="slider_widget_post jelly_loading_pro">
        <?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);
                                $kategorigetir = $db->query("SELECT * FROM kategori ORDER by name ASC limit 5")->fetchAll(PDO::FETCH_ASSOC);

?>
            <div class="recent_post_large_widget">
                <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>
                <?php if ($kategorisorgu) : ?>
                    <span class="meta-category-small">
                        <a class="post-category-color-text" style="background:#6b34ba" href="/kategori/<?= $kategori["slug"] ?>"<?= $kategorisorgu['name'] ?></a>
                    </span>
                <?php endif; ?>
                <div class="wrap_box_style_main image-post-title">
                    <h3 class="image-post-title">
                        <a href="/<?= $gonderi['seolink'] ?>"><?= $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>
            </div>
        <?php } ?>
    </div>
    <span class="jl_none_space"></span>
</div>

</div>
                     </div>
                </div>
            </div>
        </div>
    </div>

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

İptal

📁 PHP Dosya Yöneticisi

📝 etiket.php

📝 etiket.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)