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
$resimcek1 = $db->prepare("select * from siteresim where id=:id");
$resimcek1->execute(array('id' => 1));
$resim1 = $resimcek1->fetch(PDO::FETCH_ASSOC);

$resimcek2 = $db->prepare("select * from siteresim where id=:id");
$resimcek2->execute(array('id' => 2));
$resim2 = $resimcek2->fetch(PDO::FETCH_ASSOC);

$resimcek3 = $db->prepare("select * from siteresim where id=:id");
$resimcek3->execute(array('id' => 3));
$resim3 = $resimcek3->fetch(PDO::FETCH_ASSOC);

$resimcek4 = $db->prepare("select * from siteresim where id=:id");
$resimcek4->execute(array('id' => 4));
$resim4 = $resimcek4->fetch(PDO::FETCH_ASSOC);

$resimcek5 = $db->prepare("select * from siteresim where id=:id");
$resimcek5->execute(array('id' => 5));
$resim5 = $resimcek5->fetch(PDO::FETCH_ASSOC);

$resimcek6 = $db->prepare("select * from siteresim where id=:id");
$resimcek6->execute(array('id' => 6));
$resim6 = $resimcek6->fetch(PDO::FETCH_ASSOC);

$resimcek7 = $db->prepare("select * from siteresim where id=:id");
$resimcek7->execute(array('id' => 7));
$resim7 = $resimcek7->fetch(PDO::FETCH_ASSOC);

$resimcek8 = $db->prepare("select * from siteresim where id=:id");
$resimcek8->execute(array('id' => 8));
$resim8 = $resimcek8->fetch(PDO::FETCH_ASSOC);
?>

<?php $refsor2=$db->prepare("select * from aktif WHERE id=1");
$refsor2->execute();
while ($refcek2=$refsor2->fetch(PDO::FETCH_ASSOC)) { if ($refcek2['durum']==1){ ?>
    
    <div class="primary-hero">
        <div class="container">
            <div class="row justify-content-center">
                <div class="col-lg-8">
                    <h1 class="d2 text-center mb-6"> <?php echo $diller['anasayfa1'] ?> </h1>
                    <p class="max-text-40 mx-auto text-center fs-20 mb-10"> <?php echo $diller['anasayfa2'] ?> </p>
                </div>
                <div class="col-xxl-10">
                    <form action="firmalar" method="get">
                        <div class="property-search p-6 rounded-3 bg-neutral-0">
                            <div class="property-search__content d-flex flex-wrap justify-content-center align-items-center gap-4">
                                <div class="property-search__select property-search__col rounded-pill d-flex align-items-center gap-2 px-6">
                                    <span class="material-symbols-outlined mat-icon"> water_damage </span>
                                    <input name="isim" type="text" style="display: block;
    width: 100%;height: 45px;
    padding: 0.375rem 2.25rem 0.375rem 0.75rem;
    -moz-padding-start: calc(.75rem - 3px);
    font-size: 1rem;
    font-weight: 400;
    line-height: 1.5;
    color: var(--bs-body-color);
    background-color: var(--bs-form-control-bg);
    background-image: var(--bs-form-select-bg-img),var(--bs-form-select-bg-icon,none);
    background-repeat: no-repeat;
    background-position: right 0.75rem center;
    background-size: 16px 12px;
    border: var(--bs-border-width) solid var(--bs-border-color);
    transition: border-color .15s ease-in-out,box-shadow .15s ease-in-out;
    -webkit-appearance: none;
    -moz-appearance: none;
    appearance: none;" placeholder="Firma İsmi">
                                </div>
                                <div class="property-search__select property-search__col rounded-pill d-flex align-items-center gap-2 px-6">
                                    <span class="material-symbols-outlined mat-icon"> grid_view </span>
                                    <select class="form-select" name="sektor">
                                        <option>Sektör Seçiniz</option>
                                        <?php
                                        $refsor=$db->prepare("select * from proje_kat where durum='1' and dil='$_SESSION[dil]' order by sira ASC");
                                        $refsor->execute();
                                        while ($ser=$refsor->fetch(PDO::FETCH_ASSOC)) {
                                            ?>
                                            <option value="<?php echo $ser['id'] ?>"><?php echo $ser['baslik'] ?></option>
                                        <?php } ?>
                                    </select>
                                </div>
                                <div class="property-search__select property-search__col rounded-pill d-flex align-items-center gap-2 px-6">
                                    <span class="material-symbols-rounded mat-icon"> distance </span>
                                    <select class="form-select" name="il">
                                        <option>Şehir Seçiniz</option>
                                        <?php
                                        $sehir = $db->prepare("select * from iller order by id asc");
                                        $sehir->execute();

foreach ($sehir as $ilsen) {?>
                                            <option value="<?=$ilsen['id']?>"><?=$ilsen['name']?></option>
                                        <?php }?>
                                    </select>
                                </div>
                                <button class="btn rounded-pill property-search__btn property-search__col">
                                    <span class="material-symbols-rounded mat-icon"> search </span>
                                </button>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
        </div>
        <img src="images/slider/<?php echo $resim2['gorsel']; ?>" alt="image" class="img-fluid primary-hero__el primary-hero__img-1">
        <img src="images/slider/<?php echo $resim1['gorsel']; ?>" alt="image" class="img-fluid primary-hero__el primary-hero__img-2">
        <img src="tema/img/primary-hero-el-3.png" alt="image" class="img-fluid primary-hero__el primary-hero__el-3">
        <img src="tema/img/primary-hero-el-4.png" alt="image" class="img-fluid primary-hero__el primary-hero__el-4">
        <img src="tema/img/primary-hero-el-5.png" alt="image" class="img-fluid primary-hero__el primary-hero__el-5">
        <img src="tema/img/primary-hero-el-6.png" alt="image" class="img-fluid primary-hero__el primary-hero__el-6">
        <img src="tema/img/primary-hero-el-7.png" alt="image" class="img-fluid primary-hero__el primary-hero__el-7">
        <img src="tema/img/primary-hero-el-8.png" alt="image" class="img-fluid primary-hero__el primary-hero__el-8">
        <div class="scroll-nav text-center">
            <div class="w-15 h-15 d-grid place-content-center bg-primary-300 clr-neutral-0 rounded-circle">
                <span class="material-symbols-outlined mat-icon"> south </span>
            </div>
        </div>
    </div>
    
<?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="section-space position-relative z-1">
        <img src="tema/img/category-section-el.png" alt="image" class="img-fluid d-none d-xxl-block position-absolute category-section-element">
        <div class="section-space--sm-bottom">
            <div class="container">
                <div class="row justify-content-center">
                    <div class="col-lg-8 col-xxl-6">
                        <div class="text-center">
              <span class="d-inline-flex align-items-center bg-primary-50 gap-4 rounded-pill py-1 ps-1 pe-5">
                <span class="w-9 h-9 rounded-circle d-grid place-content-center bg-primary-300 clr-neutral-0 flex-shrink-0">
                  <span class="material-symbols-outlined mat-icon fw-200"> arrow_right_alt </span>
                </span>
                <span class="h5 lh-1 m-0 clr-primary-400 fw-semibold"> <?php echo $diller['anasayfa3'] ?> </span>
              </span>
                            <h2 class="mt-4"> <?php echo $diller['anasayfa4'] ?> </h2>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <div class="container">
            <div class="row g-4">
            <?php
            $refsor=$db->prepare("select * from proje_kat where durum='1' and dil='$_SESSION[dil]' order by sira ASC limit 7");
            $refsor->execute();
            if ($refsor->rowCount()){
                while ($blog=$refsor->fetch(PDO::FETCH_ASSOC)) {
                    ?>
                <div class="col-md-6 col-lg-4 col-xl-3">
                    <div class="category-card border rounded-4 transition bg-neutral-0 :bg-primary-300 :clr-neutral-0">
                        <div class="p-8">
                            <a href="kategori/<?php echo seo($blog['id'])?>/<?php echo seo($blog['baslik']) ?>" style="text-decoration:none">
                            <img style="50px;height: 50px;" src="images/projects/<?php echo $blog['gorsel'] ?>" alt="<?php echo $blog['baslik'] ?>">
                            <h5 class="mt-5 transition"> <?php echo $blog['baslik'] ?> </h5>
                            </a>
                            <p class="mb-0"> <?php echo $blog['spot'] ?> </p>
                        </div>
                        <div class="category-card__footer transition">
                            <a href="kategori/<?php echo seo($blog['id'])?>/<?php echo seo($blog['baslik']) ?>" class="link d-flex gap-1 align-items-center fw-semibold clr-primary-400 transition p-8"> Firmaları Göster <span class="material-symbols-outlined mat-icon fw-200"> arrow_right_alt </span>
                            </a>
                        </div>
                    </div>
                </div>
                <?php }?>

<?php }else{?>
                <div class="col-xl-12 col-lg-12">
                    <h3>Henüz içerik eklenmedi...</h3>
                </div>
            <?php }?>
                <div class="col-md-6 col-lg-4 col-xl-3">
                    <a href="kategoriler" class="circle-btn link bg-secondary-75 text-center rounded-circle">
                        <?php
                        $kategorisayisi=$db->prepare("select * from proje_kat where durum='1'");
                        $kategorisayisi->execute();
                        ?>
                        <span class="d4 d-block text-center clr-neutral-900 transition"> <?php echo $kategorisayisi->rowCount();?>+ </span>

<span class="d-block text-center clr-neutral-900 max-text-20 mb-6 transition"> Tüm Kategorilere Gitmek İçin Tıklayınız </span>
                        <span class="circle-btn__arrow d-grid w-15 h-15 rounded-circle place-content-center bg-neutral-0 clr-neutral-900 mx-auto transition">
              <span class="material-symbols-outlined mat-icon fs-32 lh-1"> arrow_outward </span>
            </span>
                    </a>
                </div>
            </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="section-space bg-primary-5p">
        <div class="section-space--sm-bottom">
            <div class="container">
                <div class="row justify-content-center">
                    <div class="col-lg-8 col-xxl-6">
                        <div class="text-center">
              <span class="d-inline-flex align-items-center bg-primary-50 gap-4 rounded-pill py-1 ps-1 pe-5">
                <span class="w-9 h-9 rounded-circle d-grid place-content-center bg-primary-300 clr-neutral-0 flex-shrink-0">
                  <span class="material-symbols-outlined mat-icon fw-200"> arrow_right_alt </span>
                </span>
                <span class="h5 lh-1 m-0 clr-primary-400 fw-semibold"> <?php echo $diller['anasayfa5'] ?> </span>
              </span>
                            <h2 class="mt-4 mb-6"> <?php echo $diller['anasayfa6'] ?> </h2>
                            <p class="mb-0"> <?php echo $diller['anasayfa7'] ?> </p>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <div class="container">
            <div class="row g-4">
                <div class="col-md-6 col-lg-4">
                    <div class="service-card rounded-4 bg-neutral-0 transition :bg-primary-300 :clr-neutral-0">
                        <div class="text-center px-14 pt-8 pb-4">
                            <img src="images/slider/<?php echo $resim6['gorsel']; ?>" alt="image" class="img-fluid w-100">
                        </div>
                        <div class="text-center px-8 pb-8 pt-4">
                            <h3 class="mb-4"> <?php echo $diller['anasayfa8'] ?> </h3>
                            <p class="mb-10 clr-neutral-500"> <?php echo $diller['anasayfa9'] ?> </p>
                            <a href="<?php echo $diller['anasayfa11'] ?>" class="btn btn-outline-primary py-3 px-6 rounded-pill d-inline-flex align-items-center gap-1 fw-semibold"> <?php echo $diller['anasayfa10'] ?> </a>
                        </div>
                    </div>
                </div>
                <div class="col-md-6 col-lg-4">
                    <div class="service-card rounded-4 bg-neutral-0 transition :bg-primary-300 :clr-neutral-0">
                        <div class="text-center px-14 pt-8 pb-4">
                            <img src="images/slider/<?php echo $resim7['gorsel']; ?>" alt="image" class="img-fluid w-100">
                        </div>
                        <div class="text-center px-8 pb-8 pt-4">
                            <h3 class="mb-4"> <?php echo $diller['anasayfa12'] ?> </h3>
                            <p class="mb-10 clr-neutral-500"> <?php echo $diller['anasayfa13'] ?> </p>
                            <a href="<?php echo $diller['anasayfa15'] ?>" class="btn btn-outline-primary py-3 px-6 rounded-pill d-inline-flex align-items-center gap-1 fw-semibold"> <?php echo $diller['anasayfa14'] ?> </a>
                        </div>
                    </div>
                </div>
                <div class="col-md-6 col-lg-4">
                    <div class="service-card rounded-4 bg-neutral-0 transition :bg-primary-300 :clr-neutral-0">
                        <div class="text-center px-14 pt-8 pb-4">
                            <img src="images/slider/<?php echo $resim8['gorsel']; ?>" alt="image" class="img-fluid w-100">
                        </div>
                        <div class="text-center px-8 pb-8 pt-4">
                            <h3 class="mb-4"> <?php echo $diller['anasayfa16'] ?> </h3>
                            <p class="mb-10 clr-neutral-500"> <?php echo $diller['anasayfa166'] ?> </p>
                            <a href="<?php echo $diller['anasayfa18'] ?>" class="btn btn-outline-primary py-3 px-6 rounded-pill d-inline-flex align-items-center gap-1 fw-semibold"> <?php echo $diller['anasayfa17'] ?> </a>
                        </div>
                    </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="section-space calculate-section">
        <div class="calculate-section__content">
            <div class="container">
                <div class="row">
                    <div class="col-lg-6">
            <span class="d-inline-flex align-items-center bg-primary-50 gap-4 rounded-pill py-1 ps-1 pe-5">
              <span class="w-9 h-9 rounded-circle d-grid place-content-center bg-primary-300 clr-neutral-0 flex-shrink-0">
                <span class="material-symbols-outlined mat-icon fw-200"> arrow_right_alt </span>
              </span>
              <span class="h5 lh-1 m-0 clr-primary-400 fw-semibold"> <?php echo $diller['anasayfa19'] ?> </span>
            </span>
                        <h2 class="mt-4 mb-6"> <?php echo $diller['anasayfa20'] ?> </h2>
                        <p class="mb-10"> <?php echo $diller['anasayfa21'] ?> </p>
                        <a href="<?php echo $diller['anasayfa23'] ?>" class="link d-inline-flex align-items-center gap-2 py-3 px-6 rounded-pill bg-primary-300 clr-neutral-0 :bg-primary-400 :clr-neutral-0 fw-semibold">
                            <span class="material-symbols-outlined"> calculate </span>
                            <span class="d-inline-block"> <?php echo $diller['anasayfa22'] ?> </span>
                        </a>
                    </div>
                </div>
            </div>
        </div>
    </section>
    <style>
        .calculate-section::after {
            background-image: url(images/slider/<?php echo $resim4['gorsel']; ?>) !important;
        }
        .benefit-section::after {
            background-image: url(images/slider/<?php echo $resim3['gorsel']; ?>) !important;
        }
        .cta-section-ii::after {
            background-image: url(images/slider/<?php echo $resim5['gorsel']; ?>) !important;
        }
    </style>
    
<?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="section-space benefit-section">

<div class="container">
            <div class="row justify-content-lg-end">
                <div class="col-lg-8 col-xl-7">
                    <div class="benefit-section__content">
            <span class="d-inline-flex align-items-center bg-primary-50 gap-4 rounded-pill py-1 ps-1 pe-5">
              <span class="w-9 h-9 rounded-circle d-grid place-content-center bg-primary-300 clr-neutral-0 flex-shrink-0">
                <span class="material-symbols-outlined mat-icon fw-200"> arrow_right_alt </span>
              </span>
              <span class="h5 lh-1 m-0 clr-primary-400 fw-semibold"> <?php echo $diller['anasayfa24'] ?> </span>
            </span>
                        <h2 class="mt-4 mb-6"> <?php echo $diller['anasayfa25'] ?> </h2>
                        <p class="mb-10"> <?php echo $diller['anasayfa26'] ?> </p>
                        <div class="row g-4">
                            <div class="col-md-6">
                                <div class="d-flex gap-5 rounded-4 bg-primary-5p p-6">
                                    <div class="flex-shrink-0">
                                        <img src="tema/img/benefit-icon-1.png" alt="image" class="img-fluid">
                                    </div>
                                    <div class="flex-grow-1">
                                        <h5> <?php echo $diller['anasayfa27'] ?> </h5>
                                        <p class="mb-0"> <?php echo $diller['anasayfa28'] ?> </p>
                                    </div>
                                </div>
                            </div>
                            <div class="col-md-6">
                                <div class="d-flex gap-5 rounded-4 bg-primary-5p p-6">
                                    <div class="flex-shrink-0">
                                        <img src="tema/img/benefit-icon-2.png" alt="image" class="img-fluid">
                                    </div>
                                    <div class="flex-grow-1">
                                        <h5> <?php echo $diller['anasayfa29'] ?> </h5>
                                        <p class="mb-0"> <?php echo $diller['anasayfa30'] ?> </p>
                                    </div>
                                </div>
                            </div>
                            <div class="col-md-6">
                                <div class="d-flex gap-5 rounded-4 bg-primary-5p p-6">
                                    <div class="flex-shrink-0">
                                        <img src="tema/img/benefit-icon-3.png" alt="image" class="img-fluid">
                                    </div>
                                    <div class="flex-grow-1">
                                        <h5> <?php echo $diller['anasayfa31'] ?> </h5>
                                        <p class="mb-0"> <?php echo $diller['anasayfa32'] ?> </p>
                                    </div>
                                </div>
                            </div>
                            <div class="col-md-6">
                                <div class="d-flex gap-5 rounded-4 bg-primary-5p p-6">
                                    <div class="flex-shrink-0">
                                        <img src="tema/img/benefit-icon-4.png" alt="image" class="img-fluid">
                                    </div>
                                    <div class="flex-grow-1">
                                        <h5> <?php echo $diller['anasayfa33'] ?> </h5>
                                        <p class="mb-0"> <?php echo $diller['anasayfa34'] ?> </p>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </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){ ?>
    
    <div class="bg-secondary-50">
        <div class="container">
            <div class="row">
                <div class="col-12">
                    <div class="section-space cta-section-ii">
                        <div class="row">
                            <div class="col-md-10 col-lg-6 col-xl-5">
                                <h2 class="mb-6"> <?php echo $diller['anasayfa35'] ?> </h2>
                                <p class="mb-10"> <?php echo $diller['anasayfa36'] ?> </p>
                                <a href="<?php echo $diller['anasayfa38'] ?>" class="link d-inline-flex align-items-center gap-2 py-3 px-6 rounded-pill bg-tertiary-300 clr-neutral-900 :bg-tertiary-300 :clr-neutral-900">
                                    <span class="d-inline-block fw-semibold"> <?php echo $diller['anasayfa37'] ?> </span>
                                    <span class="material-symbols-outlined mat-icon fw-200"> trending_flat </span>
                                </a>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
    
<?php }} ?>

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

İptal

📁 PHP Dosya Yöneticisi

📝 index.php

📝 index.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)