📁 PHP Dosya Yöneticisi
/
/
home
/
demodesigncom
/
falscripti.demodesign.com.tr
/
ns-admin
📝
degerlendirmeduzenle.php
← Geri Dön
<?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="container-fluid px-[0.625rem]"> <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"> © <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>
💾 Kaydet
İptal
📝 Yeniden Adlandır
İptal
Kaydet
🔐 Dosya İzinleri (chmod)
İzin Değeri:
Hızlı Seçim:
777
755
644
600
777
= Herkes okur/yazar/çalıştırır
755
= Sahip tam, diğerleri okur/çalıştırır
644
= Sahip okur/yazar, diğerleri okur
600
= Sadece sahip okur/yazar
İptal
Uygula