query($query);
header('Location: admin_panel.php');
exit;
}
// Add subject
if (isset($_POST['add_subject'])) {
$name = $_POST['name'];
$query = "INSERT INTO subjects (name) VALUES ('$name')";
$conn->query($query);
header('Location: admin_panel.php');
exit;
}
// Show all student results
if (isset($_POST['show_results'])) {
$query = "SELECT * FROM results";
$result = $conn->query($query);
if ($result->num_rows > 0) {
echo "All Student Results:
";
echo "";
echo "| Student ID | Subject ID | Mark |
|---|
";
while ($row = $result->fetch_assoc()) {
echo "| ". $row['student_id']. " | ". $row['subject_id']. " | ". $row['mark']. " |
";
}
echo "
";
} else {
echo "No results found";
}
}
// Filter student results
if (isset($_POST['filter_results'])) {
$student_id = $_POST['student_id'];
$query = "SELECT * FROM results WHERE student_id = '$student_id'";
$result = $conn->query($query);
if ($result->num_rows > 0) {
echo "Filtered Student Results:
";
echo "";
echo "| Student ID | Subject ID | Mark |
|---|
";
while ($row = $result->fetch_assoc()) {
echo "| ". $row['student_id']. " | ". $row['subject_id']. " | ". $row['mark']. " |
";
}
echo "
";
} else {
echo "No results found";
}
}
?>
Admin Panel
Admin Panel
Insert Mark:
Add Subject:
Show All Student Results:
Filter Student Results: