PHP Dosya Yöneticisi

<div class="container-fluid bg-3 pt-15 pb-15">
  <div class="row">
    <div class="container">
      <?php
      $query = $db->query("SELECT * FROM hikaye ORDER BY id DESC", PDO::FETCH_ASSOC);
      if($query->rowCount()){
      ?>
      <div class="row">
        <div class="col-md-12">
          <div id="hikaye" class="owl-carousel">
            <?php
                  foreach($query as $row){
                    echo '<div class="item"><a href="javascript:void(0)" data-buyuk-img="'.$row['buyuk_img'].'" data-link="'.$row['link'].'"><img src="upload/'.$row['kucuk_img'].'"><span>'.$row['baslik'].'</span></a></div>';
                  }
              ?>
          </div>
        </div>
      </div>
      <?php } ?>
      <div class="row mt-20">
        <div class="col-md-9">
          <div id="sync1" class="anaslider owl-carousel bg-2">
            <?php
              $query = $db->query("SELECT * FROM slider ORDER BY sira ASC", PDO::FETCH_ASSOC);
              if($query->rowCount()){
                foreach($query as $row){
            ?>
              <div class="item"><a href="<?php echo $row['link']; ?>"><img src="upload/<?php echo $row['img']; ?>" class="img-responsive"></a></div>
            <?php } } ?>
          </div>
        </div>
        <div class="col-md-3">
          <div class="haftanin_urunleri_baslik bg-2">Haftanın Ürünleri</div>
          <div id="haftanin_urunleri" class="owl-carousel">
            <?php
              $query = $db->query("
              SELECT
              haftanin_urunleri.urun_id,
              urun.id,
              urun.baslik,
              urun.sef,
              urun.eski_fiyat,
              urun.fiyat,
              urun_img.img
              FROM
              haftanin_urunleri
              INNER JOIN urun ON haftanin_urunleri.urun_id = urun.id
              INNER JOIN urun_img ON urun.id = urun_img.urun_id
              GROUP BY urun_img.urun_id
              ORDER BY haftanin_urunleri.sira ASC
              ", PDO::FETCH_ASSOC);
              if($query->rowCount()){
                foreach($query as $row){
            ?>
              <div class="item">
                <div class="urun">
                  <div class="kontrol">
                    <span data-toggle="tooltip" data-placement="bottom" title="Sepete Ekle"><a href="urun/<?php echo $row['sef']; ?>" title="<?php echo $row['baslik']; ?>"><i class="las la-shopping-cart"></i></a></span>
                    <span data-toggle="tooltip" data-placement="bottom" title="Favorilerime Ekle" data-favori-ekle="<?php echo $row['id']; ?>"><i class="las la-heart"></i></span>
                  </div>
                  <a href="urun/<?php echo $row['sef']; ?>" title="<?php echo $row['baslik']; ?>"><img src="upload/<?php echo $row['img']; ?>" alt="<?php echo $row['baslik']; ?>" title="<?php echo $row['baslik']; ?>"></a>
                  <a href="urun/<?php echo $row['sef']; ?>" title="<?php echo $row['baslik']; ?>" class="link"><?php echo $row['baslik']; ?></a>
                  <div class="fiyat">
                    <?php if(!empty($row['eski_fiyat'])){ ?>
                      <div class="eski">
                        <span><?php echo fiyat($row['eski_fiyat']); ?> TL</span>
                        <span>%<?php echo ceil((($row['eski_fiyat'] - $row['fiyat']) / $row['eski_fiyat']) * 100);  ?></span>
                      </div>
                    <?php } ?>
                      <span class="guncel"><?php echo fiyat($row['fiyat']); ?> TL</span>
                  </div>
                </div>
              </div>
            <?php } } ?>
          </div>
        </div>
      </div>
      <div class="row mt-20 mb-20">
        <div class="col-md-12">
          <div class="ticaret-kutu-dis">
            <div class="ticaret-kutu">
              <div><i class="las la-truck"></i></div>
              <div>
                <span>Hızlı Kargo</span>
                <b>Siparişinizin Ardından Anında Kargo</b>
              </div>
            </div>
            <div class="ticaret-kutu">
              <div><i class="las la-life-ring"></i></div>
              <div>
                <span>Canlı Destek</span>
                <b>%100 Müşteri Memnuniyeti</b>
              </div>
            </div>
            <div class="ticaret-kutu">
              <div><i class="las la-lock"></i></div>
              <div>
                <span>Güvenli Ödeme</span>
                <b>256 Bit SSL Şifreleme</b>
              </div>
            </div>
            <div class="ticaret-kutu">
              <div><i class="las la-recycle"></i></div>
              <div>
                <span>Ücretsiz İade</span>
                <b>Anında Ücretsiz İade</b>
              </div>
            </div>
          </div>
        </div>
      </div>
    </div>
  </div>
</div>

<div class="container-fluid bg-5">
  <div class="row">
    <div class="container">
      <div class="row mt-20 mb-20 kampanyalar">
        <?php
          $query = $db->query("SELECT * FROM kampanya WHERE alt_ust = 0 ORDER BY sira ASC", PDO::FETCH_ASSOC);
          if($query->rowCount()){
            foreach($query as $row){
              echo '<div class="col-md-3 col-xs-6 mb-10"><a href="'.$row['link'].'"><img class="img-responsive" alt="" src="upload/'.$row['img'].'"></a></div>';
            }
          }
        ?>
      </div>

<?php
      $query = $db->query("SELECT * FROM vitrin ORDER BY sira ASC", PDO::FETCH_ASSOC);
      if($query->rowCount()){
        foreach($query as $row1){
      ?>
      <div class="row mb-20">
        <div class="col-md-12">
          <div class="vitrin_baslik"><span class="bg-4"><?php echo $row1['baslik']; ?></span></div>
        </div>
        <?php if(!empty($row1['img'])){ ?>
        <div class="col-md-3 kampanyalar">
          <a href="<?php echo $row1['link']; ?>"><img src="upload/<?php echo $row1['img']; ?>" class="img-responsive"></a>
        </div>
        <?php } ?>
        <div class="col-md-<?php if(!empty($row1['img'])){ echo '9'; }else{ echo '12'; } ?>">
          <div class="vitrin<?php if(!empty($row1['img'])){ echo '2'; }else{ echo '1'; } ?> owl-carousel">
            <?php 
              $query = $db->query("SELECT
              urun.id,
              urun.baslik,
              urun.sef,
              urun.eski_fiyat,
              urun.fiyat,
              urun_img.img
              FROM
              vitrin_urun
              INNER JOIN urun ON vitrin_urun.urun_id = urun.id
              INNER JOIN urun_img ON urun.id = urun_img.urun_id 
              WHERE
              vitrin_urun.vitrin_id = '{$row1['id']}'
              GROUP BY
              urun_img.urun_id
              ORDER BY
              vitrin_urun.sira ASC
                  ", PDO::FETCH_ASSOC);
              if($query->rowCount()){
                foreach($query as $row){
              ?>
              <div class="item">
                <div class="urun">
                  <div class="kontrol">
                    <span data-toggle="tooltip" data-placement="bottom" title="Sepete Ekle"><a href="urun/<?php echo $row['sef']; ?>" title="<?php echo $row['baslik']; ?>"><i class="las la-shopping-cart"></i></a></span>
                    <span data-toggle="tooltip" data-placement="bottom" title="Favorilerime Ekle" data-favori-ekle="<?php echo $row['id']; ?>"><i class="las la-heart"></i></span>
                  </div>
                  <a href="urun/<?php echo $row['sef']; ?>" title="<?php echo $row['baslik']; ?>"><img src="upload/<?php echo $row['img']; ?>" alt="<?php echo $row['baslik']; ?>" title="<?php echo $row['baslik']; ?>"></a>
                  <a href="urun/<?php echo $row['sef']; ?>" title="<?php echo $row['baslik']; ?>" class="link"><?php echo $row['baslik']; ?></a>
                  <div class="fiyat">
                    <?php if(!empty($row['eski_fiyat'])){ ?>
                      <div class="eski">
                        <span><?php echo fiyat($row['eski_fiyat']); ?> TL</span>
                        <span>%<?php echo ceil((($row['eski_fiyat'] - $row['fiyat']) / $row['eski_fiyat']) * 100);  ?></span>
                      </div>
                    <?php } ?>
                      <span class="guncel"><?php echo fiyat($row['fiyat']); ?> TL</span>
                  </div>
                </div>
              </div>
            <?php } } ?>
          </div>
        </div>
      </div>
      <?php
        }
      }
      ?>

<?php
        $query = $db->query("SELECT * FROM kampanya WHERE alt_ust = 1 ORDER BY sira ASC", PDO::FETCH_ASSOC);
        if($query->rowCount()){
          echo '<div class="row mt-20 mb-20 kampanyalar">
                  <div class="col-md-12">
                    <div class="vitrin_baslik"><span class="bg-4">Fırsat Ürünleri</span></div>
                  </div>';
          foreach($query as $row){
            echo '<div class="col-md-4 col-xs-6 mb-20"><a href="'.$row['link'].'"><img class="img-responsive no-border" alt="" src="upload/'.$row['img'].'"></a></div>';
          }
          echo '</div>';
        }
      ?>

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

İptal

📁 PHP Dosya Yöneticisi

📝 anasayfa.php

📝 anasayfa.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)