query('SELECT id, name FROM schools ORDER BY name');
$schools = $schools_stmt->fetchAll();
// Handle form submissions
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
$name = trim($_POST['name']);
$school_id = $_POST['school_id'];
if (isset($_POST['add_program'])) {
if (!empty($name) && !empty($school_id)) {
$stmt = $pdo->prepare('INSERT INTO programs (name, school_id) VALUES (?, ?)');
$stmt->execute([$name, $school_id]);
}
} elseif (isset($_POST['update_program'])) {
if (!empty($name) && !empty($school_id) && !empty($id)) {
$stmt = $pdo->prepare('UPDATE programs SET name = ?, school_id = ? WHERE id = ?');
$stmt->execute([$name, $school_id, $id]);
}
header('Location: admin_programs.php');
exit;
} elseif (isset($_POST['delete_program'])) {
if (!empty($id)) {
$stmt = $pdo->prepare('DELETE FROM programs WHERE id = ?');
$stmt->execute([$id]);
}
header('Location: admin_programs.php');
exit;
}
}
?>
Assessment Planning: Programs
← Back to Admin Dashboard
prepare('SELECT * FROM programs WHERE id = ?');
$stmt->execute([$id]);
$program = $stmt->fetch();
?>
Edit Program
prepare('SELECT * FROM programs WHERE id = ?');
$stmt->execute([$id]);
$program = $stmt->fetch();
?>
Delete Program
Are you sure you want to delete the program ""?
Add New Program
Existing Programs
| ID |
Name |
School |
Actions |
query('SELECT p.id, p.name, s.name AS school_name FROM programs p JOIN schools s ON p.school_id = s.id ORDER BY p.id');
while ($row = $stmt->fetch()) {
echo "";
echo "| " . htmlspecialchars($row['id']) . " | ";
echo "" . htmlspecialchars($row['name']) . " | ";
echo "" . htmlspecialchars($row['school_name']) . " | ";
echo '
Edit
Delete
| ';
echo "
";
}
?>