PHP Dosya Yöneticisi

<?php
if (isset($_GET['id'])) {
  $id = htmlspecialchars($_GET['id'], ENT_QUOTES, 'UTF-8');
  $sql = "SELECT id, email, ad_soyad, tecrube, yazili_kredi, sesli_kredi, kahve_canli_kredi, tarot_canli_kredi, foto, hakkinda, kahve_fali, tarot_fali, kahve_populer, tarot_populer, cevrimici, banka, iban, telefon, el_fali,yuz_fali, bekleyen_kisi, yorum_sayisi, favori_sayisi, fal_bakti_sayisi, kisa_aciklama, degerlendirme FROM falci WHERE id=?";

$stmt = $conn->prepare($sql);
  $stmt->bind_param("i", $id);
  $stmt->execute();

if ($stmt->error) {
    echo "Error: " . $stmt->error;
  } else {
    $stmt->bind_result($id, $email, $ad_soyad, $tecrube, $yazili_kredi, $sesli_kredi, $kahve_canli_kredi, $tarot_canli_kredi, $foto, $hakkinda, $kahve_fali, $tarot_fali, $kahve_populer, $tarot_populer, $cevrimici, $banka, $iban, $telefon, $el_fali, $yuz_fali, $bekleyen_kisi, $yorum_sayisi, $favori_sayisi, $fal_bakti_sayisi, $kisa_aciklama, $degerlendirme);

if ($stmt->fetch()) {
      // Veritabanından alınan veriler bu kısımda kullanılabilir.
      // Örneğin: echo $ad_soyad; 
    } else {
      echo "Kayıt bulunamadı.";
    }

$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');
  $email = htmlspecialchars($_POST['email'], ENT_QUOTES, 'UTF-8');
  $ad_soyad = htmlspecialchars($_POST['ad_soyad'], ENT_QUOTES, 'UTF-8');
  $tecrube = htmlspecialchars($_POST['tecrube'], ENT_QUOTES, 'UTF-8');
  $yazili_kredi = htmlspecialchars($_POST['yazili_kredi'], ENT_QUOTES, 'UTF-8');
  $sesli_kredi = htmlspecialchars($_POST['sesli_kredi'], ENT_QUOTES, 'UTF-8');
  $kahve_canli_kredi = htmlspecialchars($_POST['kahve_canli_kredi'], ENT_QUOTES, 'UTF-8');
  $tarot_canli_kredi = htmlspecialchars($_POST['tarot_canli_kredi'], ENT_QUOTES, 'UTF-8');
  $foto = htmlspecialchars($_POST['foto'], ENT_QUOTES, 'UTF-8');
  $hakkinda = htmlspecialchars($_POST['hakkinda'], ENT_QUOTES, 'UTF-8');
  $kahve_fali = htmlspecialchars($_POST['kahve_fali'], ENT_QUOTES, 'UTF-8');
  $tarot_fali = htmlspecialchars($_POST['tarot_fali'], ENT_QUOTES, 'UTF-8');
  $kahve_populer = htmlspecialchars($_POST['kahve_populer'], ENT_QUOTES, 'UTF-8');
  $tarot_populer = htmlspecialchars($_POST['tarot_populer'], ENT_QUOTES, 'UTF-8');
  $cevrimici = htmlspecialchars($_POST['cevrimici'], ENT_QUOTES, 'UTF-8');
  $banka = htmlspecialchars($_POST['banka'], ENT_QUOTES, 'UTF-8');
  $iban = htmlspecialchars($_POST['iban'], ENT_QUOTES, 'UTF-8');
  $telefon = htmlspecialchars($_POST['telefon'], ENT_QUOTES, 'UTF-8');
  $el_fali = htmlspecialchars($_POST['el_fali'], ENT_QUOTES, 'UTF-8');
  $yuz_fali = htmlspecialchars($_POST['yuz_fali'], ENT_QUOTES, 'UTF-8');
  $bekleyen_kisi = htmlspecialchars($_POST['bekleyen_kisi'], ENT_QUOTES, 'UTF-8');
  $yorum_sayisi = htmlspecialchars($_POST['yorum_sayisi'], ENT_QUOTES, 'UTF-8');
  $favori_sayisi = htmlspecialchars($_POST['favori_sayisi'], ENT_QUOTES, 'UTF-8');
  $fal_bakti_sayisi = htmlspecialchars($_POST['fal_bakti_sayisi'], ENT_QUOTES, 'UTF-8');
  $kisa_aciklama = htmlspecialchars($_POST['kisa_aciklama'], ENT_QUOTES, 'UTF-8');
  $degerlendirme = htmlspecialchars($_POST['degerlendirme'], ENT_QUOTES, 'UTF-8');

$sql = "UPDATE falci SET 
          email = ?, 
          ad_soyad = ?, 
          tecrube = ?, 
          yazili_kredi = ?, 
          sesli_kredi = ?, 
          kahve_canli_kredi = ?, 
          tarot_canli_kredi = ?, 
          foto = ?,
          hakkinda = ?,
          kahve_fali = ?,
          tarot_fali = ?,
          kahve_populer = ?,
          tarot_populer = ?,
          cevrimici = ?,
          banka = ?, 
          iban = ?,
          telefon = ?,
          el_fali = ?,
          yuz_fali = ?,
          bekleyen_kisi = ?,
          yorum_sayisi = ?,
          favori_sayisi = ?,
          fal_bakti_sayisi = ?,
          kisa_aciklama = ?,
          degerlendirme = ?
          WHERE
          id = ?";

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

$stmt->bind_param("ssiiiiissiiiiisssiiiiiissi", $email, $ad_soyad, $tecrube, $yazili_kredi, $sesli_kredi, $kahve_canli_kredi, $tarot_canli_kredi, $foto, $hakkinda, $kahve_fali, $tarot_fali, $kahve_populer, $tarot_populer, $cevrimici, $banka, $iban, $telefon, $el_fali, $kahve_yazili_fal, $bekleyen_kisi, $yorum_sayisi, $favori_sayisi, $fal_bakti_sayisi, $kisa_aciklama, $degerlendirme, $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; 
  ">Falcı Güncellendi!</div>';
  } else {
    echo "Hata: " . $stmt->error;
  }

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

$conn->close();

<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">
                        Falcı 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">
                                    Falcılar
                                </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">Falcıyı Düzenle</a>
                                </div>
                            </li>
                        </ol>
                    </nav>
                </div>
            </div>
            <div class="grid grid-cols-1">
                <div class="card dark:bg-zinc-800 dark:border-zinc-600">
                    <div class="card-body border-b border-gray-100 dark:border-zinc-600">
                        <h6 class="mb-1 text-gray-700 text-15 dark:text-gray-100">Yeni Falcı Ayarları</h6>
                    </div>
                    <form action="" method="post" style="padding: 20px">
                    <br>
                    <div class="mb-3">
                        <label class="form-label" for="ad_soyad">Ad Soyad</label>
                        <input type="text" 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" name="ad_soyad" value="<?php echo $ad_soyad; ?>"
                          name="ad_soyad" aria-label="Ad Soyad" required />
                      </div>
                     
                      <div class="mb-3">
                        <label class="form-label" for="tecrube">Tecrübe</label>
                        <input type="number" 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" name="tecrube" value="<?php echo $tecrube; ?>"
                          name="tecrube" aria-label="2" required />
                      </div>
                      <div class="mb-3">
                        <label class="form-label" for="hakkinda">Hakkında</label>
                        <input type="text" 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" name="hakkinda" value="<?php echo $hakkinda; ?>"
                          name="hakkinda" aria-label="6" required />
                      </div>
                      <div style="background-color: #f8f9fc; padding: 20px; border-radius: 10px; box-shadow: 0 4px 6px rgba(0, 0, 0, 0.1); color: #333; font-size: 18px; max-width: 300px; text-align: center;">
    AŞAĞIDA SADECE 1 TANE FALCI TÜRÜNE EVET DEYİN. 2.BİR FAL TÜRÜ EKLERSENİZ FALCININ PROFİLİNDE RASTGELE
</div>
                      <div class="mb-4">
                        <label class="form-label" for="yuz_fali">Yüz  Falı</label>
                        <select name="yuz_fali" 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">
                          <option value="0" <?php echo $yuz_fali == 0 ? 'selected' : ''; ?>>Hayır</option>
                          <option value="1" <?php echo $yuz_fali == 1 ? 'selected' : ''; ?>>Evet</option>
                        </select>
                      </div>
                      
                      <div class="mb-4">
                        <label class="form-label" for="el_fali">El Falı</label>
                        <select name="el_fali" 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">
                          <option value="1" <?php echo $el_fali == 1 ? 'selected' : ''; ?>>Evet</option>
                          <option value="0" <?php echo $el_fali == 0 ? 'selected' : ''; ?>>Hayır</option>
                        </select>
                      </div>
                      
                      <div class="mb-4">
                        <label class="form-label" for="kahve_fali">Kahve Falı</label>
                        <select name="kahve_fali" 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">
                          <option value="1" <?php echo $kahve_fali == 1 ? 'selected' : ''; ?>>Evet</option>
                          <option value="0" <?php echo $kahve_fali == 0 ? 'selected' : ''; ?>>Hayır</option>
                        </select>
                      </div>
                      <div class="mb-4">
                        <label class="form-label" for="tarot_fali">Tarot Falı</label>
                        <select name="tarot_fali" 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">
                          <option value="1" <?php echo $tarot_fali == 1 ? 'selected' : ''; ?>>Evet</option>
                          <option value="0" <?php echo $tarot_fali == 0 ? 'selected' : ''; ?>>Hayır</option>
                        </select>
                      </div>
                      
                      <div style="background-color: #f8f9fc; padding: 20px; border-radius: 10px; box-shadow: 0 4px 6px rgba(0, 0, 0, 0.1); color: #333; font-size: 18px; max-width: 300px; text-align: center;">
    İKİ Kredi Miktarınıda güncelleyin örneğin : biri 500 kredi ise diğeri de 500 kredi olmalı.
</div>

<div class="mb-3">
                        <label class="form-label" for="yazili_kredi"> Kredi miktarları ( ( El Falı, Yüz Falıi Kahve Falı ve Tarot Falı'nın kredi miktarları ortaktır buraya ne girerseniz seçtiğiniz fal türüne o kredi tanımlanır.)</label>
                        <input type="number" name="yazili_kredi" 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="<?php echo $yazili_kredi; ?>" aria-label="200" name="yazili_kredi"
                          required />
                          <div class="mb-3">
                        <label class="form-label" for="kahve_canli_kredi"> Kredi miktarları 2 ( ( El Falı, Yüz Falıi Kahve Falı ve Tarot Falı'nın kredi miktarları ortaktır buraya ne girerseniz seçtiğiniz fal türüne o kredi tanımlanır.)</label>
                        <input type="number" name="kahve_canli_kredi" 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="<?php echo $kahve_canli_kredi; ?>" aria-label="200" name="kahve_canli_kredi"
                          required />
                      </div>
                      <div class="mb-3">
                        <label class="form-label" for="sesli_kredi"> Kredi miktarları 3 ( El Falı, Yüz Falıi Kahve Falı ve Tarot Falı'nın kredi miktarları ortaktır buraya ne girerseniz seçtiğiniz fal türüne o kredi tanımlanır.)</label>
                        <input type="number" name="sesli_kredi" 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="<?php echo $sesli_kredi; ?>" aria-label="200" name="sesli_kredi"
                          required />
                      </div>
           
                      <div class="mb-4">
                        <label class="form-label" for="kahve_populer">Ana Sayfa - Popüler Kahve Falcısı?</label>
                        <select name="kahve_populer" 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">
                          <option value="1" <?php echo $kahve_populer == 1 ? 'selected' : ''; ?>>Evet</option>
                          <option value="0" <?php echo $kahve_populer == 0 ? 'selected' : ''; ?>>Hayır</option>
                        </select>
                      </div>
                      <div class="mb-4">
                        <label class="form-label" for="tarot_populer">Ana Sayfa - Tarot Popüler</label>
                        <select name="tarot_populer" 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">
                          <option value="1" <?php echo $tarot_populer == 1 ? 'selected' : ''; ?>>Evet</option>
                          <option value="0" <?php echo $tarot_populer == 0 ? 'selected' : ''; ?>>Hayır</option>
                        </select>
                      </div>
                      <div class="mb-4">
                        <label class="form-label" for="cevrimici">Çevrimiçi , Meşgul</label>
                        <select name="cevrimici" 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">
                          <option value="1" <?php echo $cevrimici == 1 ? 'selected' : ''; ?>>Evet</option>
                          <option value="0" <?php echo $cevrimici == 0 ? 'selected' : ''; ?>>Hayır</option>
                          <option value="2" <?php echo $cevrimici == 2 ? 'selected' : ''; ?>>Meşgul</option>
                        </select>
                      </div>
                     
                      <div class="mb-3">
                        <label class="form-label" for="yorum_sayisi">Yorum Sayısı</label>
                        <input type="number" name="yorum_sayisi" 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="<?php echo $yorum_sayisi; ?>" aria-label="250" name="yorum_sayisi" required />
                      </div>
                      <div class="mb-3">
                        <label class="form-label" for="favori_sayisi">Favori Sayısı</label>
                        <input type="number" name="favori_sayisi" 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="<?php echo $favori_sayisi; ?>" aria-label="250" name="favori_sayisi" required />
                      </div>
                      <div class="mb-3">
                        <label class="form-label" for="fal_bakti_sayisi">Baktığı Fal Sayısı</label>
                        <input type="number" name="fal_bakti_sayisi" 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="<?php echo $fal_bakti_sayisi; ?>" aria-label="250" name="fal_bakti_sayisi" required />
                      </div>
                      <div class="mb-3">
                        <label class="form-label" for="kisa_aciklama">Kısa Açıklama</label>
                        <input type="text" 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" name="kisa_aciklama"
                          value="<?php echo $kisa_aciklama; ?>" name="kisa_aciklama" aria-label="6" required />
                      </div>
                      <div class="mb-3">
                        <label class="form-label" for="degerlendirme">Değerlendirme</label>
                        <input type="number" name="degerlendirme" id="degerlendirme" 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="<?php echo $degerlendirme; ?>" aria-label="100" step="0.1" min="0.0" max="5.0"
                          required />
                      </div>
                      
                      <div class="mb-3">
                        <label class="form-label" for="foto">Foto</label>
                        <input type="text" 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" name="foto" value="<?php echo $foto; ?>" name="foto"
                          aria-label="6" required />
                      </div>

<button type="submit" class="btn btn-primary">Kaydet</button>
                    </form>
                </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

📝 falciduzenle.php

📝 falciduzenle.php

📝 Yeniden Adlandır

🔐 Dosya İzinleri (chmod)