Untitled
unknown
plain_text
a month ago
3.1 kB
3
Indexable
Never
<?php
session_start();
// Bağlantıyı mevcut baglan.php dosyasından dahil edelim
require_once 'baglan.php';
// users tablosundan verileri çekelim
$query = $db->query("SELECT id, tc_no, ad_soyad, email, telefon, universite, puan, basvuru_tarihi FROM users");
?>
<!DOCTYPE html>
<html lang="tr">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Burs Başvuru Listesi</title>
<!-- Bootstrap veya başka CSS dosyaları buraya eklenebilir -->
</head>
<body>
<div class="page-header">
<div class="page-title mt-0 mb-0">
<h3>Burs Başvuruları</h3>
<div class="crumbs">
<ul id="breadcrumbs" class="breadcrumb">
<li><a href="index.html"><i class="icon-home menu-icon"></i></a></li>
<li><a href="#">Burs Başvuruları</a></li>
<li class="active"><a href="#">Burs Başvuru Listesi</a></li>
</ul>
</div>
</div>
</div>
<div class="card">
<form action="../_class/yonetim_islem.php" method="POST">
<div class="card-body">
<div class="row mb-3">
<div class="col-lg-12">
<a href="uye-ekle.html" class="btn btn-primary btn-sm mr-1">
<i class="icon-plus font-12"></i> Yeni Burs Başvurusu Ekle
</a>
</div>
</div>
<div class="table-responsive">
<table id="order-listingg" class="table table-bordered table-hover">
<thead class="headbg">
<tr>
<th>Sıra</th>
<th>T.C. No</th>
<th>Ad Soyad</th>
<th>E-Posta</th>
<th>Telefon</th>
<th>Üniversite</th>
<th>Puan</th>
<th>Başvuru Tarihi</th>
</tr>
</thead>
<tbody>
<?php
$i = 1;
while ($user = $query->fetch(PDO::FETCH_ASSOC)) {
echo "<tr>";
echo "<td>{$i}</td>";
echo "<td>{$user['tc_no']}</td>";
echo "<td>{$user['ad_soyad']}</td>";
echo "<td>{$user['email']}</td>";
echo "<td>{$user['telefon']}</td>";
echo "<td>{$user['universite']}</td>";
echo "<td>{$user['puan']}</td>";
echo "<td>{$user['basvuru_tarihi']}</td>";
echo "</tr>";
$i++;
}
?>
</tbody>
</table>
</div>
</div>
</form>
</div>
</body>
</html>
Leave a Comment