PHP Dosya Yöneticisi

<?php
include("db.php");

if (isset($_GET['id'])) {
    $id = htmlspecialchars($_GET['id'], ENT_QUOTES, 'UTF-8');

// degerlendirme tablosu sorgusu
    $sql = "SELECT id, falci_id, yorum, puan, yapan_uid, tarih FROM degerlendirme WHERE id=?";
    $stmt = $conn->prepare($sql);
    $stmt->bind_param("i", $id);
    $stmt->execute();

$stmt->bind_result($id, $falci_id, $yorum, $puan, $yapan_uid, $tarih);

if (!$stmt->fetch()) {
        echo "Kayıt bulunamadı.";
        exit;
    }
    $stmt->close();

// falci tablosu sorgusu
    $sql = "SELECT ad_soyad FROM falci WHERE id=?";
    $stmt = $conn->prepare($sql);
    $stmt->bind_param("i", $falci_id);
    $stmt->execute();

$stmt->bind_result($falci_ad_soyad);

if (!$stmt->fetch()) {
        $falci_ad_soyad = 'Bilinmeyen Falcı';
    }
    $stmt->close();

// kullanici tablosu sorgusu
    $sql = "SELECT ad, soyad FROM kullanici WHERE uid=?";
    $stmt = $conn->prepare($sql);
    $stmt->bind_param("s", $yapan_uid);
    $stmt->execute();

$stmt->bind_result($ad, $soyad);

if (!$stmt->fetch()) {
        $kullanici_ad_soyad = 'Bilinmeyen Kullanıcı';
    } else {
        $kullanici_ad_soyad = $ad . ' ' . $soyad;
    }
    $stmt->close();
} else {
    echo '<div style=" 
    min-width: 250px; 
    margin-left: -125px; 
    background-color: #333; 
    color: #fff;
    text-align: center; 
    border-radius: 2px; 
    padding: 16px; 
    position: fixed; 
    z-index: 1; 
    left: 50%; 
    bottom: 30px; 
  ">HATA ID YOK!</div>';
}

if ($_SERVER["REQUEST_METHOD"] == "POST") {
  $id = htmlspecialchars($_GET['id'], ENT_QUOTES, 'UTF-8');
  $yorum = htmlspecialchars($_POST['yorum'], ENT_QUOTES, 'UTF-8');
  $puan = htmlspecialchars($_POST['puan'], ENT_QUOTES, 'UTF-8');
  $tarih = date('d.m.Y');

$sql = "UPDATE degerlendirme SET 
          yorum = ?, 
          puan = ?, 
          tarih = ?
          WHERE
          id = ?";

$stmt = $conn->prepare($sql);

$stmt->bind_param("sssi", $yorum, $puan, $tarih, $id);

if ($stmt->execute()) {
    echo '<div style=" 
    min-width: 250px; 
    margin-left: -125px; 
    background-color: #333; 
    color: #fff;
    text-align: center; 
    border-radius: 2px; 
    padding: 16px; 
    position: fixed; 
    z-index: 1; 
    left: 50%; 
    bottom: 30px; 
  ">Güncellendi!</div>';
  } else {
    echo "Hata: " . $stmt->error;
  }

// Statement'i kapatma
  $stmt->close();
}

$conn->close();

?>
<div class="main-content group-data-[sidebar-size=sm]:ml-[70px]">
    <div class="page-content dark:bg-zinc-700">

<div class="grid grid-cols-1 pb-6">
                <div class="md:flex items-center justify-between px-[2px]">
                    <h4 class="text-[18px] font-medium text-gray-800 mb-sm-0 grow dark:text-gray-100 mb-2 md:mb-0">Değerlendirme Düzenle
                    </h4>
                    <nav class="flex" aria-label="Breadcrumb">
                        <ol class="inline-flex items-center space-x-1 ltr:md:space-x-3 rtl:md:space-x-0">
                            <li class="inline-flex items-center">
                                <a href="#" class="inline-flex items-center text-sm text-gray-800 hover:text-gray-900 dark:text-zinc-100 dark:hover:text-white">
                                    Sistem
                                </a>
                            </li>
                            <li>
                                <div class="flex items-center rtl:mr-2">
                                    <i class="font-semibold text-gray-600 align-middle far fa-angle-right text-13 rtl:rotate-180 dark:text-zinc-100"></i>
                                    <a href="#" class="text-sm font-medium text-gray-500 ltr:ml-2 rtl:mr-2 hover:text-gray-900 ltr:md:ml-2 rtl:md:mr-2 dark:text-gray-100 dark:hover:text-white">Değerlendirmeyi Düzenle</a>
                                </div>
                            </li>
                        </ol>
                    </nav>
                </div>
            </div>
            <div class="grid grid-cols-12 gap-6">
                <div class="col-span-12">
                    <div class="card dark:bg-zinc-800 dark:border-zinc-600">
                        <div class="relative overflow-x-auto card-body">
                        <form action="" method="POST">
                      <h6 class="mb-0">Falcı:
                        <?php echo $falci_ad_soyad; ?>
                      </h6>
                      <h6 class="mb-0"> Yorum Yapan:
                        <?php echo $kullanici_ad_soyad; ?>
                      </h6>
                      <h6 class="mb-0">Tarih:
                        <?php echo $tarih; ?>
                      </h6>
                      <h6 class="mb-0">Değerlendirme:
                        <?php echo $puan; ?>
                      </h6>
                      <h6 class="mb-0">Yorum:
                        <?php echo $yorum; ?>
                      </h6>
                      </br>
                      <?php
                      echo '<div class="mb-3">
                          <label class="form-label" for="yorum">Yorum</label>
                          <textarea rows="10" name="yorum" class="w-full placeholder:text-13 text-13 py-1.5 rounded border-gray-100 focus:border focus:border-violet-50 focus:ring focus:ring-violet-500/20  dark:bg-zinc-700/50 dark:border-zinc-600 dark:placeholder:text-zinc-100 placeholder:text-gray-800 dark:text-zinc-100" aria-label="Giriniz..."
                          placeholder="Giriniz...">';
                      echo $yorum;
                      echo ' </textarea>
                          </div>';

echo '<div class="mb-3">
                          <label class="form-label" for="puan">Değerlendirme</label>
                          <input type="number" name="puan" id="puan" class="w-full placeholder:text-13 text-13 py-1.5 rounded border-gray-100 focus:border focus:border-violet-50 focus:ring focus:ring-violet-500/20  dark:bg-zinc-700/50 dark:border-zinc-600 dark:placeholder:text-zinc-100 placeholder:text-gray-800 dark:text-zinc-100"
                        value="' . $puan . '" aria-label="100" step="0.1" min="0.0" max="5.0" required />
                          </div>';
                      ?>
                      <button type="submit" class="btn btn-primary">Kaydet</button>
                    </form>

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

<footer class="absolute bottom-0 left-0 right-0 px-5 py-5 bg-white border-t footer border-gray-50 dark:bg-zinc-700 dark:border-zinc-600 dark:text-gray-200">
                <div class="grid grid-cols-2 text-gray-500 dark:text-zinc-100">
                    <div class="grow">
                        &copy;
                        <script>
                            document.write(new Date().getFullYear());
                        </script> Minia
                    </div>
                    <div class="hidden md:inline-block text-end">Design & Develop by <a href="#" class="underline text-violet-500">Themesbrand</a></div>
                </div>
            </footer>
        </div>
    </div>
</div>

İptal

📁 PHP Dosya Yöneticisi

📝 degerlendirmeduzenle.php

📝 degerlendirmeduzenle.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)