index.php tamamı bu
@pekmezcimuzo;
@TheKhan;
<?php
include 'sy-admin/connect/db.php';
// GENEL AYAR SORGULARI
$genelayarsorgu=$db->prepare("SELECT * FROM genelayarlar where sy_id=:id");$genelayarsorgu->execute(array( 'id' => 0 ));$genelayarcekme=$genelayarsorgu->fetch(PDO::FETCH_ASSOC);
// İLETİSİM SORGUSU
$iletisimayarsorgu=$db->prepare("SELECT * FROM iletisim where iletisim_id=:id");$iletisimayarsorgu->execute(array( 'id' => 0 ));$iletisimayarcekme=$iletisimayarsorgu->fetch(PDO::FETCH_ASSOC);
// FOOTER SORGUSU
$footerayarsorgu=$db->prepare("SELECT * FROM footer where footer_id=:id");$footerayarsorgu->execute(array( 'id' => 0 ));$footerayarcekme=$footerayarsorgu->fetch(PDO::FETCH_ASSOC);
// SOSYAL MEDYA SORGUSU
$smsorgu=$db->prepare("SELECT * FROM sosyalmedya where sosyalmedya_id=:id");$smsorgu->execute(array( 'id' => 0 ));$smcek=$smsorgu->fetch(PDO::FETCH_ASSOC);
// HAKKIMIZDA SAYFASI SORGUSU
$hakkimizdasorgu=$db->prepare("SELECT * FROM sayfa_hakkimizda where hakkimizda_id=:id");$hakkimizdasorgu->execute(array( 'id' => 0 ));$hakkimizdacek=$hakkimizdasorgu->fetch(PDO::FETCH_ASSOC);
// SAYAÇ SAYFASI SORGUSU
$sayacsorgu=$db->prepare("SELECT * FROM sayfa_sayac where sayac_id=:id");$sayacsorgu->execute(array( 'id' => 0 ));$sayaccek=$sayacsorgu->fetch(PDO::FETCH_ASSOC);
// MÜŞTERİ SAYFASI SORGUSU
$musterisorgu=$db->prepare("SELECT * FROM sayfa_musteriler where musteri_id=:id");$musterisorgu->execute(array( 'id' => 0 ));$mustericek=$musterisorgu->fetch(PDO::FETCH_ASSOC);
// SERVİS SAYFASI SORGUSU
$servissorgu=$db->prepare("SELECT * FROM sayfa_servis where servis_id=:id");$servissorgu->execute(array( 'id' => 0 ));$serviscek=$servissorgu->fetch(PDO::FETCH_ASSOC);
// REFERANS SAYFASI SORGUSU
$referanssor=$db->prepare("SELECT * FROM sayfa_referans where referans_id=:id");$referanssor->execute(array( 'id' => 0 ));$referanscek=$referanssor->fetch(PDO::FETCH_ASSOC);
?><!DOCTYPE html><html lang="en">
<head> <meta charset="utf-8"> <meta content="width=device-width, initial-scale=1.0" name="viewport">
<title><?php echo $genelayarcekme['sy_title']; ?></title> <meta content="" name="description"> <meta content="" name="keywords">
<!-- Favicons --> <link href="assets/img/favicon.png" rel="icon"> <link href="assets/img/apple-touch-icon.png" rel="apple-touch-icon">
<!-- Google Fonts --> <link href="https://fonts.googleapis.com/css?family=Open+Sans:300,300i,400,400i,600,600i,700,700i|Roboto:300,300i,400,400i,500,500i,600,600i,700,700i|Poppins:300,300i,400,400i,500,500i,600,600i,700,700i" rel="stylesheet">
<!-- Vendor CSS Files --> <link href="assets/vendor/bootstrap/css/bootstrap.min.css" rel="stylesheet"> <link href="assets/vendor/icofont/icofont.min.css" rel="stylesheet"> <link href="assets/vendor/boxicons/css/boxicons.min.css" rel="stylesheet"> <link href="assets/vendor/owl.carousel/assets/owl.carousel.min.css" rel="stylesheet"> <link href="assets/vendor/venobox/venobox.css" rel="stylesheet"> <link href="assets/vendor/aos/aos.css" rel="stylesheet">
<!-- Tema CSS Dosyaları --> <link href="assets/css/style.css" rel="stylesheet">
</head>
<body>
<!-- ======= Top Bar ======= --> <div id="topbar" class="d-none d-lg-flex align-items-center fixed-top"> <div class="container d-flex"> <div class="contact-info mr-auto"> <i class="icofont-envelope"></i> <a href="<?php echo $iletisimayarcekme['sy_mail']; ?>"><?php echo $iletisimayarcekme['sy_mail']; ?></a> <i class="icofont-phone"></i> <?php echo $iletisimayarcekme['sy_tel']; ?> </div> <div class="social-links"> <a href="<?php echo $smcek['sy_twitter']; ?>" class="twitter"><i class="icofont-twitter"></i></a> <a href="<?php echo $smcek['sy_facebook']; ?>" class="facebook"><i class="icofont-facebook"></i></a> <a href="<?php echo $smcek['sy_instagram']; ?>" class="instagram"><i class="icofont-instagram"></i></a> <a href="#" class="skype"><i class="icofont-skype"></i></a> <a href="#" class="linkedin"><i class="icofont-linkedin"></i></i></a> </div> </div> </div>
<!-- ======= Header ======= --> <?php include 'header.php'; ?> <!-- End Header -->
<!-- ======= Hero Section ======= --> <section id="hero" class="d-flex align-items-center"> <div class="container" data-aos="zoom-out" data-aos-delay="100"> <h1><?php echo $genelayarcekme['sy_baslik']; ?><span> <?php echo $genelayarcekme['sy_baslikmavi']; ?></spa> </h1> <h2><?php echo $genelayarcekme['sy_slogan']; ?></h2> <div class="d-flex"> <a href="#about" class="btn-get-started scrollto"><?php echo $genelayarcekme['sy_btn_yazi']; ?></a> <a href="https://www.youtube.com/watch?v=jDDaplaOz7Q" class="venobox btn-watch-video" data-vbtype="video" data-autoplay="true"> <?php echo $genelayarcekme['sy_video_izle']; ?> <i class="icofont-play-alt-2"></i></a> </div> </div> </section><!-- End Hero -->
<main id="main">
<!-- ======= Featured Services Section ======= --> <?php include 'sayfalar/hizmetler.php'; ?> <!-- End Featured Services Section -->
<?php include 'sayfalar/hakkimizda.php' ?>
<!-- ======= Counts Section ======= --> <?php include 'sayfalar/sayac.php'; ?> <!-- End Counts Section -->
<!-- ======= Clients Section ======= --> <?php include 'sayfalar/musteriler.php'; ?> <!-- End Clients Section -->
<!-- ======= Services Section ======= --> <?php include 'sayfalar/servisler.php'; ?> <!-- End Services Section -->
<!-- ======= Testimonials Section ======= --> <?php include 'sayfalar/gorusler.php'; ?> <!-- End Testimonials Section -->
<!-- ======= Portfolio Section ======= --> <?php include 'sayfalar/portfoy.php'; ?> <!-- End Portfolio Section -->
<!-- ======= Team Section ======= --> <?php include 'sayfalar/ekip.php'; ?> <!-- End Team Section -->
<!-- ======= Pricing Section ======= --> <?php include 'sayfalar/fiyat.php'; ?> <!-- End Pricing Section -->
<!-- ======= Frequently Asked Questions Section ======= --> <?php include 'sayfalar/sss.php'; ?> <!-- End Frequently Asked Questions Section -->
<!-- ======= Contact Section ======= --> <?php include 'sayfalar/iletisim.php'; ?> <!-- End Contact Section -->
</main><!-- End #main -->
<!-- ======= Footer ======= --> <?php include 'footer.php'; ?> <!-- End Footer -->
<div id="preloader"></div> <a href="#" class="back-to-top"><i class="icofont-simple-up"></i></a>
<!-- Vendor JS Files --> <script src="assets/vendor/jquery/jquery.min.js"></script> <script src="assets/vendor/bootstrap/js/bootstrap.bundle.min.js"></script> <script src="assets/vendor/jquery.easing/jquery.easing.min.js"></script> <script src="assets/vendor/php-email-form/validate.js"></script> <script src="assets/vendor/waypoints/jquery.waypoints.min.js"></script> <script src="assets/vendor/counterup/counterup.min.js"></script> <script src="assets/vendor/owl.carousel/owl.carousel.min.js"></script> <script src="assets/vendor/isotope-layout/isotope.pkgd.min.js"></script> <script src="assets/vendor/venobox/venobox.min.js"></script> <script src="assets/vendor/aos/aos.js"></script>
<!-- Template Main JS File --> <script src="assets/js/main.js"></script>
</body>
</html> 
