PHP Dosya Yöneticisi

<?php include "includes/header.php"; ?>
<?php
$sliderayar = $db->prepare("select * from slider_ayar where id='1'");
$sliderayar ->execute();
$slidayar = $sliderayar->fetch(PDO::FETCH_ASSOC);
?>
<?php
$slider = $db->prepare("select * from slider where dil='$_SESSION[dil]' and durum='1' and tur='1' order by sira asc");
$slider->execute();
?>
<?php
$serviceayar = $db->prepare("select * from hizmet_ayar where id='1'");
$serviceayar->execute();
$serv = $serviceayar->fetch(PDO::FETCH_ASSOC);
$hizmetlimit = 4;
?>
<?php
$num = 1;
$serviceliste = $db->prepare("select * from hizmet where durum='1' and dil='$_SESSION[dil]' and anasayfa='1' order by sira asc limit $hizmetlimit");
$serviceliste->execute();
?>

<?php
$faqSettings = $db->prepare("select * from sss_ayar where id=:id");
$faqSettings->execute(array(
    'id' => '1'
));
$faqset = $faqSettings->fetch(PDO::FETCH_ASSOC);
?>
<?php
$faqCek = $db->prepare("select * from sss where durum=:durum and dil=:dil order by sira asc");
$faqCek->execute(array(
    'durum' => '1',
    'dil' => $_SESSION['dil']
));
?>
<?php
$projesettings = $db->prepare("select * from proje_ayar where id='1'");
$projesettings->execute();
$proset = $projesettings->fetch(PDO::FETCH_ASSOC);
$projelimit = 4;

$proje_cat_list = $db->prepare("select * from proje_kat where durum='1' and dil='$_SESSION[dil]' and anasayfa='1' order by sira asc");
$proje_cat_list->execute();
?>
<?php
$yorumsettings = $db->prepare("select * from yorum_ayar where id='1'");
$yorumsettings->execute();
$yorumset = $yorumsettings->fetch(PDO::FETCH_ASSOC);
$yorumlimit = $yorumset["yorum_limit"];

?>
<?php
$num = 1;
$yorum_listele = $db->prepare("select * from yorum where durum='1' and dil='$_SESSION[dil]' order by sira asc limit $yorumlimit");
$yorum_listele->execute();
?>
<?php
$markasettings = $db->prepare("select * from marka_ayar where id='1'");
$markasettings->execute();
$markaset = $markasettings->fetch(PDO::FETCH_ASSOC);
$markalimit = $markaset["marka_limit"];

?>
<?php
$num = 1;
$marka_liste = $db->prepare("select * from marka where durum='1' order by sira asc limit $markalimit");
$marka_liste->execute();
?>
<?php
$blogsettings = $db->prepare("select * from blog_ayar where id='1'");
$blogsettings->execute();
$blogsett = $blogsettings->fetch(PDO::FETCH_ASSOC);
$bloglimit = 3;
?>
<?php
$num = 1;
$blogliste = $db->prepare("select * from blog where durum='1' and dil='$_SESSION[dil]' order by id desc limit $bloglimit");
$blogliste->execute();
?>
<?php
$countersettings = $db->prepare("select * from sayac_ayar where id='1'");
$countersettings->execute();
$countsett = $countersettings->fetch(PDO::FETCH_ASSOC);
?>
<?php
$counter_counts = $db->prepare("select * from sayac where durum='1' and dil='$_SESSION[dil]' order by sira asc");
$counter_counts->execute();
$sayi = 2;
?>

<?php
$sliderayar = $db->prepare("select * from slider_ayar where id='1'");
$sliderayar ->execute();
$slidayar = $sliderayar->fetch(PDO::FETCH_ASSOC);
?>
<?php
$slider_tur2 = $db->prepare("select * from slider where dil='$_SESSION[dil]' and durum='1' and tur='2' order by sira asc");
$slider_tur2->execute();
?>
<?php
$popupCek = $db->prepare("select * from popup where id='1'");
$popupCek->execute();
$popup = $popupCek->fetch(PDO::FETCH_ASSOC);
?>
<?php
$trigger1 = $db->prepare("select * from tetikleyiciler where dil='$_SESSION[dil]' and durum='1' and area='0' order by id desc limit 1");
$trigger1->execute();
?>
<?php
$urunkat_listele2 = $db->prepare("select * from urun_cat where dil='$_SESSION[dil]' and durum='1' and ust_id='0' order by sira asc");
$urunkat_listele2->execute();

<?php $refsor2=$db->prepare("select * from aktif WHERE id=1");
$refsor2->execute();
while ($refcek2=$refsor2->fetch(PDO::FETCH_ASSOC)) { if ($refcek2['durum']==1){ ?>
    
    <section class="main-slider style3">
        <div class="slider-box">
            
            <div class="banner-carousel owl-theme owl-carousel">
                <?php foreach ($slider as $row) { ?>
                <div class="slide">
                    <div class="image-layer" style="background-image:url(images/slider/<?php echo $row['gorsel']; ?>)">
                    </div>
                    <div class="auto-container">
                        <div class="content">
                            <div class="sub-title">
                                <div class="border-box-left"></div>
                                <h6><?php echo $row['altbaslik']; ?></h6>
                                <div class="border-box-right"></div>
                            </div>
                            <div class="big-title">
                                <h2><?php echo $row['baslik']; ?></h2>
                            </div>
                            <?php if($row['url'] == null) {} else { ?>
                            <div class="btns-box">
                                <a class="btn-one" href="<?php echo $row['url'] ?>">
                                    <span class="txt"><?php echo $row['button_text']; ?></span>
                                </a>
                            </div>
                            <?php } ?>
                        </div>
                    </div>
                </div>
                <?php } ?>

</div>
        </div>
    </section>
    
<?php }} ?>
<?php $refsor2=$db->prepare("select * from aktif WHERE id=2");
$refsor2->execute();
while ($refcek2=$refsor2->fetch(PDO::FETCH_ASSOC)) { if ($refcek2['durum']==1){ ?>
    
    <section class="highlights-area">
        <div class="container">
            <div class="highlights__content">
                <ul>
                    <li class="single-highlights-box">
                        <div class="inner">
                            <div class="icon">
                                <span class="flaticon-protection"></span>
                            </div>
                            <div class="text">
                                <h3><?php echo $diller['anasayfa1'] ?></h3>
                                <p><?php echo $diller['anasayfa2'] ?></p>
                            </div>
                        </div>
                        <div class="counting-box"></div>
                    </li>
                    <li class="single-highlights-box">
                        <div class="inner">
                            <div class="icon">
                                <span class="flaticon-quality"></span>
                            </div>
                            <div class="text">
                                <h3><?php echo $diller['anasayfa3'] ?></h3>
                                <p><?php echo $diller['anasayfa4'] ?></p>
                            </div>
                        </div>
                        <div class="counting-box"></div>
                    </li>
                    <li class="single-highlights-box">
                        <div class="inner">
                            <div class="icon">
                                <span class="flaticon-construction-and-tools"></span>
                            </div>
                            <div class="text">
                                <h3><?php echo $diller['anasayfa5'] ?></h3>
                                <p><?php echo $diller['anasayfa6'] ?></p>
                            </div>
                        </div>
                        <div class="counting-box"></div>
                    </li>

</ul>
            </div>
        </div>
    </section>
    
<?php }} ?>
<?php $refsor2=$db->prepare("select * from aktif WHERE id=3");
$refsor2->execute();
while ($refcek2=$refsor2->fetch(PDO::FETCH_ASSOC)) { if ($refcek2['durum']==1){ ?>
    
    <section class="service-style2-area">
        <div class="container">
            <div class="service-style2__top-title">
                <div class="sec-title">
                    <div class="sub-title">
                        <h6><span class="border-left"></span><?php echo $diller['anasayfa7'] ?></h6>
                    </div>
                    <h2><?php echo $diller['anasayfa8'] ?></h2>
                </div>
                <div class="btn-box">
                    <a class="btn-one" href="hizmetler">
                        <span class="txt">Tümünü Görüntüle</span>
                    </a>
                </div>
            </div>
            <div class="row">
                <div class="col-xl-12 col-lg-12">
                    <div class="theme_carousel service-style2-carousel owl-dot-style1 owl-theme owl-carousel"
                         data-options='{"loop": true, "margin": 30, "autoheight":true, "lazyload":true, "nav": false, "dots": true, "autoplay": true, "autoplayTimeout": 6000, "smartSpeed": 300, "responsive":{ "0" :{ "items": "1" }, "600" :{ "items" : "1" }, "768" :{ "items" : "1" } , "992":{ "items" : "2" }, "1200":{ "items" : "3" }}}'>
                        <?php
                        $Service_Liste = $db->query("select * from hizmet where durum='1' and dil='$_SESSION[dil]' order by sira ASC limit 9");
                        $ServiceAl = $Service_Liste->fetchAll(PDO::FETCH_ASSOC);
                        ?>
                        <?php foreach ($ServiceAl as $ser)  { ?>
                        <div class="single-service-style2 wow fadeInUp" data-wow-delay="00ms"
                             data-wow-duration="1500ms">
                            <div class="inner-box">
                                <div class="img-holder">
                                    <img style="width: 100%;height: 290px;object-fit: cover;" src="images/services/<?php echo $ser['gorsel'] ?>" alt="<?php echo $ser['baslik'] ?>">
                                </div>
                                <div class="title-holder clearfix">
                                    <div class="inner-text">
                                        <h3><a href="hizmet/<?php echo seo($ser['id'])?>/<?php echo seo($ser['baslik']) ?>"><?php echo $ser['baslik'] ?></a></h3>
                                        <p><?php echo $ser['spot'] ?></p>
                                    </div>
                                    <div class="icon">
                                        <div class="pattern-bg"
                                             style="background-image: url(tema/images/pattern/thm-pattern-1.png);">
                                        </div>
                                        <span style="margin-left: 10px" class="fa <?php echo $ser['icon'] ?>"></span>
                                        <div class="overlay">
                                            <a href="hizmet/<?php echo seo($ser['id'])?>/<?php echo seo($ser['baslik']) ?>"><i class="fa fa-angle-right"
                                                                               aria-hidden="true"></i></a>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <?php }?>
                    </div>
                </div>

</div>
        </div>
    </section>
    
<?php }} ?>
<?php $refsor2=$db->prepare("select * from aktif WHERE id=4");
$refsor2->execute();
while ($refcek2=$refsor2->fetch(PDO::FETCH_ASSOC)) { if ($refcek2['durum']==1){ ?>
    
    <section class="fact-counter-area">
        <div class="fact-counter-area_bg"
             style="background-image: url(tema/images/parallax-background/fact-counter-area-bg.jpg);"></div>
        <div class="container">
            <div class="row">
                <?php
                $SayacCek = $db->query("select * from sayac where durum='1' order by sira ASC limit 4");
                $SayacAl = $SayacCek->fetchAll(PDO::FETCH_ASSOC);
                foreach ($SayacAl as $Sayac)  {?>
                <div class="col-xl-3 col-lg-6 col-md-6">
                    <div class="single-fact-counter text-center wow slideInUp" data-wow-delay="00ms"
                         data-wow-duration="1500ms">
                        <div class="inner">
                            <div class="pattern-bg"
                                 style="background-image: url(tema/images/pattern/thm-pattern-3.png);"></div>
                            <div class="icon">
                                <span class="fa <?php echo $Sayac['icon']; ?>"></span>
                            </div>
                            <div class="count-outer count-box">
                                <span class="count-text" data-speed="3000" data-stop="<?php echo $Sayac['count']; ?>">0</span>
                                <span class="k"></span>
                            </div>
                        </div>
                        <div class="title">
                            <h3><?php echo $Sayac['baslik']; ?></h3>
                        </div>
                    </div>
                </div>
                <?php }?>
            </div>
        </div>
    </section>
    
<?php }} ?>
<?php $refsor2=$db->prepare("select * from aktif WHERE id=5");
$refsor2->execute();
while ($refcek2=$refsor2->fetch(PDO::FETCH_ASSOC)) { if ($refcek2['durum']==1){ ?>
    
    <section class="project-style1-area  pdb60">
        <div class="container">
            <div class="project-top-title style2">
                <div class="sec-title">
                    <div class="sub-title">
                        <h6><span class="border-left"></span><?php echo $diller['anasayfa9'] ?></h6>
                    </div>
                    <h2><?php echo $diller['anasayfa10'] ?></h2>
                </div>
                <div class="project-menu-box wow fadeInUp" data-wow-delay="100ms" data-wow-duration="1500ms">
                    <ul class="project-filter clearfix post-filter has-dynamic-filters-counter">
                        <li data-filter=".tumu" class="active"><span class="filter-text">Tümü</span></li>
                        <?php
                        $refsor=$db->prepare("select * from proje_kat where durum='1' and dil='$_SESSION[dil]' order by sira ASC");
                        $refsor->execute();
                        if ($refsor->rowCount()){
                            while ($ser=$refsor->fetch(PDO::FETCH_ASSOC)) {
                                ?>
                                <li data-filter=".<?php echo $ser['id'] ?>"><span class="filter-text"><?php echo $ser['baslik'] ?></span></li>
                            <?php }} ?>
                    </ul>
                </div>
            </div>
        </div>
        <div class="container">
            <div class="row filter-layout masonary-layout text-right-rtl">
                <?php
                $refsor2=$db->prepare("select * from proje where durum='1' and dil='$_SESSION[dil]' order by id DESC LIMIT 9");
                $refsor2->execute();
                if ($refsor2->rowCount()){
                    while ($ser2=$refsor2->fetch(PDO::FETCH_ASSOC)) {
                        $iceriksor=$db->prepare("SELECT * FROM proje_kat where id=:id and durum=:durum");
                        $iceriksor->execute(array('id' => $ser2['kat_id'], 'durum' => 1));
                        $icerikcek=$iceriksor->fetch(PDO::FETCH_ASSOC);
                        ?>
                        <div class="col-xl-4 col-lg-6 col-md-12 tumu <?php echo $ser2['kat_id'] ?>">
                            <div class="single-project-item style2">
                                <div class="img-holder">
                                    <div class="inner">
                                        <img style="width: 100%;height: 300px;object-fit: cover;" src="images/projects/<?php echo $ser2['gorsel'] ?>" alt="<?php echo $ser2['baslik'] ?>">
                                    </div>
                                    <div class="overlay-content text-center">
                                        <p><?php echo $icerikcek['baslik'] ?></p>
                                        <h3><a href="proje/<?php echo seo($ser2['id'])?>/<?php echo seo($ser2['baslik']) ?>"><?php echo $ser2['baslik'] ?></a></h3>
                                        <div class="border-box"></div>
                                        <ul>
                                            <li>
                                                <a class="lightbox-image" data-fancybox="gallery"
                                                   href="images/projects/<?php echo $ser2['gorsel'] ?>">
                                                    <i class="flaticon-zoom"></i>
                                                </a>
                                            </li>
                                            <li><a href="proje/<?php echo seo($ser2['id'])?>/<?php echo seo($ser2['baslik']) ?>"><span class="flaticon-plus-1"></span></a></li>
                                        </ul>
                                    </div>
                                    <div class="static-content">
                                        <p><?php echo $icerikcek['baslik'] ?></p>
                                        <h3><a href="proje/<?php echo seo($ser2['id'])?>/<?php echo seo($ser2['baslik']) ?>"><?php echo $ser2['baslik'] ?></a></h3>
                                    </div>
                                </div>
                            </div>
                        </div>
                    <?php }} ?>
            </div>

</div>
    </section>
    
<?php }} ?>
<?php $refsor2=$db->prepare("select * from aktif WHERE id=6");
$refsor2->execute();
while ($refcek2=$refsor2->fetch(PDO::FETCH_ASSOC)) { if ($refcek2['durum']==1){ ?>
    
    <section class="faq-style1-area">
        <div class="faq-style1-bg" style="background-image: url(tema/images/resources/faq-style1-bg.jpg);"></div>
        <div class="container">
            <div class="row">

<div class="input-box">
                                    <textarea name="mesaj" placeholder="İletmek İstediğiniz Mesaj"
                                              required=""></textarea>
                            </div>
                            <div class="button-box">
                                <button name="contactgonder" class="btn-one" type="submit">
                                    <span class="txt">Mesaj Gönder</span>
                                </button>
                            </div>
                        </form>

</div>
                </div>

<div class="col-xl-6 col-lg-7 text-right-rtl">
                    <div class="faq-style1-content">
                        <div class="sec-title">
                            <div class="sub-title">
                                <h6><span class="border-left"></span> <?php echo $diller['anasayfa14'] ?></h6>
                            </div>
                            <h2><?php echo $diller['anasayfa15'] ?></h2>
                        </div>
                        <ul class="accordion-box">
                            <?php
                            $refsor=$db->prepare("select * from sss order by sira ASC limit 0,1");
                            $refsor->execute();
                            while ($refcek=$refsor->fetch(PDO::FETCH_ASSOC)) {
                                if ($refcek['durum']==1){
                                    ?>
                                    <li class="accordion block active-block">
                                        <div class="acc-btn active">
                                            <div class="icon-outer"><i class="flaticon-down-arrow-2"></i></div>
                                            <h3><span>1.</span> <?php echo $refcek['soru']; ?></h3>
                                        </div>
                                        <div class="acc-content current">
                                            <p><?php echo $refcek['cevap']; ?></p>
                                        </div>
                                    </li>
                                <?php }} ?>
                            <?php
                            $refsor=$db->prepare("select * from sss order by sira ASC limit 1,7");
                            $refsor->execute();
                            $sayi = 2;
                            while ($refcek=$refsor->fetch(PDO::FETCH_ASSOC)) {
                                if ($refcek['durum']==1){
                                    ?>
                                    <li class="accordion block">
                                        <div class="acc-btn">
                                            <div class="icon-outer"><i class="flaticon-down-arrow-2"></i></div>
                                            <h3><span><?php echo $sayi++;?>.</span> <?php echo $refcek['soru']; ?>
                                            </h3>
                                        </div>
                                        <div class="acc-content">
                                            <p><?php echo $refcek['cevap']; ?></p>
                                        </div>
                                    </li>
                                <?php }} ?>

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

</div>
        </div>
    </section>
    
<?php }} ?>
<?php $refsor2=$db->prepare("select * from aktif WHERE id=7");
$refsor2->execute();
while ($refcek2=$refsor2->fetch(PDO::FETCH_ASSOC)) { if ($refcek2['durum']==1){ ?>
    
    <section class="testimonials-style1-area">
        <div class="container">
            <div class="sec-title center text-center">
                <div class="sub-title">
                    <h6><span class="border-left"></span> <?php echo $diller['anasayfa16'] ?> <span class="border-right"></span></h6>
                </div>
                <h2><?php echo $diller['anasayfa17'] ?></h2>
            </div>

<?php
                            $YorumListele = $db->prepare("select * from yorum where durum=:durum and dil=:dil order by sira asc LIMIT 50");
                            $YorumListele->execute(array(
                                'durum' => '1',
                                'dil' => $_SESSION['dil']
                            ));
                            foreach ($YorumListele as $Yorum) { ?>
                            <div class="single-testimonials-style1">
                                <div class="img-holder">
                                    <div class="top-pattern-bg"
                                         style="background-image: url(tema/images/pattern/thm-pattern-4.png);">
                                    </div>
                                    <div class="bottom-pattern-bg"
                                         style="background-image: url(tema/images/pattern/thm-pattern-5.png);">
                                    </div>
                                    <div class="img-box">
                                        <?php
                                        if($Yorum['gorsel']== "no-image")
                                        {
                                            ?>
                                            <img style="height: 100%" src="images/comments/yorum.jpg" alt="<?php echo $Yorum['isim'] ?>">
                                        <?php } else { ?>
                                            <img src="images/comments/<?php echo $Yorum['gorsel'] ?>" alt="<?php echo $Yorum['isim'] ?>">
                                        <?php }?>
                                    </div>
                                </div>
                                <div class="text-holder" style="margin-top: -10px">
                                    <div class="top">
                                        <div class="icon">
                                            <span class="flaticon-quote-3"></span>
                                        </div>
                                        <div class="name">
                                            <h3><?=$Yorum['isim']?></h3>
                                            <span><?=$Yorum['pozisyon']?></span>
                                        </div>
                                    </div>
                                    <div class="text">
                                        <p ><?=$Yorum['icerik']?></p><br>
                                    </div>
                                </div>
                            </div>
                            <?php }?>

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

</div>
    </section>
    
<?php }} ?>
<?php $refsor2=$db->prepare("select * from aktif WHERE id=8");
$refsor2->execute();
while ($refcek2=$refsor2->fetch(PDO::FETCH_ASSOC)) { if ($refcek2['durum']==1){ ?>
    
    <section class="team-style1-area">
        <div class="pattern-bg" style="background-image: url(tema/images/pattern/thm-pattern-4.png);"></div>
        <div class="container">
            <div class="sec-title">
                <div class="sub-title">
                    <h6><span class="border-left"></span><?php echo $diller['anasayfa18'] ?></h6>
                </div>
                <h2><?php echo $diller['anasayfa19'] ?></h2>
            </div>
            <div class="row">
                <div class="col-xl-12">
                    <div class="owl-carousel owl-theme team-carousel owl-nav-style-one">
                        <?php
                        $ekip_listele = $db->prepare("select * from ekip where durum=:durum and dil=:dil order by sira asc LIMIT 4");
                        $ekip_listele->execute(array(
                            'durum' => '1',
                            'dil' => $_SESSION['dil']
                        ));
                        foreach ($ekip_listele as $ekip) { ?>
                        <div class="single-team-style1 wow fadeInLeft animated" data-wow-delay="300ms"
                             data-wow-duration="1500ms">
                            <div class="img-holder">
                                <div class="inner">
                                    <img style="width: 100%!important;height: 300px;object-fit: cover;" src="images/team/<?php echo $ekip['gorsel'] ?>" alt="<?php echo $ekip['isim'] ?>">
                                    <div class="overlay-bg"></div>
                                </div>
                            </div>
                            <div class="title-holder">
                                <h3><a><?php echo $ekip['isim'] ?></a></h3>
                                <p><?php echo $ekip['pozisyon'] ?></p>
                                <div class="social-link-box">
                                    <ul class="team-social-link">
                                        <?php
                                        $ekip_sosyal = $db->prepare("select * from ekip_sosyal where ekip_id='$ekip[id]' order by sira asc");
                                        $ekip_sosyal->execute();
                                        while($sos = $ekip_sosyal->fetch(PDO::FETCH_ASSOC))
                                        {
                                            ?>
                                            <li><a href="<?php echo $sos['url'] ?>" target="_blank"><i class="fa <?php echo $sos['icon'] ?>" aria-hidden="true"></i></a></li>
                                        <?php } ?>
                                    </ul>
                                </div>
                            </div>
                        </div>
                        <?php }?>
                    </div>
                </div>

</div>
        </div>
    </section>
    
<?php }} ?>
<?php $refsor2=$db->prepare("select * from aktif WHERE id=9");
$refsor2->execute();
while ($refcek2=$refsor2->fetch(PDO::FETCH_ASSOC)) { if ($refcek2['durum']==1){ ?>
    
    <section class="blog-style2-area">
        <div class="container">
            <div class="service-style2__top-title">
                <div class="sec-title">
                    <div class="sub-title">
                        <h6><span class="border-left"></span><?php echo $diller['anasayfa20'] ?></h6>
                    </div>
                    <h2><?php echo $diller['anasayfa21'] ?></h2>
                </div>
                <div class="btn-box">
                    <a class="btn-one" href="bloglar">
                        <span class="txt">Tümünü Görüntüle</span>
                    </a>
                </div>
            </div>
            <div class="row text-right-rtl">
                <div class="col-xl-12 col-lg-12">
                    <div class="theme_carousel blog-style2-carousel owl-dot-style1 owl-theme owl-carousel"
                         data-options='{"loop": true, "margin": 30, "autoheight":true, "lazyload":true, "nav": false, "dots": true, "autoplay": true, "autoplayTimeout": 5000, "smartSpeed": 500, "responsive":{ "0" :{ "items": "1" }, "600" :{ "items" : "1" }, "768" :{ "items" : "1" } , "992":{ "items" : "2" }, "1200":{ "items" : "3" }}}'>
                    <?php foreach ($blogliste as $blog) { ?>
                        <div class="single-blog-style1 wow fadeInUp" data-wow-delay="00ms" data-wow-duration="1500ms">

</div>
                            </div>
                        </div>
                    <?php } ?>
                    </div>
                </div>
            </div>
        </div>
    </section>
    
<?php }} ?>

<?php include "includes/footer.php"; ?>

İptal

📁 PHP Dosya Yöneticisi

📝 index.php

📝 index.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)