PHP Dosya Yöneticisi

<?php
include("admin/include/baglan.php");
include("admin/include/fonksiyonlar.php");
?>
<!DOCTYPE html>
<html lang="tr">

<section class="bg-light">
        <div class="container">
            <div class="row">
                <div class="col-md-12">
                    <div class="wrapp__list__article-responsive wrapp__list__article-responsive-carousel">
                    <?php
                    $urun1cek=$db->query("select * from urunler where durum='on' order by id desc limit 5");
					foreach($urun1cek as $urun1){
					?>
                        <div class="item">
                      
<div class="card__post card__post-list">
    <div class="image-sm">
        <a href="<?=$urun1['seo']?>">
            <img src="admin/resimler/<?=$urun1['resim']?>" class="img-fluid" alt="<?=$urun1['adi']?>">
        </a>
    </div>

</ul>
            </div>
            <div class="card__post__title">
                <h6>
                    <a href="<?=$urun1['seo']?>">
                       <?=$urun1['adi']?>
                    </a>
                </h6>

</div>

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

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

<section>
     
        <div class="popular__news-header">
            <div class="container">
                <div class="row no-gutters">
                    <div class="col-md-8 ">
                        <div class="card__post-carousel">
                        <?php
                        $urun2cek=$db->query("select * from urunler where durum='on' order by id desc limit 10")->fetchAll(PDO::FETCH_ASSOC);
						foreach($urun2cek as $urun2){
							$k2id = $urun2['kategori'];
							$kategori2=$db->query("select * from urun_kategori where id='$k2id'")->fetch(PDO::FETCH_ASSOC);
						?>
                            <div class="item">
                          
<div class="card__post">
    <div class="card__post__body">
        <a href="<?=$urun2['seo']?>">
            <img src="admin/resimler/<?=$urun2['resim']?>" class="img-fluid" alt="<?=$urun2['adi']?>">
        </a>
        <div class="card__post__content bg__post-cover">
            <div class="card__post__category">
               <?=$kategori2['adi']?>
            </div>
            <div class="card__post__title">
                <h2>
                    <a href="<?=$urun2['seo']?>">
                      <?=$urun2['adi']?>
                    </a>
                </h2>
            </div>
            <div class="card__post__author-info">
                <ul class="list-inline">
                    <li class="list-inline-item">
                        <a href="<?=$urun2['seo']?>">
                          <?=$ayar['site_title']?>
                        </a>
                    </li>
                    <li class="list-inline-item">
                        <span>
                          <?=$urun2['eklenme_tarihi']?>
                        </span>
                    </li>
                </ul>
            </div>
        </div>
    </div>

</div>
                            </div>
                          <?php }?>  
                        </div>
                    </div>
                    <div class="col-md-4">
                        <div class="popular__news-right">
          <?php
          $urun3cek=$db->query("select * from urunler where durum='on' order by id desc limit 2")->fetchAll(PDO::FETCH_ASSOC);
		  foreach($urun3cek as $urun3){
			  $k3id =$urun3['kategori'];
			  $kategori3=$db->query("select * from urun_kategori where id='$k3id'")->fetch(PDO::FETCH_ASSOC);
		  ?>                
<div class="card__post ">
    <div class="card__post__body card__post__transition">
        <a href="<?=$urun3['seo']?>">
            <img src="admin/resimler/<?=$urun3['resim']?>" class="img-fluid" alt="<?=$urun3['adi']?>">
        </a>
        <div class="card__post__content bg__post-cover">
            <div class="card__post__category">
                <?=$kategori3['adi']?>
            </div>
            <div class="card__post__title">
                <h5>
                    <a href="<?=$urun3['seo']?>">
                       <?=$urun3['adi']?></a>
                </h5>
            </div>
            <div class="card__post__author-info">
                <ul class="list-inline">
                    <li class="list-inline-item">
                        <a href="<?=$urun3['seo']?>">
                            <?=$ayar['site_title']?>
                        </a>
                    </li>
                    <li class="list-inline-item">
                        <span>
                           <?=$urun3['eklenme_tarihi']?>
                        </span>
                    </li>
                </ul>
            </div>
        </div>
    </div>

</div>
<?php }?>
                        </div>
                    </div>
                </div>
            </div>
        </div>
      
        <div class="popular__news-header-carousel">
            <div class="container">
                <div class="row">
                    <div class="col-lg-12">
                        <div class="top__news__slider">
                        <?php
                        $urun4cek=$db->query("select * from urunler where durum='on' order by id asc limit 10")->fetchAll(PDO::FETCH_ASSOC);
						foreach($urun4cek as $urun4){
						?>
                            <div class="item">
                              
<div class="article__entry">
    <div class="article__image">
        <a href="<?=$urun4['seo']?>">
            <img src="admin/resimler/<?=$urun4['resim']?>" alt="<?=$urun4['adi']?>" class="img-fluid">
        </a>
    </div>
    <div class="article__content">
        <ul class="list-inline">
            <li class="list-inline-item">
                <span class="text-primary">
                <?=$ayar['site_title']?>
                </span>,
            </li>

</div>
                </div>
            </div>
        </div>
    </section>
 
    <section class="pt-0">
        <div class="popular__section-news">
            <div class="container">
                <div class="row">
                    <div class="col-md-12 col-lg-8">
                        <div class="wrapper__list__article">
                            <h4 class="border_section">Genel </h4>
                        </div>
                      
                        <div class="row ">
                        
                        <?php
                        $genelcek=$db->query("select * from urunler where durum='on' order by rand() limit 6")->fetchAll(PDO::FETCH_ASSOC);
						foreach($genelcek as $genel){
						?>
                            <div class="col-sm-12 col-md-6">
                                <div class="wrapp__list__article-responsive">
                                    <div class="mb-3">
<div class="card__post card__post-list">
    <div class="image-sm">
        <a href="<?=$genel['seo']?>">
            <img src="admin/resimler/<?=$genel['resim']?>" class="img-fluid" alt="<?=$genel['adi']?>">
        </a>
    </div>

</ul>
            </div>
            <div class="card__post__title">
                <h6>
                    <a href="<?=$genel['seo']?>">
                      <?=$genel['adi']?>
                    </a>
                </h6>

</div>

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

<div class="col-md-12 col-lg-4">
                        <aside class="wrapper__list__article">
                            <h4 class="border_section">Popüler Yazılar </h4>
                            <div class="wrapper__list-number">

<?php
                       $popcek=$db->query("select  * from urunler where durum='on' order by hit desc limit 5")->fetchAll(PDO::FETCH_ASSOC);
					   foreach($popcek as $pop){
						   $popid=$pop['kategori'];
						   $popkat=$db->query("select * from urun_kategori where id='$popid'")->fetch(PDO::FETCH_ASSOC);
					   ?>
<div class="card__post__list">
    <div class="list-number">
        <span>
            <?=$pop['sira']?>
        </span>
    </div>
    <a href="<?=$popkat['seo']?>" class="category">
        <?=$popkat['adi']?>
    </a>
    <ul class="list-inline">
        <li class="list-inline-item">

</a>
            </h5>
        </li>
    </ul>

</div>
<?php }?>

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

<div class="container">
        <?php
        $randomkat=$db->query("select * from urun_kategori where durum='on' order by rand() limit 1")->fetch(PDO::FETCH_ASSOC);
		?>
            <div class="row">
                <div class="col-md-12">
                    <aside class="wrapper__list__article">
                        <h4 class="border_section"><?=$randomkat['adi']?></h4>
                    </aside>
                </div>
                <div class="col-md-12">

<div class="article__entry-carousel">
                    
                    <?php
                    $randomid=$randomkat['id'];
					
					$randomuruncek=$db->query("select * from urunler where durum='on' and kategori='$randomid'")->fetchAll(PDO::FETCH_ASSOC);
					foreach($randomuruncek as $randomurun){
					?>
                        <div class="item">
                         
<div class="article__entry">
    <div class="article__image">
        <a href="<?=$randomurun['seo']?>">
            <img src="admin/resimler/<?=$randomurun['resim']?>" alt="<?=$randomurun['adi']?>" class="img-fluid">
        </a>
    </div>
    <div class="article__content">
        <ul class="list-inline">
            <li class="list-inline-item">
                <span class="text-primary">
                    <?=$ayar['site_title']?>
                </span>
            </li>
            <li class="list-inline-item">
                <span>
                   <?=$randomurun['eklenme_tarihi']?>
                </span>
            </li>

</ul>
        <h5>
            <a href="<?=$randomurun['seo']?>">
               <?=$randomurun['adi']?>
            </a>
        </h5>

</div>
</div>
                        </div>
                        
                      <?php }?>  
                        
                        
                    </div>
                </div>
            </div>
        </div>
  <?php
  $random2=$db->query("select * from urun_kategori where durum='on' and not id='$randomid' order by rand() limit 1")->fetch(PDO::FETCH_ASSOC);
  ?>
        <div class="mt-4">
            <div class="container">
                <div class="row">
                    <div class="col-md-8">
                        <aside class="wrapper__list__article mb-0">
                            <h4 class="border_section"><?=$random2['adi']?></h4>
                            <div class="row">
                            <?php
                            $random2id=$random2['id'];
							$random2cek=$db->query("select * from urunler where kategori='$random2id'")->fetchAll(PDO::FETCH_ASSOC);
							foreach($random2cek as $random2goster){
							?>
                                <div class="col-md-6">
                                    <div class="mb-4">
                                  
<div class="article__entry">
    <div class="article__image">
        <a href="<?=$random2goster['seo']?>">
            <img src="admin/resimler/<?=$random2goster['resim']?>" alt="<?=$random2goster['adi']?>" class="img-fluid">
        </a>
    </div>
    <div class="article__content">
        <ul class="list-inline">
            <li class="list-inline-item">
                <span class="text-primary">
                   <?=$ayar['site_title']?>
                </span>
            </li>
            <li class="list-inline-item">
                <span>
                    <?=$random2goster['eklenme_tarihi']?>
                </span>
            </li>

</ul>
        <h5>
            <a href="<?=$random2goster['seo']?>">
               <?=$random2goster['adi']?>
            </a>
        </h5>

</div>
</div>
                                    </div>
                                    
                                    
                                </div>
                              <?php }?>  
                            </div>
                        </aside>
                        <aside class="wrapper__list__article">
                            <h4 class="border_section">Son Eklenen Yazılar</h4>

<div class="wrapp__list__article-responsive">
                               <?php
            $limit = 5;

$query = $db->prepare("SELECT * FROM urunler where durum='0' ");
$query->execute();

$total_results = $query->rowCount();
$total_pages = ceil($total_results / $limit);

if (isset($_GET["page"])) {
    $page = $_GET["page"];
} else {
    $page = 1;
}

$starting_limit = (($page - 1) * $limit);
$sec=$db->query("SELECT * FROM urunler where durum='on' ORDER BY id DESC LIMIT $starting_limit,$limit",PDO::FETCH_ASSOC);
if($sec->rowCount()){foreach($sec as $sonuc){
	$sid=$sonuc['kategori'];
	
	$kategorisec=$db->query("select * from urun_kategori where id='$sid'")->fetch(PDO::FETCH_ASSOC);
			?>

<div class="card__post card__post-list card__post__transition mt-30">
    <div class="row ">
        <div class="col-md-5">
            <div class="card__post__transition">
                <a href="<?=$sonuc['seo']?>">
                    <img src="admin/resimler/<?=$sonuc['resim']?>" class="img-fluid w-100" alt="<?=$sonuc['adi']?>">
                </a>
            </div>
        </div>
        <div class="col-md-7 my-auto pl-0">
            <div class="card__post__body ">
                <div class="card__post__content  ">
                    <div class="card__post__category ">
                        <?=$kategorisec['adi']?>
                    </div>
                    <div class="card__post__author-info mb-2">
                        <ul class="list-inline">
                            <li class="list-inline-item">
                                <span class="text-primary">
                                   <?=$ayar['site_title']?>
                                </span>
                            </li>
                            <li class="list-inline-item">
                                <span class="text-dark text-capitalize">
                                 <?=$sonuc['eklenme_tarihi']?>
                                </span>
                            </li>

</ul>
                    </div>
                    <div class="card__post__title">
                        <h5>
                            <a href="<?=$sonuc['seo']?>">
                              <?=$sonuc['adi']?>
                            </a>
                        </h5>
                        <p class="d-none d-lg-block d-xl-block mb-0">
                         <?=$sonuc['onaciklama']?>
                        </p>

</div>

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

</div>
</div>
<?php } }?>
                            </div>
                        </aside>
                    </div>

<div class="col-md-4">
                        <div class="sticky-top">
                            <aside class="wrapper__list__article">
                                <h4 class="border_section">
                                    Karışık Yazılar </h4>
                                <div class="wrapper__list__article-small">
<?php
$karisikcek=$db->query("select * from urunler where durum='on' order by rand() limit 4")->fetchAll(PDO::FETCH_ASSOC);
foreach($karisikcek as $karisik){
?>
                                    
                                    <div class="mb-3">
                              
<div class="card__post card__post-list">
    <div class="image-sm">
        <a href="<?=$karisik['seo']?>">
            <img src="admin/resimler/<?=$karisik['resim']?>" class="img-fluid" alt="<?=$karisik['adi']?>">
        </a>
    </div>

</ul>
            </div>
            <div class="card__post__title">
                <h6>
                    <a href="<?=$karisik['seo']?>">
                      <?=$karisik['adi']?>
                    </a>
                </h6>

</div>

</div>
</div>
                                    </div>
  <?php }?>
                                </div>
                            </aside>

<aside class="wrapper__list__article">
                                <h4 class="border_section">Sosyal Medya </h4>
                               
<div class="wrap__social__media">
    <a href="<?=$sosyal['facebook']?>" target="_blank">
        <div class="social__media__widget facebook">
            <span class="social__media__widget-icon">
                <i class="fa fa-facebook"></i>
            </span>
            <span class="social__media__widget-counter">
             
             
            </span>
            <span class="social__media__widget-name">
                Beğen
            </span>
        </div>
    </a>
    <a href="<?=$sosyal['twitter']?>" target="_blank">
        <div class="social__media__widget twitter">
            <span class="social__media__widget-icon">
                <i class="fa fa-twitter"></i>
            </span>
            <span class="social__media__widget-counter">
             
            </span>
            <span class="social__media__widget-name">
                Takip Et
            </span>
        </div>
    </a>
    <a href="<?=$sosyal['youtube']?>" target="_blank">
        <div class="social__media__widget youtube">
            <span class="social__media__widget-icon">
                <i class="fa fa-youtube"></i>
            </span>
            <span class="social__media__widget-counter">
                
            </span>
            <span class="social__media__widget-name">
                Abone Ol
            </span>
        </div>
    </a>

</div>
                            </aside>

<aside class="wrapper__list__article">
                                <h4 class="border_section">Etiketler</h4>
                                <div class="blog-tags p-0">
    <ul class="list-inline">
<?php
$etiketcek=$db->query("select * from urunler where durum='on' order by sira asc")->fetchAll(PDO::FETCH_ASSOC);
foreach($etiketcek as $etiket){
?>
        <li class="list-inline-item">
            <a href="#">
                #<?=$etiket['etiket']?>
            </a>
        </li>
       <?php }?>

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

<aside class="wrapper__list__article">
                                <h4 class="border_section">Reklam</h4>
                               <?=$iletisim['yanreklam']?>
                            </aside>

<aside class="wrapper__list__article">
                            <h4 class="border_section">Abone Ol</h4>
                      
<div class="widget__form-subscribe bg__card-shadow">
    <h6>
        Bildirim Almak İçin Abone Olabilirsiniz.
    </h6>
    <p><small>Sadece Email Adresiniz Yeterlidir.</small></p>
    <div class="input-group ">
        <?php
        if($_POST['aboneol']){
            
            $aboneol=$db->prepare("insert into aboneol set email=:email,ip=:ip,tarih=:tarih");
            $hemen=$aboneol->execute(array("email"=>$_POST['email'],"ip"=>$ip,"tarih"=>$tarih));
            if($hemen){
                echo "abone olundu";
            }
        }
        ?>
        <form method="post">
        <input type="text" class="form-control" name="email" placeholder="Email ">
        <div class="input-group-append">
            <input type="submit" class="btn btn-primary" name="aboneol" value="Abone Ol">
        </div>
        
        </form>
    </div>
</div>
                        </aside>
                        </div>
                    </div>
                    <div class="mx-auto">
              
<div class="pagination-area">
    <div class="pagination wow fadeIn animated" data-wow-duration="2s" data-wow-delay="0.5s"
        style="visibility: visible; animation-duration: 2s; animation-delay: 0.5s; animation-name: fadeIn;">
        <?php
            $url=$_GET['page'];
            ?>  <?php for ($i = 1; $i <= $total_pages; $i++): ?>
        <a <?php if($url==$i){?> class="active" <?php }?> href="?page=<?= $i ?>">
            <?= $i ?>
        </a>
      <?php endfor; ?>
    </div>
</div>
                    </div>

</html>

İptal

📁 PHP Dosya Yöneticisi

📝 index.php

📝 index.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)