require_once __DIR__ . '/../model/admin_roles_db.php';
$action = strtolower(filter_input(INPUT_POST, 'action'));
if ($action == NULL) {
$action = strtolower(filter_input(INPUT_GET, 'action'));
if ($action == NULL) {
$action = 'list_roles';
}
}
verify_admin();
switch ($action) {
case 'list_roles':
$assigned_roles = get_assigned_roles();
$users = get_users();
$roles = get_roles();
$teacherList = get_teacher_list();
include __DIR__ . "/view.php";
break;
case 'modify_admin':
$choice = filter_input(INPUT_POST, 'choice');
if ($choice == "Back") {
header("Location: ..");
}
if ($choice == "Add Admin") {
$usr_id = filter_input(INPUT_POST, 'user_drop');
$usr_role_cde = filter_input(INPUT_POST, 'role_drop');
add_admin($usr_id, $app_cde, $usr_role_cde);
}
$assigned_roles = get_assigned_roles();
$users = get_users();
$roles = get_roles();
<ul class="list-inline">
<li><a href="reports.php?tab=teachers&sortby=1">Last Name</a></li>
<li><a href="reports.php?tab=teachers&sortby=2">First Name</a></li>
<li><a href="reports.php?tab=teachers&sortby=3">Instrument</a></li>
</ul>
<div class="text-center">
<table class="table table-striped text-center">
<?php
$link = connectDB();
//out teachers table
if (isset($_GET['sortby'])) {
$sort = $_GET['sortby'];
$results = get_teacher_list($sort);
} else {
$sort = 0;
$results = get_teacher_list($sort);
}
if (!$results) {
echo "Database Error";
} else {
// table headers
echo '<thead><tr>';
echo '<th><div class="text-center"><a href="edit-teacher-form.php?teacher=', 'new', '">
<img class="table-icon" src="./res/image/add-user.png"></a></div></th>
<th><div class="text-center"></div></th>
<th><div class="text-center"></div></th>
<th><div class="text-center">Last Name</div></th>
<th><div class="text-center">First Name</div></th>
<th><div class="text-center">Banner ID</div></th>
<th><div class="text-center">Faculty Status</div></th>
<th><div class="text-center">Instrument</div></th>
