<?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">×</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']))
{
}
}
?>üyeleri listeledim düzenle butonu koydum basınca modal penceresi açılıyor oraya üyenin verilerini çekmesini istiyorum ardından güncelle butonu ile üyeyi güncellemesini istiyorum