PHP Dosya Yöneticisi

<?php echo !defined("GUVENLIK") ? die("Vaoww! Bu ne cesaret?") : null;?>
<title>Sayaç Yönetimi | <?=$ayar['site_baslik']?></title>
<?php
$Sayfa = @intval($_GET['page']); if(!$Sayfa) $Sayfa = 1;
$Say = $db->query("select * from sayac where dil='$_SESSION[dil]' order by sira ASC");
$ToplamVeri = $Say->rowCount();
$Limit = 20;
$Sayfa_Sayisi = ceil($ToplamVeri/$Limit); if($Sayfa > $Sayfa_Sayisi){$Sayfa = 1;}
$Goster = $Sayfa * $Limit - $Limit;
$GorunenSayfa = 5;
$ara = $_GET['search'];
$listele_tablo = $db->query("select * from sayac where (baslik like '%$ara%') and dil='$_SESSION[dil]' order by sira ASC limit $Goster,$Limit");
$tabloAl = $listele_tablo->fetchAll(PDO::FETCH_ASSOC);

$CountAyarCek = $db->prepare("select * from sayac_ayar where id='1'");
$CountAyarCek->execute();
$sayacayar = $CountAyarCek->fetch(PDO::FETCH_ASSOC);
?>
<div class="content">
    <div class="col-span-12 mt-6">
        <form action="post/toplu-sil/sayaclari-sil.php" method="post" style="width: 100%">

<div class="intro-y block sm:flex items-center h-10">
                <h2 class="text-lg font-medium truncate mr-5">
                    Sayaç Yönetimi
                </h2>
                    <div class="flex items-center sm:ml-auto mt-3 sm:mt-0">
                        <button class="btn btn-secondary shadow-md mr-2"> <i data-lucide="trash" class="hidden sm:block w-4 h-4 mr-2"></i> Seçilenleri Sil </button>
                        <a href="pages.php?sayfa=sayacekle" class="btn btn-primary shadow-md mr-2"> <i data-lucide="plus" class="hidden sm:block w-4 h-4 mr-2"></i> Yeni Ekle </a>
                    </div>
            </div>
            <div class="intro-y overflow-auto lg:overflow-visible mt-8 sm:mt-0">
                <?php if ($listele_tablo->rowCount() > 0) {?>
                    <table class="table table-report table-bordered table-hover sm:mt-2">
                        <thead class="table-dark">
                        <tr>
                            <th class="text-center whitespace-nowrap"  style="width: 30px">
                                <div class="form-checkbox" style="overflow: hidden; height: 24px;">
                                    <input type="checkbox" class="selectall" id="hepsiniSecCheckBox" />
                                    <label for="hepsiniSecCheckBox"></label>
                                </div>
                            </th>
                            <th class="text-center whitespace-nowrap" style="width: 30px">SIRA</th>
                            <th class="text-center whitespace-nowrap" style="width: 30px">İKON</th>
                            <th class="text-center whitespace-nowrap">BAŞLIK</th>
                            <th class="text-center whitespace-nowrap">SAYI</th>
                            <th class="text-center whitespace-nowrap" style="width: 100px">DURUM</th>
                            <th class="text-center whitespace-nowrap">#</th>
                        </tr>
                        </thead>
                        <tbody>
                        <?php foreach ($tabloAl as $row) {?>
                            <tr class="intro-x">
                                <td class="text-center">
                                    <div class="form-checkbox">
                                        <input type="checkbox" name='sil[]' id="checkSec-<?=$row['id']?>" value="<?=$row['id']?>" class="individual">
                                        <label for="checkSec-<?=$row['id']?>"></label>
                                    </div>
                                </td>
                                <td class="text-center">
                                    <?=$row['sira']?>
                                </td>
                                <td class="text-center">
                                    <i class="fa <?=$row['icon']?>"></i>
                                </td>
                                <td class="text-center">
                                    <a class="font-medium whitespace-nowrap"><?=$row['baslik']?></a>
                                </td>
                                <td class="text-center">
                                    <a class="font-medium whitespace-nowrap"><?=$row['count']?></a>
                                </td>
                                <td class="text-center">
                                    <?php
                                    if($row['durum'] == 1) {
                                        ?>
                                        <span style="color: white" class="btn btn-success btn-sm"><i class="fa fa-check"></i> Aktif</span>
                                    <?php } ?>
                                    <?php
                                    if($row['durum'] == 0) {
                                        ?>
                                        <span style="color: white" class="btn btn-danger btn-sm"><i class="fa fa-times"></i> Pasif</span>
                                    <?php } ?>
                                </td>
                                <td class="table-report__action w-56">
                                    <div class="flex justify-center items-center">
                                        <a href="pages.php?sayfa=sayac&sayac_id=<?=$row['id']?>" class="flex items-center mr-3"> <i data-lucide="check-square" class="w-4 h-4 mr-1"></i> DÜZENLE </a>
                                        <a onclick="deletebutton('<?=$row['id']?>')" class="flex items-center text-danger" style="cursor: pointer;"> <i data-lucide="trash-2" class="w-4 h-4 mr-1"></i> Sil </a>
                                    </div>
                                </td>
                            </tr>
                        <?php }?>
                        </tbody>
                    </table>
                <?php } else {?>
                    <div class="alert alert-info" style="font-weight: 400;">
                        Henüz Sayaç Eklenmemiş!
                    </div>
                <?php }?>
            </div>

<div class="intro-y flex flex-wrap sm:flex-row sm:flex-nowrap items-center mt-6">
                <?php if($Sayfa >= 1){?>
                <nav aria-label="w-full sm:w-auto sm:mr-auto">
                    <ul class="pagination">
                        <?php } ?>
                        <?php
                        for($i = $Sayfa - $GorunenSayfa; $i < $Sayfa + $GorunenSayfa +1; $i++){ if($i > 0 and $i <= $Sayfa_Sayisi){
                            if($i == $Sayfa){

echo '    
    
                            <li class="page-item active" aria-current="page">
                              <a class="page-link" href="pages.php?sayfa=sayaclar&page='.$i.'">'.$i.'<span class="sr-only"></span></a>
                            </li>
                            
                            ';

}else{
                                echo '
                    <li class="page-item"><a class="page-link" href="pages.php?sayfa=sayaclar&page='.$i.'">'.$i.'</a></li>
                    ';
                            }
                        }
                        }
                        ?>
                        <?php if($Sayfa >= 1){?>
                    </ul>
                </nav>
            <?php } ?>
        </form>

</div>

<?php
    if ($listele_tablo->rowCount()>0) {
        ?>
        <form method="get" action="pages.php?" style="margin-top: 30px">
            <div id="ticket" class="tab-pane active" role="tabpanel" aria-labelledby="ticket-tab">
                <div class="box p-5 mt-5 flex items-center sm:ml-auto mt-3 sm:mt-0">
                    <input name="sayfa" type="hidden" value="sayaclar">
                    <input name="search" style="width: 350px" type="text" class="form-control " placeholder="Aramak İstediğiniz Kelime...">
                    <button class="btn btn-primary ml-2">Ara</button>
                </div>
            </div>
        </form>
    <?php } ?>

</div>
</div>

function deletebutton(sayacid){

swal({
            title: "Silmek İstediğinize Emin Misiniz?",
            text: "Seçtiğiniz içerik kalıcı olarak silinecektir",
            type: "warning",
            showCancelButton: true,
            confirmButtonColor: "#DD6B55",
            confirmButtonText: "Sil",
            cancelButtonText: "İptal",
            closeOnConfirm: false,
            closeOnCancel: false
        }, function(isConfirm){
            if (isConfirm) {
                window.location.href = "post/sil/sayac-sil.php?sayac=success&id="+sayacid;
            } else {
                swal("İptal Edildi", "Seçtiğiniz içerik silinmemiştir", "error");
            }
        });

}

</script>

<?php if( $_GET['status']=='success'){ ?>
    <body onload="sweetAlert('İşlem Başarılı', 'İşleminiz başarıyla gerçekleşmiştir', 'success');">
    </body>
    <meta http-equiv="refresh" content="1; URL=pages.php?sayfa=sayaclar">
<?php }?>
<?php if($_GET['status']=='warning'){ ?>
    <body onload="sweetAlert('Başarısız!', 'İşlem sırasında hata oluştu', 'warning');">
    </body>
    <meta http-equiv="refresh" content="1; URL=pages.php?sayfa=sayaclar">
<?php }?>
<?php if($_GET['status']=='nocheck'){ ?>
    <body onload="sweetAlert('Sorun Var!', 'Hiç seçim yapılmamış!', 'warning');">
    </body>
    <meta http-equiv="refresh" content="1; URL=pages.php?sayfa=sayaclar">
<?php }?>

İptal

📁 PHP Dosya Yöneticisi

📝 sayaclar.php

📝 sayaclar.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)