-
Notifications
You must be signed in to change notification settings - Fork 0
/
manage_users_up.php
53 lines (52 loc) · 1.85 KB
/
manage_users_up.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
<div class="table-responsive-sm" style="max-height: 870px;">
<table class="table">
<thead class="table-primary">
<tr>
<th>ID karta</th>
<th>F.I.SH.</th>
<th>Jinsi</th>
<th>Seriya raqami</th>
<th>Sana</th>
<th>O`tish joyi</th>
</tr>
</thead>
<tbody class="table-secondary">
<?php
//Connect to database
require'connectDB.php';
$sql = "SELECT * FROM users ORDER BY id DESC";
$result = mysqli_stmt_init($conn);
if (!mysqli_stmt_prepare($result, $sql)) {
echo '<p class="error">SQL Error</p>';
}
else{
mysqli_stmt_execute($result);
$resultl = mysqli_stmt_get_result($result);
if (mysqli_num_rows($resultl) > 0){
while ($row = mysqli_fetch_assoc($resultl)){
?>
<TR>
<TD><?php
if ($row['card_select'] == 1) {
echo "<span><i class='glyphicon glyphicon-ok' title='The selected UID'></i></span>";
}
$card_uid = $row['card_uid'];
?>
<form>
<button type="button" class="select_btn" id="<?php echo $card_uid;?>" title="select this UID"><?php echo $card_uid;?></button>
</form>
</TD>
<TD><?php echo $row['username'];?></TD>
<TD><?php echo $row['gender'];?></TD>
<TD><?php echo $row['serialnumber'];?></TD>
<TD><?php echo $row['user_date'];?></TD>
<TD><?php echo ($row['device_dep'] == "0") ? "All" : $row['device_dep'];?></TD>
</TR>
<?php
}
}
}
?>
</tbody>
</table>
</div>