Tekil Mesaj gösterimi - PHP while döngüsü

Konu PHP while döngüsü
16-12-2020, 16:28:54
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>&nbsp;<?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>