forked from TinggTechnologies/Florierenparklaneis
-
Notifications
You must be signed in to change notification settings - Fork 0
/
admin-manage-library.php
128 lines (99 loc) · 4.42 KB
/
admin-manage-library.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
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
<?php require "admin-header.php"; ?>
<div class="container mt-5 pt-5">
<div class="row justify-content-center">
<div class="col-lg-4">
<nav>
<ol class="breadcrumb">
<li class="breadcrumb-item"><a href="admin-dashboard.php"><i class="bi bi-house-door"></i></a></li>
<li class="breadcrumb-item"><a href="#">Manage Library <i class="bi bi-people" style="font-size: 1.2rem; color: green;"></i></a></li>
</ol>
</nav>
<div class="card">
<div class="card-body pt-3">
<div class="text-center pb-2">
<i class="bi bi-exclamation-circle text-success" style="font-size: 2.5rem;"></i>
</div>
<p>You can manage the Library by verifying the books uploaded by the teachers.</p>
<form action="<?= htmlspecialchars($_SERVER['PHP_SELF']); ?>" method="post">
<select name="class" class="form-control form_data">
<option value="">Select Class</option>
<?php
$sql = "SELECT class FROM class";
$stmt = $conn->prepare($sql);
$stmt->execute();
$result = $stmt->get_result();
if($result->num_rows > 0){
while($row = $result->fetch_assoc()){
echo '
<option value='.$row['class'].'>'.$row['class'].'</option>
';
}
}
?>
</select>
</div>
<div class="container pb-3">
<button type="submit" class="btn btn-success form-control mb-3" name="admin-manage-library" style="border-radius: 15px;">Manage Library</button>
<a href="admin-existing-library.php">View Existing Library</a>
</div>
</form>
<?php
$error = [];
if (isset($_POST['admin-manage-library'])) {
$class = $_POST['class'];
if(count($error) === 0){
$sql = "SELECT * FROM library WHERE class='$class' and verify='0' ORDER BY library_id DESC";
$stmt = $conn->prepare($sql);
$stmt->execute();
$result = $stmt->get_result();
if($result->num_rows > 0){
echo '
<table class="table table-bordered">
<thead>
<tr>
<th scope="col">Staff image</th>
<th scope="col">Class</th>
<th scope="col">Staff Name</th>
<th scope="col">Action</th>
</tr>
</thead>
<tbody>
';
while($fetch = $result->fetch_assoc()){
$teacher_id = $fetch['staff_id'];
$sql = "SELECT * FROM staff WHERE unique_id='$teacher_id'";
$stmt = $conn->prepare($sql);
$stmt->execute();
$get_result = $stmt->get_result();
if($get_result->num_rows > 0){
$fetch_staff = $get_result->fetch_assoc();
echo '
<tr>
<td><img style="height: 70px; width: 70px;" src="uploads/'.$fetch_staff['image'].'" class="img-fluid" /></td>
<td>'.$fetch_staff['class'].'</td>
<td>'.$fetch_staff['lastname'].' '. $fetch_staff['firstname'].'</td>
<td><a href="admin-view-library.php?library_id='.$fetch['library_id'].'"><i class="bi bi-box-arrow-up fs-5" style="color: green;"></i></a></td>
</tr>
';
}
}
echo '
</tbody>
</table>
';
}
else{
echo "<div class='text-center py-1 text-danger fs-5 fw-bold'>
<i class='bi bi-x-circle text-danger' style='font-size: 2.5rem;'></i><br />
No Book found</div>";
}
}
}
?>
</div>
</div>
</div>
</div>
</div>
</div>
<?php require "main-footer.php"; ?>