PHP Dosya Yöneticisi

<?php if(!defined("Hacking")){die("404 Not Found"); }
$cat = '';
$categorys =$Modul->getCategory(5);
if(isset($_GET['category']) && !empty($_GET['category']) && $_GET['category']!='Tümü'){
    $cat = $_GET['category'];
}
$catID =0;
if (isset($_GET['catid'])){
    $catID = $_GET['catid'];
}
?>
<form action="" method="get" class="hidden">
    <input type="text" name="do" value="referans">
    <input type="text" name="category" id="categoryName">
    <input type="text" name="catid" id="categoryId">
    <input type="submit" id="sorgula">
</form>

<div id="tour-11" class="header-content">
  <h2><i class="fa fa-camera"></i>Referans Listesi</h2>
</div>
<div class="body-content animated fadeIn">
  <div class="panel rounded shadow">
    <div class="panel-body"><div class="row">
            <div class="col-md-2 text-left">
                <button class="btn btn-danger" onclick="topluSilme('galeri', 'Galeriden');">Sil</button>
            </div>
            <div class="col-md-10">
                <div class="pull-right">
                    <div class="btn-group">
                        <button type="button" class="btn btn-default dropdown-toggle" data-toggle="dropdown" id="catSelectText"><?php if($cat!=''){print $cat;} else { print 'Kategori Seç';} ?><span class="caret"></span>
                        </button>
                        <ul class="dropdown-menu selectCategory" role="menu" >
                            <li class="" data="0"><a href="#">Tümü</a></li>
                            <?php
                            foreach ($categorys as $category) {
                                ?>
                                <li data="<?=$category['sayfa_id']?>" class="<?php if($category['sayfa_id']==$catID){print 'active';}?>"><a href="#"><?=$category['sayfa_baslik']?></a></li>
                                <?php
                            }
                            ?>
                        </ul>
                    </div>
                </div>
            </div>
        </div>
        <table id="table" class="table" data-pagination="true"
               data-search="true"
               data-pagination-v-align="bottom"
               data-click-to-select="true"
               data-toggle="table"
               data-page-list="[10, 25, 50, 100, 150, 200]">
        <thead>
          <tr>
              <th data-checkbox="true"></th>
              <th data-visible="false">id</th>
            <th data-class="expand" class="text-center">Resim</th>
            <th data-hide="phone">Başlık</th>
            <th data-hide="phone">URL</th>
            <th width="15%"> Kategori</th>
            <th>Gizle/Göster</th>
            <th>Sıralama</th>
            <th data-hide="phone,tablet" style="min-width: 200px" class="text-center">İşlem</th>

</tr>
        </thead>
        <tbody>
          <?php
          $cats = $Sayfa->getKategori(5);
          if(@$_GET["islev"] != ""){
              $db->query("UPDATE referans SET sira='0' WHERE id='".$_GET["id"]."'");
              if($_GET["islev"] == "asagi"){
               $yeni_sira = $_GET["sira"] + 1;
              }elseif($_GET["islev"] == "yukari"){
                $yeni_sira = $_GET["sira"] - 1;
              }
              $db->query("UPDATE referans SET sira='".$_GET["sira"]."' WHERE sira='".$yeni_sira."'");
              $db->query("UPDATE referans SET sira='".$yeni_sira."' WHERE sira='0'");
          }
        $referans = $db->select('referans')
            ->orderby('sira','DESC')
            ->run();

if (isset($catID) && $catID !=0 ){
              $datam  =[];
              foreach ($referans as $ref) {
                  $bol = explode(' ', $ref['kategori']);
                  foreach ($bol as $item) {
                      if ($catID ==0 || $item == $catID){
                          array_push($datam,$ref);
                      }
                  }
              }
              $referans = $datam;
          }

//$referans =  $Modul->sayfalamastart($kayitsayisi,'referans');
/*          $referans = $db->select('referans')
              ->join('sayfalar', 'referans.kategori LIKE CONCAT("%", sayfalar.sayfa_id, "%")','left');
          if (!empty($cat)){
              $referans = $db->where('sayfa_baslik', $cat);
          }
          $referans = $db->run();*/
          /*$sql = $db->query("SELECT * FROM `referans` LEFT JOIN
sayfalar on referans.kategori LIKE CONCAT('%', sayfalar.sayfa_id,'%') WHERE sayfalar.sayfa_baslik = 'referans1'",  PDO::FETCH_ASSOC);
          $sql->execute([]);
          $referans=$sql->fetchAll(PDO::FETCH_ASSOC);*/

foreach ($referans as $key => $referansRow){
                ?>
          <tr>
              <td></td>
              <td><?=$referansRow['id']?></td>
            <td class="text-center" style="width: 5%"><img src="../upload/<?php echo $referansRow['referansResim']; ?>" style="width:100px;height:100px;" class="mt-5 mb-5"/></td>
            <td><?php echo $referansRow['referansBaslik']; ?></td>
            <td><?php echo $referansRow['referansURL']; ?> &nbsp; &nbsp; &nbsp; <b><a href="<?php echo $referansRow['referansURL']; ?>">(URL'ye Git)</a></b></td>
              <td><?php
                    $kategoriler = explode(' ', $referansRow['kategori']);
                    $array = [];
                    foreach ($kategoriler as $item) {
                        foreach ($cats as $cat) {
                            if ($item == $cat['sayfa_id']){
                                array_push($array, $cat['sayfa_baslik']);
                            }
                        }
                    }
                    echo implode(' - ',$array);
                  ?>
              </td>
            <td>
              <label class="switch">

<input type="checkbox" id="toggle[<?=$referansRow['id']?>]" name="toggle" <?php if($referansRow['aktifkontrol']=="aktif"){ print "checked"; } ?> onclick="aktifkontrol(<?=$referansRow['id']?>,'referans');">
                <span class="slider round"></span>
              </label>
            </td>
            <td align="center">
              <?php if($referansRow["sira"] != "1"){?><a href="index.php?do=referans&islev=yukari&id=<?=$referansRow["id"]?>&sira=<?=$referansRow["sira"]?>"><i class="fa fa-arrow-up fa-2x" style="color:green;"></i></a> <?php } ?>
&nbsp;  &nbsp; <?php if($referansRow["sira"] != Count($referans)){?><a href="index.php?do=referans&islev=asagi&id=<?=$referansRow["id"]?>&sira=<?=$referansRow["sira"]?>"><i class="fa fa-arrow-down fa-2x" style="color:red;"></i></a><?php } ?>
            </td>
            <td class="text-center">
                <a href="index.php?do=referans&duzenle=<?php echo $referansRow['id']; ?>" class="btn btn-sm btn-primary btn-xs btn-push"><i class="fa fa-edit"></i> Düzenle</a>
                <a href="#" onclick="itemsil(<?php echo $referansRow['id']?>,'','<?php echo $referansRow['referansBaslik']?>','referans');" class="btn btn-sm btn-danger btn-xs btn-push"><i class="fa fa-trash"></i> Resmi Sil</a>
            </td>
          </tr>
          <?php } ?>
        </tbody>
      </table>
    </div>

</div>
  <?php
    //$Modul->sayfalama('referans',"referans",$kayitsayisi);
  ?>
</div>
<script>
    $(document).ready(function(){
        $('.selectCategory li').click(function () {
            $('li').removeClass("active");
            $(this).addClass("active");
            var selectText = $('.selectCategory li.active a').html();
            var selectID = $('.selectCategory li.active').attr('data');
            $('#catSelectText').html(selectText);
            $('#categoryName').val(selectText);
            $('#categoryId').val(selectID);
            $('#sorgula').click();
        });
    });
</script>

İptal

📁 PHP Dosya Yöneticisi

📝 referans.php

📝 referans.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)