prepare("DELETE FROM professor WHERE PROF_NUM = ?"); $stmt->execute([$id]); header("Location: professors.php"); exit(); } catch(PDOException $e) { die("Delete failed: " . $e->getMessage()); } } // Handle Create/Update Operations if($_SERVER['REQUEST_METHOD'] === 'POST') { $profNum = $_POST['prof_num'] ?? null; $schoolCode = $_POST['school_code']; $deptCode = $_POST['dept_code']; $specialty = $_POST['specialty']; $rank = $_POST['rank']; $lname = $_POST['lname']; $fname = $_POST['fname']; $initial = $_POST['initial']; $email = $_POST['email']; try { if(isset($_POST['create'])) { $stmt = $pdo->prepare("INSERT INTO professor (SCHOOL_CODE, DEPT_CODE, PROF_SPECIALTY, PROF_RANK, PROF_LNAME, PROF_FNAME, PROF_INITIAL, PROF_EMAIL) VALUES (?, ?, ?, ?, ?, ?, ?, ?)"); $stmt->execute([$schoolCode, $deptCode, $specialty, $rank, $lname, $fname, $initial, $email]); } elseif(isset($_POST['update'])) { $stmt = $pdo->prepare("UPDATE professor SET SCHOOL_CODE = ?, DEPT_CODE = ?, PROF_SPECIALTY = ?, PROF_RANK = ?, PROF_LNAME = ?, PROF_FNAME = ?, PROF_INITIAL = ?, PROF_EMAIL = ? WHERE PROF_NUM = ?"); $stmt->execute([$schoolCode, $deptCode, $specialty, $rank, $lname, $fname, $initial, $email, $profNum]); } header("Location: professors.php"); exit(); } catch(PDOException $e) { die("Operation failed: " . $e->getMessage()); } } // Fetch data for display $professors = $pdo->query(" SELECT p.*, s.SCHOOL_NAME, d.DEPT_NAME FROM professor p JOIN school s ON p.SCHOOL_CODE = s.SCHOOL_CODE JOIN department d ON p.DEPT_CODE = d.DEPT_CODE ")->fetchAll(PDO::FETCH_ASSOC); $schools = $pdo->query("SELECT * FROM school")->fetchAll(); $departments = $pdo->query("SELECT * FROM department")->fetchAll(); require_once 'header.php'; ?>

Professors Management

prepare("SELECT * FROM professor WHERE PROF_NUM = ?"); $editProf->execute([$_GET['edit']]); $prof = $editProf->fetch(); ?>

Edit Professor

Add New Professor

First Name

Last Name

Initial

Specialty

Rank

School

Department

Cancel

#	Name	Email	Rank	Specialty	School	Department	Actions
							Edit Delete