-
-
Notifications
You must be signed in to change notification settings - Fork 5
/
uye-listele.php
97 lines (86 loc) · 4.44 KB
/
uye-listele.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
<?php include('includes/header.php'); ?>
<div class="container mx-auto px-2">
<div class="flex flex-wrap">
<div class="flex items-center py-4 w-full">
<div class="w-full">
<div class="">
</div>
</div>
</div>
</div>
</div>
<!--end container-->
<div class="container mx-auto px-2 min-h-[calc(100vh-138px)] relative pb-14 ">
<div class="grid md:grid-cols-12 lg:grid-cols-12 xl:grid-cols-12 gap-4 mb-4">
<div class="sm:col-span-12 md:col-span-12 lg:col-span-12 xl:col-span-12 ">
<div class="card h-full">
<div class="card-header">
<h4 class="card-title">Üye Listesi</h4>
</div>
<!--end card-header-->
<div class="card-body">
<a href="functions/uye-liste-ciktisi.php"><button id="gider-indir-button" type="submit"
class="btn bg-blue-500 text-white hover:bg-blue-600">Üye Listesi Excel
İndir</button></a>
<br>
<div class="relative overflow-x-auto sm:rounded">
<table class="w-full text-sm text-left text-gray-500 dark:text-gray-400" id="datatable_1">
<thead
class="text-xs text-gray-700 uppercase bg-gray-50 dark:bg-slate-700 dark:text-gray-400">
<tr>
<th scope="col" class="px-6 py-3">
Ad Soyad
</th>
<th scope="col" class="px-6 py-3">
Üyelik No
</th>
<th scope="col" class="px-6 py-3">
TCKN
</th>
<th scope="col" class="px-6 py-3">
Meslek
</th>
<th scope="col" class="px-6 py-3">
İşlemler
</th>
</tr>
</thead>
<tbody>
<?php
$sql = "SELECT id , uyelik_no, ad, soyad, tckn, meslek FROM uye_bilgi";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// output data of each row
while ($row = $result->fetch_assoc()) {
echo '<tr class="bg-white border-b dark:bg-gray-800 dark:border-gray-700 hover:bg-gray-50 dark:hover:bg-slate-700/50">
<th scope="row" class="px-6 py-4 font-medium text-gray-900 dark:text-white whitespace-nowrap">' . $row["ad"] . ' ' . $row["soyad"] . '</th>
<td class="px-6 py-4">' . $row["uyelik_no"] . '</td>
<td class="px-6 py-4">' . $row["tckn"] . '</td>
<td class="px-6 py-4">' . $row["meslek"] . '</td>
<td class="px-6 py-4">
<a href="uye-islemler.php?id=' . $row["id"] . '" class="font-medium text-blue-600 dark:text-blue-500 hover:underline">İşlemler</a>
</td>
</tr>';
}
} else {
}
?>
</tbody>
</table>
</div>
</div>
<!--end card-body-->
</div>
<!--end card-->
</div>
</div>
</div>
<?php include('includes/footer.php'); ?>
</div>
<!--end container-->
<script src="assets/libs/simplebar/simplebar.min.js"></script>
<script src="assets/libs/simple-datatables/umd/simple-datatables.js"></script>
<script src="assets/js/pages/datatable.init.js"></script>
<script src="assets/js/app.js"></script>
</body>
</html>