<?php include_once 'Header.php'; ?>
<?php include_once 'SideBar.php'; ?>
  <!-- Content Wrapper. Contains page content -->
  <div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
      <div class="container-fluid">
        <div class="row mb-2">
          <div class="col-sm-6">
            <h1>Üyeler</h1>
          </div>
          <div class="col-sm-6">
            <ol class="breadcrumb float-sm-right">
              <li class="breadcrumb-item"><a href="index.php">Ana Sayfa</a></li>
              <li class="breadcrumb-item active">Üyeler</li>
            </ol>
          </div>
        </div>
      </div><!-- /.container-fluid -->
    </section>

    <!-- Main content -->
    <section class="content">
      <div class="container-fluid">
        <!-- /.row -->
        <div class="row">
          <div class="col-12">
            <div class="card">
              <div class="card-header">
                <h3 class="card-title">Üye Listesi</h3>
                <div class="card-tools">
                  <div class="input-group input-group-sm" style="width: 150px;">
                    <input type="text" name="table_search" class="form-control float-right" placeholder="Detaylı Arama">
                    <div class="input-group-append">
                      <button type="submit" class="btn btn-default"><i class="fas fa-search"></i></button>
                    </div>
                  </div>
                </div>
              </div>
              <!-- /.card-header -->
              <div class="card-body table-responsive p-0">
                <table class="table table-hover text-nowrap">
                  <thead>
                    <tr>
                    <th>Kimlik</th>
        <th>Ad Soyad</th>
        <th>Plaka</th>
        <th>Telefon</th>
        <th>Y.Telefon</th>
        <th>İkametgah</th>
        <th>Kan Grubu</th>
        <th>Yetki Durumu</th>
        <th>Düzenle</th>
        <th>Sil</th>
                    </tr>
                  </thead>
                  <tbody>
                  <?php
$sorgu = $baglanti->query("SELECT * FROM Uyeler"); // Makale tablosundaki tüm verileri çekiyoruz.
while ($sonuc = $sorgu->fetch_assoc()) {
$id = $sonuc['Kimlik']; // Veritabanından çektiğimiz id satırını $id olarak tanımlıyoruz.
$Ad = $sonuc["Ad_Soyad"];
$Plaka = $sonuc["Plaka"];
$Telefon = $sonuc["Telefon"];
$YTelefon = $sonuc["Y_Telefon"];
$ikametgah = $sonuc["Ikametgah"];
$KanGrubu = $sonuc["Kan_Grubu"];
$YetkiDurumu = $sonuc["Yetki"];
// While döngüsü ile verileri sıralayacağız. Burada PHP tagını kapatarak tırnaklarla uğraşmadan tekrarlatabiliriz.
?>
                    <tr>
                       <td><?php echo $id; // Yukarıda tanıttığımız gibi alanları dolduruyoruz. ?></td>
                      
        <td><?php echo $Ad; ?></td>
        <td><?php echo $Plaka; ?></td>
        <td><?php echo $Telefon; ?></td>
        <td><?php echo $YTelefon; ?></td>
        <td><?php echo $ikametgah; ?></td>
        <td><?php echo $KanGrubu; ?></td>
        <td><?php echo $YetkiDurumu; ?></td>
        
        <td><button type="button" class="btn btn-primary" class="btn btn-primary" data-toggle="modal" data-target="#modal-default">Düzenle</button></td>
        <td><a href="UyeSil.php?Kimlik=<?php echo $id; ?>" class="btn btn-danger">Sil</a></td>
                    </tr>
                    <?php
}
// Tekrarlanacak kısım bittikten sonra PHP tagının içinde while döngüsünü süslü parantezi kapatarak sonlandırıyoruz.
?>
                  
                  </tbody>
                </table>
              </div>
              <!-- /.card-body -->
            </div>
            <!-- /.card -->
          </div>
        </div>
        <div class="modal fade" id="modal-default">
        <div class="modal-dialog">
          <div class="modal-content">
            <div class="modal-header">
              <h4 class="modal-title">Üye Güncelle</h4>
              <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                <span aria-hidden="true">&times;</span>
              </button>
            </div>
            <div class="modal-body">
              
            
            <form action="" method="post">
                <div class="card-body">
                <div class="form-group">
                <label>Ad Soyad</label>
                  <div class="input-group mb-3">
                  <div class="input-group-prepend">
                    <span class="input-group-text"><i class="fas fa-user"></i></span>
                  </div>
                  <input type="text" name="Ad_Soyad" class="form-control" placeholder="Ad Soyad" value="<?php echo $sonuc['Ad_Soyad']; ?>">
                </div>
              </div>
              <div class="form-group">
                  <label>Plaka</label>
                  <div class="input-group mb-3">
                  <div class="input-group-prepend">
                    <span class="input-group-text"><i class="fas fa-car"></i></span>
                  </div>
                  <input type="text" name="Plaka" class="form-control" placeholder="Plaka" value="<?php echo $sonuc2['Plaka']; ?>">
                </div>
              </div>
              
              <div class="row">
              <div class="col-sm-6">
              <div class="form-group">
                  <label for="exampleInputEmail1">Telefon</label>
                  <div class="input-group mb-3">
                  <div class="input-group-prepend">
                    <span class="input-group-text"><i class="fas fa-phone"></i></span>
                  </div>
                  <input type="text" name="Telefon" class="form-control" placeholder="Telefon">
                </div>
              </div>
              </div>
              
              <div class="col-sm-6">
              <div class="form-group">
                  <label>Yakın Telefon</label>
                  <div class="input-group">
                    <div class="input-group-prepend">
                      <span class="input-group-text"><i class="fas fa-phone"></i></span>
                    </div>
                    <input type="text" name="YTelefon" class="form-control" placeholder="Yakın Telefon">
                  </div>
                  <!-- /.input group -->
                </div>
                </div>
                
                <div class="col-sm-6">
                <div class="form-group">
                  <label>Doğum Tarihi</label>
                  <div class="input-group">
                    <div class="input-group-prepend">
                      <span class="input-group-text">
                        <i class="far fa-calendar-alt"></i>
                      </span>
                    </div>
                    <input type="text" name="DogumTarihi" class="form-control float-right" placeholder="01.01.2023">
                  </div>
                  <!-- /.input group -->
                </div>
                </div>
                

                <!-- select -->
                <div class="col-sm-6">
                   <div class="form-group">
                        <label>İkametgah</label>
                        <select class="form-control" name="Ikametgah">
                          <option>Merkez</option>
                          <option>Çerkezköy</option>
                          <option>Çorlu</option>
                          <option>Kapaklı</option>
                          <option>KızılPınar</option>
                          <option>Karaağaç</option>
                          <option>Ergene</option>
                          <option>Hayrabolu</option>
                          <option>Muratlı</option>
                          <option>Saray</option>
                          <option>Süleymanpaşa</option>
                          <option>Şarköy</option>
                        </select>
                        </div>
                        </div>
                   <div class="col-sm-6">
                   <div class="form-group">
                        <label>Kan Grubu</label>
                        <select class="form-control" name="KanGrubu">
                          <option>0 ( Rh ) +</option>
                          <option>0 ( Rh ) -</option>
                          <option>A ( Rh ) +</option>
                          <option>A ( Rh ) -</option>
                          <option>B ( Rh ) +</option>
                          <option>B ( Rh ) -</option>
                          <option>AB ( Rh ) +</option>
                          <option>AB ( Rh ) -</option>
                        </select>
                        </div>
                        </div>
                        <div class="col-sm-6">
                   <div class="form-group">
                        <label>Tişört Bedeni</label>
                        <select class="form-control" name="Tisort">
                          <option>XS</option>
                          <option>S</option>
                          <option>M</option>
                          <option>L</option>
                          <option>XL</option>
                          <option>XXL</option>
                          <option>3XL</option>
                        </select>
                        </div>
                        </div>
                        
                        <div class="col-sm-6">
                   <div class="form-group">
                        <label>Sweat Bedeni</label>
                        <select class="form-control" name="Sweat">
                          <option>XS</option>
                          <option>S</option>
                          <option>M</option>
                          <option>L</option>
                          <option>XL</option>
                          <option>XXL</option>
                          <option>3XL</option>
                        </select>
                        </div>
                        </div>
                        
                        <div class="col-sm-6">
                   <div class="form-group">
                        <label>Yetki Durumu</label>
                        <select class="form-control" name="Yetki">
                          <option>Üye</option>
                          <option>Bayan Üye</option>
                          <option>Medya</option>
                          <option>Admin</option>
                          <option>Askerde</option>
                          <option>Araç Satılmış</option>
                        </select>
                        </div>
                        </div>
                  </div>
                  </div>
            </div>
            <form>
            <div class="modal-footer justify-content-between">
              <button type="button" class="btn btn-default" data-dismiss="modal">Kapat</button>
              <a href="UyeDuzenle.php?Kimlik=<?php echo $sonuc['Kimlik']; ?>" class="btn btn-success">Güncelle</a>
            </div>
          </div>
          <!-- /.modal-content -->
        </div>
        <!-- /.modal-dialog -->
      </div>
      <!-- /.modal -->
                  
        <?php include_once 'Alt.php'; ?>

<?php
if ($_GET)
{
    include("../../config/baglan.php"); // veritabanı bağlantımızı sayfamıza ekliyoruz.
// id'si seçilen veriyi silme sorgumuzu yazıyoruz.
if ($baglanti->query("UPDATE FROM Deneme WHERE Kimlik =".(int)$_GET['Kimlik']))
{
}
}
?>