PHP Dosya Yöneticisi

<?php
include('inc/head.php');
include('inc/header.php');

if ($kullanici['yetki'] == 0) {
    echo '<div class="container-xxl container-p-y">
  <div class="misc-wrapper">
    <h2 class="mb-1 mx-2">Yetkisiz erişim!</h2>
    <p class="mb-4 mx-2">Yetkiniz olmayan bir sayfaya girmeye çalışıyorsunuz. <br> Site yöneticisi ile iletişime geçin.</p>
    <a href="index" class="btn btn-primary mb-4">Anasayfa</a>
    <div class="mt-4">
      <img src="assets/img/illustrations/page-misc-you-are-not-authorized.png" alt="page-misc-not-authorized" width="170" class="img-fluid">
    </div>
  </div>
</div>
</div>
';
} else {
    ?>
    <div class="container-xxl flex-grow-1 container-p-y">
        <?php
        if ($_POST['yenikat']) {
            $name = $_POST['name'];
            $gizlih = $_POST['gizlih'];
            $aciklama = $_POST['aciklama'];
            $slug = seolink($_POST['name']);

// Sorgu hazırlama
            $stmt = $db->prepare("INSERT INTO kategori (name, gizlih, aciklama, slug) VALUES (:name, :gizlih, :aciklama, :slug)");

// Parametreleri bağlama
            $stmt->bindParam(':name', $name);
            $stmt->bindParam(':gizlih', $gizlih);
            $stmt->bindParam(':aciklama', $aciklama);
            $stmt->bindParam(':slug', $slug);

// Sorguyu çalıştırma
            $stmt->execute();

echo "Yeni kategori başarıyla kaydedildi.";
        } elseif ($_POST['kategori_id']) {
            $name = $_POST['yeniname'];
            $gizlih = $_POST['yenigizlih'];
            $aciklama = $_POST['yeniaciklama'];
            $kategori_id = $_POST['kategori_id'];
            $slug = seolink($_POST['yeniname']);

$sql = "UPDATE kategori SET name = :name, gizlih = :gizlih, aciklama = :aciklama, slug = :slug WHERE id = :id";

$stmt = $db->prepare($sql);
            $stmt->bindParam(':name', $name);
            $stmt->bindParam(':gizlih', $gizlih);
            $stmt->bindParam(':aciklama', $aciklama);
            $stmt->bindParam(':slug', $slug);
            $stmt->bindParam(':id', $kategori_id);
            $stmt->execute();

echo "Kategori başarıyla düzenlendi.";
        }

if (isset($_GET['sil'])) {
            $id = $_GET['sil'];
            $sql = "DELETE FROM kategori WHERE id = :id";
            $stmt = $db->prepare($sql);
            $stmt->bindParam(':id', $id);
            if ($stmt->execute()) {
                echo '<div class="alert alert-danger d-flex align-items-center" role="alert"> <span class="alert-icon text-danger me-2"> <i class="fas fa-times"></i> </span> Silindi </div><script>          setTimeout(function() {       const url = "https://' . $_SERVER['SERVER_NAME'] . $_SERVER['REQUEST_URI'] . '/"; var params = new URLSearchParams(window.location.search); params.delete("sil");  var newUrl = window.location.origin + window.location.pathname; history.pushState(null, null, newUrl);         location.reload();     }, 3000); </script>';
            } else {
                echo '<div class="alert alert-danger mg-b-0" role="alert">  <a href="#" class="alert-link">Hata</a> ...</div>';
            }
        }

<div class="container-xxl flex-grow-1 container-p-y">
            <div class="card">
                <form action="" method="post">
                    <div class="card-header header-elements">
                <span class="me-2">Kategoriler</span>
                <div class="card-header-elements ms-auto">
                    <div class="btn-group">
                        <button type="button" class="btn btn-success" data-bs-toggle="modal" data-bs-target="#kategorimodal">Kategori Ekle</button>
                    </div>
                </div>
            </div>
            <div class="table-responsive text-nowrap">
                <table class="table">
                    <thead class="table-dark">
                    <tr>
                        <th>#</th>
                        <th>Kategori</th>
                        <th>İşlem</th>
                    </tr>
                    </thead>
                    <tbody class="table-border-bottom-0">
                    <?php
                    $urunler = cokluveri("kategori", $db);
                    foreach ($urunler as $urun) { ?>
                        <tr>
                            <td>
                                <strong><?= $urun['id'] ?></strong>
                            </td>
                            <td><?= $urun['name'] ?></td>
                            <td>
                                <a data-bs-toggle="modal" data-bs-target="#duzenle<?= $urun['id'] ?>"><button class="btn btn-info btn-sm">Düzenle</button></a>
                                <a class="btn btn-danger btn-sm" href="?sil=<?= $urun['id'] ?>">Sil</a>
                            </td>
                        </tr>
                        <div class="modal fade" id="duzenle<?= $urun['id'] ?>" tabindex="-1" aria-hidden="true">
                            <div class="modal-dialog modal-xl modal-simple modal-pricing">
                                <div class="modal-content p-2 p-md-5">
                                    <div class="modal-body">
                                        <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                                        
                                        <div class="  rounded-top">
                                            <h2 class="text-center mb-2">Kategori Düzenle</h2>
                                            <form action="" method="post" enctype="multipart/form-data">
                                                <div class="mb-3 row">
                                                    <div class="col-md-12">
                                                        <label class="form-label" for="basic-default-fullname"></label>
                                                        <input type="text" style="display: none" value="<?= $urun['id'] ?>" class="form-control" id="basic-default-fullname" name="id" placeholder="Kategori Adı" />
                                                        <input type="text" class="form-control" id="basic-default-fullname" name="yeniname" value="<?= $urun['name'] ?>" placeholder="Yeni Kategori Adı" required />
                                                    </div>
                                                    <div class="col-md-12">
                                                        <label class="form-label" for="basic-default-fullname"></label>
                                                        <input type="text" class="form-control" id="basic-default-fullname" name="yenigizlih" value="<?= $urun['gizlih'] ?>" placeholder="Gizli H Etiketi" required />
                                                    </div>
                                                    <div class="col-md-12">
                                                        <label class="form-label" for="basic-default-fullname"></label>
                                                        <textarea class="form-control" id="basic-default-fullname" name="yeniaciklama"><?= $urun['aciklama'] ?></textarea>
                                                    </div>
                                                    <input type="text" value="<?= $urun['id'] ?>" name="kategori_id" style="display: none;">
                                                    <div class="col-md-12" style="margin-top: 15px">
                                                        <label class="form-label" for="basic-default-fullname"></label>
                                                        <button style="width: 100%" type="submit" class="btn btn-primary">Düzenle</button>
                                                    </div>
                                                </div>
                                            </form>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    <?php }
                    ?>
                    </tbody>
                </table>
            </div>
        </div>
    </div>
    <div class="modal fade" id="kategorimodal" tabindex="-1" aria-hidden="true">
        <div class="modal-dialog modal-xl modal-simple modal-pricing">
            <div class="modal-content p-2 p-md-5">
                <div class="modal-body">
                    <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                    
                    <form action="" method="post" enctype="multipart/form-data">
                        <div class="mb-3 row">
                            <div class="col-md-10">
                                <input type="text" name="yenikat" value="1" style="display: none;">
                                <label class="form-label" for="basic-default-fullname"></label>
                                <input type="text" class="form-control" id="basic-default-fullname" name="name" placeholder="Yeni Kategori Adı" />
                            </div>
                            <div class="col-md-10">
                                <label class="form-label" for="basic-default-fullname"></label>
                                <input type="text" class="form-control" id="basic-default-fullname" name="gizlih" placeholder="Gizli H Etiketi" />
                            </div>
                            <div class="col-md-10">
                                <label class="form-label" for="basic-default-fullname"></label>
                                <textarea class="form-control" id="basic-default-fullname" name="aciklama" placeholder="Kategori Açıklaması"></textarea>
                            </div>
                            <div class="col-md-2">
                                <label class="form-label" for="basic-default-fullname"></label>
                                <button style="width: 100%" type="submit" class="btn btn-primary">Ekle</button>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>
<?php
}
include('inc/footer.php');
?>

İptal

📁 PHP Dosya Yöneticisi

📝 kategori.php

📝 kategori.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)