PHP Dosya Yöneticisi

<?php
$sayfa = 'anasayfa';
include "main-head.php";
?>
<?php include "main-header.php"; ?>

<div class="jl_post_loop_wrapper">
    <div class="container" id="wrapper_masonry" style="padding-top: 20px">
        <div class="row jl_front_b_cont">
            <div class="col-md-12 jl_mid_main_3col">
                <div class="jl_3col_wrapin">
                    <div id="pl-3476" class="panel-layout">
                        <div id="pg-3476-0" class="panel-grid panel-no-style">
                            <div id="pgc-3476-0-0" class="panel-grid-cell">
                                <span class="jl_none_space"></span>
                                <div id="panel-3476-0-0-0" class="so-panel widget widget_disto_recent_grid5_widgets jl_widget_recent_grid5 panel-first-child panel-last-child" data-index="0">
                                    <div class="jl_grid5_builder jelly_homepage_builder">
                                        <div class="jl_grid5_wrapper">
                                            <h1 class="d-none"><?= $sayfagetir['gizlih'] ?></h1>
                                            <?php
                                            $modulDurum = $db->prepare("SELECT durum FROM moduller WHERE id = 8");
                                            $modulDurum->execute();
                                            $modulDurum = $modulDurum->fetch(PDO::FETCH_ASSOC)['durum'];
                                            if ($modulDurum == '1') {
                                                $sonalti = $db->prepare("SELECT * FROM blog WHERE tur != 'sayfa' ORDER BY RAND() LIMIT 10");
                                                $sonalti->execute();
                                                $sonalti = $sonalti->fetchAll(PDO::FETCH_ASSOC);
                                            } else {
                                                $sonalti = [];
                                            }
                                            ?>
                                            <div id="story-container" style="text-align: center; margin-bottom: 15px;"></div>
                                            <div class="jl_grid5_container">
                                                <?php
                                                $onecikanlar = $db->prepare("SELECT * FROM blog WHERE tur != 'sayfa' ORDER BY olusturmazamani DESC LIMIT 5");
                                                $onecikanlar->execute();
                                                $onecikanlar = $onecikanlar->fetchAll(PDO::FETCH_ASSOC);
                                                $i = 1;
                                                $first = true;
                                                foreach ($onecikanlar as $onecikanicerik) {
                                                    $kategoriId = isset($onecikanicerik['kategori']) ? $onecikanicerik['kategori'] : null;
                                                    $kategorisor = null;
                                                    if ($kategoriId !== null) {
                                                        $kategoriQuery = $db->prepare("SELECT * FROM kategori WHERE id = :kategoriId");
                                                        $kategoriQuery->bindParam(':kategoriId', $kategoriId);
                                                        $kategoriQuery->execute();
                                                        $kategorisor = $kategoriQuery->fetch(PDO::FETCH_ASSOC);
                                                    }
                                                    if ($first) {
                                                        ?>
                                                        <div class="jl_grid5_item jl_grid5main jl_grid1" data-aos="fade-up">
                                                            <div class="jl_grid5_itemin">
                                                                <span class="image_grid_header_absolute" style="background-image: url('<?= $onecikanicerik['resim'] ?>')"></span>
                                                                <a href="/<?= $onecikanicerik['seolink'] ?>" class="link_grid_header_absolute" title="Creative photography ideas from smart devices"></a>
                                                                <?php if (isset($kategorisor['slug']) && isset($kategorisor['name'])) : ?>
                                                                    <span class="meta-category-small"><a class="post-category-color-text" style="background:#7fbc1e" href="/kategori/<?= $kategorisor['slug'] ?>"><?= $kategorisor['name'] ?></a></span>
                                                                <?php endif; ?>
                                                                <div class="wrap_box_style_main image-post-title">
                                                                    <h3 class="image-post-title"><a href="/<?= $onecikanicerik['seolink'] ?>"><?= $onecikanicerik['baslik'] ?></a></h3>
                                                                    <span class="jl_post_meta">
                                                                        <span class="post-date"><i class="fa fa-clock-o"></i><?= format_tarih_saat($onecikanicerik['olusturmazamani']) ?></span>
                                                                    </span>
                                                                </div>
                                                            </div>
                                                        </div>
                                                        <?php
                                                        $first = false;
                                                    } else {
                                                        ?>
                                                        <div class="jl_grid5_item jl_grid5small jl_grid<?= $i ?>" data-aos="fade-up">
                                                            <div class="jl_grid5_itemin">
                                                                <span class="image_grid_header_absolute" style="background-image: url('<?= $onecikanicerik['resim'] ?>')"></span>
                                                                <a href="/<?= $onecikanicerik['seolink'] ?>" class="link_grid_header_absolute" title="Have good food taste then enjoy reading"></a>
                                                                <?php if (isset($kategorisor['slug']) && isset($kategorisor['name'])) : ?>
                                                                    <span class="meta-category-small"><a class="post-category-color-text" style="background:#7fbc1e" href="/kategori/<?= $kategorisor['slug'] ?>"><?= $kategorisor['name'] ?></a></span>
                                                                <?php endif; ?>
                                                                <div class="wrap_box_style_main image-post-title">
                                                                    <h3 class="image-post-title"><a href="/<?= $onecikanicerik['seolink'] ?>"><?= $onecikanicerik['baslik'] ?></a></h3>
                                                                    <span class="jl_post_meta">
                                                                        <span class="post-date"><i class="fa fa-clock-o"></i><?= format_tarih_saat($onecikanicerik['olusturmazamani']) ?></span>
                                                                    </span>
                                                                </div>
                                                            </div>
                                                        </div>
                                                        <?php
                                                    }
                                                    $i++;
                                                }
                                                ?>

</div>
                                        </div>
                                    </div>
                                    <span class="jl_none_space"></span>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>

<?php
                            $sql = "SELECT * FROM blog WHERE tur != 'sayfa' ORDER BY id DESC";
                            $stmt = $db->prepare($sql);
                            $stmt->execute();
                            $gonderiler = $stmt->fetchAll(PDO::FETCH_ASSOC);

$perPage = 16;
                            $page = isset($_GET['sayfa']) ? $_GET['sayfa'] : 1;
                            $totalPosts = count($gonderiler);
                            $totalPages = ceil($totalPosts / $perPage);
                            $start = ($page - 1) * $perPage;
                            $end = $start + $perPage;
                            $currentPage = $page;
                            ?>

<?php for ($i = $start; $i < $end && $i < $totalPosts; $i++) : ?>
                                <?php
                                $gonderi = $gonderiler[$i];
                                $kategoriId = isset($gonderi['kategori']) ? $gonderi['kategori'] : null;
                                $kategorisor = null;
                                if ($kategoriId !== null) {
                                    $kategoriQuery = $db->prepare("SELECT * FROM kategori WHERE id = :kategoriId");
                                    $kategoriQuery->bindParam(':kategoriId', $kategoriId);
                                    $kategoriQuery->execute();
                                    $kategorisor = $kategoriQuery->fetch(PDO::FETCH_ASSOC);
                                }
                                ?>

<div class="box jl_grid_layout1 blog_grid_post_style post-<?= $gonderi['id'] ?> post type-post status-publish format-gallery has-post-thumbnail hentry category-<?= $kategoriId ?> post_format-post-format-gallery" data-aos="fade-up">
                                    <div class="post_grid_content_wrapper">
                                        <div class="image-post-thumb">
                                            <a href="/<?= $gonderi['seolink'] ?>" class="link_image featured-thumbnail" title="<?= $gonderi['baslik'] ?>">
                                                <img width="780" height="450" src="<?= $gonderi['resim'] ?>" class="attachment-disto_large_feature_image size-disto_large_feature_image wp-post-image" alt="">
                                                <div class="background_over_image"></div>
                                            </a>
                                            <?php if (isset($kategorisor['slug']) && isset($kategorisor['name'])) : ?>
                                                <span class="meta-category-small"><a class="post-category-color-text" style="background:#0015ff" href="/kategori/<?= $kategorisor['slug'] ?>"><?= $kategorisor['name'] ?></a></span>
                                            <?php endif; ?>
                                        </div>
                                        <div class="post-entry-content">
                                            <div class="post-entry-content-wrapper">
                                                <div class="large_post_content">
                                                    <h3 class="image-post-title"><a href="/<?= $gonderi['seolink'] ?>"><?= $gonderi['baslik'] ?></a></h3>
                                                    <span class="jl_post_meta">
                                                        <span class="post-date"><i class="fa fa-clock-o"></i><?= format_tarih_saat($gonderi['olusturmazamani']) ?></span>
                                                    </span>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>

<?php endfor; ?>

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

<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")->fetchAll(PDO::FETCH_ASSOC);
                            foreach ($kategorigetir as $kategori) {
                                $kategoriId = isset($kategori['id']) ? $kategori['id'] : null;
                                $sql = "SELECT * FROM blog WHERE kategori = :kategoriId ORDER BY id DESC LIMIT 1";
                                $stmt = $db->prepare($sql);
                                $stmt->bindParam(':kategoriId', $kategoriId);
                                $stmt->execute();
                                $yazi = $stmt->fetch(PDO::FETCH_ASSOC);
                                $yazisay = $db->query("SELECT * FROM blog WHERE kategori = '$kategoriId'")->rowCount();
                                $kategoriyazisay = $db->query("SELECT * FROM blog WHERE kategori = '$kategoriId'")->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>
                        <span class="jl_none_space"></span>
                    </div>
                </div>
                <span class="jl_none_space"></span>
                <?php
                if ($doviz['durum'] == 1) {
                    ?>
                    <div id="disto_recent_post_widget-7" class="widget post_list_widget" style="margin-bottom: 0px;">
                        <div class="widget_jl_wrapper"><span class="jl_none_space"></span>
                            <div class="widget-title">
                                <h2>Güncel Kurlar</h2>
                            </div>

<div class="social-count-plus">
                                <ul class="default">
                                    <?php
                                    $api_key = $siteayar['doviz'];
                                    $base_currency = 'TRY';
                                    $symbols = 'USD,EUR,GBP';
                                    $url = 'https://v6.exchangerate-api.com/v6/' . $api_key . '/latest/' . $base_currency . '?symbols=' . $symbols;
                                    $response = file_get_contents($url);

if ($response) {
                                        $data = json_decode($response, true);

if ($data && $data['result'] == 'success') {
                                            $rates = $data['conversion_rates'];

$usd_to_try = number_format(1 / $rates['USD'], 4);
                                            $eur_to_try = number_format(1 / $rates['EUR'], 4);
                                            $gbp_to_try = number_format(1 / $rates['GBP'], 4);
                                            ?>
                                            <li class="count-facebook">
                                                <span class="items"><span class="count">USD</span><span class="label"><?= $usd_to_try ?></span></span>
                                            </li>
                                            <li class="count-instagram">
                                                <span class="items"><span class="count">EUR</span><span class="label"><?= $eur_to_try ?></span></span>
                                            </li>
                                            <li class="count-pinterest">
                                                <span class="items"><span class="count">GBP</span><span class="label"><?= $gbp_to_try ?></span></span>
                                            </li>
                                            <?php
                                        } else {
                                            echo 'Döviz kurları alınamadı.';
                                        }
                                    } else {
                                        echo 'API yanıtı alınamadı.';
                                    }
                                    ?>
                                </ul>
                            </div>

<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>Popüler 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 hit ASC limit 3")->fetchAll(PDO::FETCH_ASSOC);
                                foreach ($sonyazilar as $yazilar) {
                                    $kategoriId = isset($yazilar['kategori']) ? $yazilar['kategori'] : null;
                                    $kategorisorgux = null;
                                    if ($kategoriId !== null) {
                                        $kategoriQuery = $db->prepare("SELECT * FROM kategori WHERE id = :kategoriId");
                                        $kategoriQuery->bindParam(':kategoriId', $kategoriId);
                                        $kategoriQuery->execute();
                                        $kategorisorgux = $kategoriQuery->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">
                                            <?php if (isset($kategorisorgux['slug']) && isset($kategorisorgux['name'])) : ?>
                                                <span class="meta-category-small"><a class="post-category-color-text" style="background:#d800f9" href="/kategori/<?= $kategorisorgux['slug'] ?>"><?= $kategorisorgux['name'] ?></a></span>
                                            <?php endif; ?>
                                            <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><?= format_tarih_saat($yazilar['olusturmazamani']) ?></span>
                                            </span>
                                        </div>
                                    </li>
                                <?php } ?>
                            </ul>
                        </div>
                 
                <span class="jl_none_space"></span>

<?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="/kategori/<?= $kategorisor['slug'] ?>"><?= $kategorisor['name'] ?></a></span>

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

<span class="jl_author_img_w"><span class="post-date"><i

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

</div>

<?php } ?>

</div>

</div>

</div>
        </div>
    </div>
</div>
<?php include "main-footer.php"; ?>

İptal

📁 PHP Dosya Yöneticisi

📝 index.php

📝 index.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)