PHP Dosya Yöneticisi

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

if (!isset($_POST['s'])) {
    header("Location: /");
} else {
    $arama = $_POST['s'];
    $yazilar = $db->query("SELECT * FROM blog WHERE baslik LIKE '%$arama%'")->fetchAll(PDO::FETCH_ASSOC);
    $yazisay = $db->query("SELECT * FROM blog WHERE baslik LIKE '%$arama%'")->rowCount();
    ?>
    <div class="main_title_wrapper category_title_section jl_cat_img_bg">
        <div class="category_image_bg_image" style="background-image: url('http://jellywp.com/theme/disto/demo/wp-content/uploads/2019/02/soroush-karimi-253940-unsplash-1920x982.jpg');"></div>
        <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">
                            <h3 class="categories-title title"><?= $arama ?></h3>
                            <p>
                                <?php
                                if ($yazisay == 0) {
                                    echo "Aradığınız kelimeye ait bir yazı bulunamadı.";
                                } else {
                                    echo $yazisay . " adet yazı bulundu.";
                                }
                                ?>
                            </p>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <div class="jl_post_loop_wrapper">
        <div class="container" id="wrapper_masonry">
            <div class="row">
                <?php
                if ($yazisay == 0) {
                    echo '<div class="col-md-12"><div class="alert alert-danger">Aradığınız kelimeye ait bir yazı bulunamadı.</div></div>';
                } else {
                    ?>
                    <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 ($yazilar as $item) {
                                    $kategori = $db->query("SELECT * FROM kategori WHERE id = '$item[kategori]'")->fetch(PDO::FETCH_ASSOC);
                                    $yazisay = $db->query("SELECT * FROM blog WHERE kategori = '$item[kategori]'")->rowCount();
                                    ?>
                                    <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
                                }
                                ?>
                            </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
                                    $kategorigetir = $db->query("SELECT * FROM kategori ORDER by name ASC limit 5")->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();

?>
                                        <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>
                                <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);
                                            ?>
                                            <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:#e91e63" href="/kategori/<?= $kategorisorgux['slug'] ?>">
                                                            <?= $kategorisorgux['name'] ?>
                                                        </a>
                                                    </span>
                                                    <h3 class="feature-post-title">
                                                        <a href="/<?= $yazilar['seolink'] ?>">
                                                            <?= $yazilar['baslik'] ?>
                                                        </a>
                                                    </h3>
                                                    <span class="post-date"><?= $yazilar['olusturmazamani'] ?></span>
                                                </div>
                                            </li>
                                            <?php
                                        }
                                        ?>
                                    </ul>
                                </div>
                            </div>
                        </div>
                    </div>
                    <?php
                }
                ?>
            </div>
        </div>
    </div>
    <?php
}
include "main-footer.php";
?>

İptal

📁 PHP Dosya Yöneticisi

📝 ara.php

📝 ara.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)