forked from TinggTechnologies/Florierenparklaneis
-
Notifications
You must be signed in to change notification settings - Fork 0
/
admin-result-checker.php
121 lines (108 loc) · 4.15 KB
/
admin-result-checker.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
<?php
require "admin-header.php";
?>
<?php
if(isset($_GET['student_id'])){
$student_id = $_GET['student_id'];
}
$sql = "SELECT * FROM users WHERE student_id=?";
$stmt = $conn->prepare($sql);
$stmt->bind_param('s', $student_id);
$stmt->execute();
$get_result = $stmt->get_result();
if($get_result->num_rows > 0){
$fetch_data = $get_result->fetch_assoc();
}
?>
<div class="container mt-5 pt-4 text-center">
<div class="row justify-content-center">
<div class="col-lg-4">
<nav>
<ol class="breadcrumb">
<li class="breadcrumb-item"><a href="dashboard.php"><i class="bi bi-house-door"></i></a></li>
<li class="breadcrumb-item"><a href="#">Manage Result <i class="bi bi-receipt-cutoff" style="font-size: 1.2rem;"></i></a></li>
</ol>
</nav>
<section class="signup py-4">
<div>
<div class="card text-center">
<div class="card-body">
<div class="text-center py-2">
<i class="bi bi-exclamation-circle text-success" style="font-size: 2.5rem;"></i>
</div>
<p class="py-2">To Manage <span class="text-success fw-bold"><?= $fetch_data['lastname']; ?></span> result you have to select the term and session you wish to check</p>
<form method="POST" action="<?php echo htmlspecialchars($_SERVER['PHP_SELF']); ?>">
<div class="row mb-3">
<div class="col-sm-12">
<select name="term" id="" class="form-select" aria-label="Default select example">
<option value="">select term</option>
<?php
$sql_term = "SELECT term FROM term";
$term_stmt = $conn->prepare($sql_term);
$term_stmt->execute();
$term_result = $term_stmt->get_result();
if($term_result->num_rows > 0){
while($term_row = $term_result->fetch_assoc()){
echo '
<option value='.$term_row['term'].'>'.$term_row['term'].'</option>
';
}
}
?>
</select>
<div class="text-danger mt-2">
<?php
if(isset($error['term'])){
echo $error['term'];
}
?>
</div>
</div>
</div>
<div class="row">
<div class="col-sm-12">
<select name="session" id="session" class="form-select" aria-label="Default select example">
<option value="">Select session</option>
<?php
$sql_session = "SELECT session FROM session";
$session_stmt = $conn->prepare($sql_session);
$session_stmt->execute();
$session_result = $session_stmt->get_result();
if($session_result->num_rows > 0){
while($session_row = $session_result->fetch_assoc()){
echo '
<option value='.$session_row['session'].'>'.$session_row['session'].'</option>
';
}
}
?>
</select>
<div class="text-danger mt-2">
<?php
if(isset($error['section'])){
echo $error['section'];
}
?>
</div>
</div>
</div>
<div class="text-danger">
<?php
if(isset($error['result'])){
echo $error['result'];
}
?>
</div>
</div>
<input type="hidden" name="student_id" value="<?php echo $student_id; ?>">
<div class="container">
<button type="submit" class="btn btn-primary form-control bg-success mb-5" style="border-radius: 15px;" name="result-btn">Check Result</button>
</div>
</form>
</div>
</div>
</div>
</section>
</div>
</div>
<?php require "main-footer.php"; ?>