prepare("DELETE FROM department WHERE DEPT_CODE = ?");
$stmt->execute([$id]);
header("Location: departments.php");
exit();
} catch(PDOException $e) {
die("Delete failed: " . $e->getMessage());
}
}
// Handle Create/Update Operations
if($_SERVER['REQUEST_METHOD'] === 'POST') {
$deptCode = $_POST['dept_code'] ?? null;
$deptName = $_POST['dept_name'];
$schoolCode = $_POST['school_code'];
try {
if(isset($_POST['create'])) {
$stmt = $pdo->prepare("INSERT INTO department (DEPT_NAME, SCHOOL_CODE) VALUES (?, ?)");
$stmt->execute([$deptName, $schoolCode]);
} elseif(isset($_POST['update'])) {
$stmt = $pdo->prepare("UPDATE department SET DEPT_NAME = ?, SCHOOL_CODE = ? WHERE DEPT_CODE = ?");
$stmt->execute([$deptName, $schoolCode, $deptCode]);
}
header("Location: departments.php");
exit();
} catch(PDOException $e) {
die("Operation failed: " . $e->getMessage());
}
}
// Fetch data for display
$departments = $pdo->query("
SELECT d.*, s.SCHOOL_NAME
FROM department d
JOIN school s ON d.SCHOOL_CODE = s.SCHOOL_CODE
")->fetchAll(PDO::FETCH_ASSOC);
$schools = $pdo->query("SELECT * FROM school")->fetchAll();
require_once 'header.php';
?>
Departments Management