bnmbertsurhetertertertertertertertpdf'tdfg

hjkhghopjkertteerterterterertertrtoirh bnmbertsurhetertertertertertertertpdf'tdfg

<?php include "header.php";

$blogsor = $db->prepare("SELECT * FROM blog where seo_url=:sef and status='1'");
$blogsor->execute(array(
    'sef' => $_GET['sef']
));

$blogcek = $blogsor->fetch(PDO::FETCH_ASSOC);
$id = $blogcek['id']; ?>

<head>
    <style>
        ul {
            list-style: outside !important;
        }
    </style>
</head>

<section class="section pt-55 ">
    <div class="container">
        <div class="row">
            <div class="col-lg-10 offset-lg-1 mb-20">
                
                <div class="post-single">
                    <div class="post-single-image">
                        <img src="<?php echo $blogcek['image'] ?>" alt="<?php echo $blogcek['title'] ?>">
                    </div>
                    <div class="post-single-content">
                        <div class="categorie"><?php echo $blogcek['category'] ?></div>
                        <h4><?php echo $blogcek['title']  ?> </h4>
                        <div class="post-single-info">
                            <ul class="list-inline">
                                <li>
                                    <img src="<?php echo $aboutcek['gorsel'] ?>" alt="<?php echo $ayarcek['author'] ?>">

</li>
                                <li><?php echo $ayarcek['author'] ?>
                                </li>
                                <li class="dot"></li>
                                <li>
                                    <?php
                                    $date = $blogcek['date'];
                                    $datevideo = explode("-", $date);
                                    $dates = $datevideo[2];
                                    $datevideos = explode(" ", $dates);
                                    echo $datevideos[0];
                                    echo " ";
                                    if ($datevideo[1] == "01") {
                                        echo "Ocak";
                                    } elseif ($datevideo[1] == "02") {
                                        echo "Şubat";
                                    } elseif ($datevideo[1] == "03") {
                                        echo "Mart";
                                    } elseif ($datevideo[1] == "04") {
                                        echo "Nisan";
                                    } elseif ($datevideo[1] == "05") {
                                        echo "Mayıs";
                                    } elseif ($datevideo[1] == "06") {
                                        echo "Haziran";
                                    } elseif ($datevideo[1] == "07") {
                                        echo "Temmuz";
                                    } elseif ($datevideo[1] == "08") {
                                        echo "Ağustos";
                                    } elseif ($datevideo[1] == "09") {
                                        echo "Eylül";
                                    } elseif ($datevideo[1] == "10") {
                                        echo "Ekim";
                                    } elseif ($datevideo[1] == "11") {
                                        echo "Kasım";
                                    } elseif ($datevideo[1] == "12") {
                                        echo "Aralık";
                                    };
                                    echo " ";
                                    echo $datevideo[0];
                                    ?>
                                </li>
                            </ul>
                        </div>
                    </div>

<?php
                    $prevsor = $db->prepare("SELECT * FROM blog where id<$id and status='1' order by RAND() limit 1");
                    $prevsor->execute();
                    $prevcek = $prevsor->fetch(PDO::FETCH_ASSOC);
                    $prevsay = $prevsor->rowCount();
                    $nextsor = $db->prepare("SELECT * FROM blog where id>$id and status='1' order by RAND() limit 1");
                    $nextsor->execute();
                    $nextcek = $nextsor->fetch(PDO::FETCH_ASSOC);
                    $nextsay = $nextsor->rowCount();
                    if ($prevsay == 0 && $nextsay != 0) { ?>
                        <div class="col-md-12">
                            <div class="widget">
                                <div class="widget-next-post">
                                    <div class="small-post">
                                        <div class="image">
                                            <a href="blog-<?php echo $nextcek['seo_url'] ?>">
                                                <img src="<?php echo $nextcek['image'] ?>" alt="<?php echo $nextcek['title'] ?>">
                                            </a>
                                        </div>
                                        <div class="content">
                                            <div>
                                                <a class="link" href="blog-<?php echo $nextcek['seo_url'] ?>">
                                                    Sonraki <i class="arrow_right"></i></a>
                                            </div>
                                            <a href="blog-<?php echo $nextcek['seo_url'] ?>"><?php echo $nextcek['title'] ?></a>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    <?php } elseif ($nextsay == 0 && $prevsay != 0) { ?>
                        <div class="col-md-12">
                            <div class="widget">
                                <div class="widget-next-post">
                                    <div class="small-post">
                                        <div class="image">
                                            <a href="blog-<?php echo $prevcek['seo_url'] ?>">
                                                <img src="<?php echo $prevcek['image'] ?>" alt="<?php echo $prevcek['title'] ?>">
                                            </a>
                                        </div>
                                        <div class="content">
                                            <div>
                                                <a class="link" href="blog-<?php echo $prevcek['seo_url'] ?>">
                                                    <i class="arrow_left"></i>Önceki</a>
                                            </div>
                                            <a href="blog-<?php echo $prevcek['seo_url'] ?>"><?php echo $prevcek['title'] ?></a>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    <?php } elseif ($nextsay != 0 && $prevsay != 0) { ?>
                        <div class="col-md-6">
                            <div class="widget">
                                <div class="widget-next-post">
                                    <div class="small-post">
                                        <div class="image">
                                            <a href="blog-<?php echo $prevcek['seo_url'] ?>">
                                                <img src="<?php echo $prevcek['image'] ?>" alt="<?php echo $prevcek['title'] ?>">
                                            </a>
                                        </div>
                                        <div class="content">
                                            <div>
                                                <a class="link" href="blog-<?php echo $prevcek['seo_url'] ?>">
                                                    <i class="arrow_left"></i>Önceki</a>
                                            </div>
                                            <a href="blog-<?php echo $prevcek['seo_url'] ?>"><?php echo $prevcek['title'] ?></a>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-6">
                            <div class="widget">
                                <div class="widget-next-post">
                                    <div class="small-post">
                                        <div class="image">
                                            <a href="blog-<?php echo $nextcek['seo_url'] ?>">
                                                <img src="<?php echo $nextcek['image'] ?>" alt="<?php echo $nextcek['title'] ?>">
                                            </a>
                                        </div>
                                        <div class="content">
                                            <div>
                                                <a class="link" href="blog-<?php echo $nextcek['seo_url'] ?>">
                                                    Sonraki <i class="arrow_right"></i></a>
                                            </div>
                                            <a href="blog-<?php echo $nextcek['seo_url'] ?>"><?php echo $nextcek['title'] ?></a>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    <?php } ?>

</div>

<?php

$yorumsor = $db->prepare("SELECT * FROM commentblog where blog_id='" . $id . "' and apply='1'");
                $yorumsor->execute();
                $yorumsay = $yorumsor->rowCount(); ?>
                
                <div class="widget mb-50">
                    <div class="title">
                        <h5><?php echo $yorumsay ?> Yorum</h5>
                    </div>
                    <ul class="widget-comments">
                        <?php
                        if ($yorumsay != 0) {
                            while ($yorumcek = $yorumsor->fetch(PDO::FETCH_ASSOC)) { ?>
                                <li class="comment-item">
                                    <div class="content">
                                        <ul class="info list-inline">
                                            <li><?php echo $yorumcek['name'] ?></li>
                                            <li class="dot"></li>
                                            <li>
                                                <?php
                                                $date = $yorumcek['time'];
                                                $datevideo = explode("-", $date);
                                                $dates = $datevideo[2];
                                                $datevideos = explode(" ", $dates);
                                                echo $datevideos[0];
                                                echo " ";
                                                if ($datevideo[1] == "01") {
                                                    echo "Ocak";
                                                } elseif ($datevideo[1] == "02") {
                                                    echo "Şubat";
                                                } elseif ($datevideo[1] == "03") {
                                                    echo "Mart";
                                                } elseif ($datevideo[1] == "04") {
                                                    echo "Nisan";
                                                } elseif ($datevideo[1] == "05") {
                                                    echo "Mayıs";
                                                } elseif ($datevideo[1] == "06") {
                                                    echo "Haziran";
                                                } elseif ($datevideo[1] == "07") {
                                                    echo "Temmuz";
                                                } elseif ($datevideo[1] == "08") {
                                                    echo "Ağustos";
                                                } elseif ($datevideo[1] == "09") {
                                                    echo "Eylül";
                                                } elseif ($datevideo[1] == "10") {
                                                    echo "Ekim";
                                                } elseif ($datevideo[1] == "11") {
                                                    echo "Kasım";
                                                } elseif ($datevideo[1] == "12") {
                                                    echo "Aralık";
                                                };
                                                echo " ";
                                                echo $datevideo[0];
                                                ?>
                                            </li>
                                        </ul>
                                        <p><?php echo $yorumcek['detail'] ?>
                                        </p>
                                    </div>
                                </li>
                        <?php }
                        } else {
                            echo "İlk yorumu yapan sen ol.";
                        } ?>
                    </ul>
                    
                    <div class="title">
                        <h5>Yorum Yap</h5>
                    </div>
                    <form class="widget-form" action="admin/netting/islem.php" method="POST" id="main_contact_form">
                        <div class="row">
                            <div class="col-md-12">
                                <div class="form-group">
                                    <input type="name" name="name" id="name" class="form-control" placeholder="İsim*" required="required">
                                </div>
                            </div>
                            <div class="col-md-12">
                                <div class="form-group">
                                    <textarea name="detail" id="message" cols="30" rows="5" class="form-control" placeholder="Mesaj*" required="required"></textarea>
                                </div>
                            </div>
                            <input type="hidden" name="id" value="<?php echo $blogcek['id']; ?>">
                            <input type="hidden" name="seo" value="<?php echo $blogcek['seo_url']; ?>">

<div class="col-12">
                                <button type="submit" name="add-blog-comment" class="btn-custom">
                                    Gönder
                                </button>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>
</section>

<?php include "footer.php" ?>